Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.
SELECT SSG_Acquisition_All_T.Type, SSG_Acquisition_All_T.Received_From, SSG_Acquisition_All_T.MANUFACTURE, SSG_Acquisition_All_T.Firearm_Model, SSG_Acquisition_All_T.Firearm_Caliber, SSG_Acquisition_All_T.Item_Number, SSG_Acquisition_All_T.Serial_Number, SSG_Dispostion_All_T.Serial_Number AS DISP_SN, SSG_Dispostion_All_T.ItemNo AS DIS_ITEM, SSG_Dispostion_All_T.Ship_To_Name FROM SSG_Acquisition_All_T RIGHT OUTER JOIN SSG_Dispostion_All_T ON SSG_Acquisition_All_T.Serial_Number = SSG_Dispostion_All_T.Serial_Number WHERE (SSG_Acquisition_All_T.Serial_Number IS NULL) AND (CHARINDEX(' ', SSG_Dispostion_All_T.Serial_Number)) >0 ORDER BY DISP_SN
WHERE (SSG_Acquisition_All_T.Serial_Number IS NULL) AND RTRIM(CHARINDEX(' ', SSG_Dispostion_All_T.Serial_Number)) >0
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Check ALL SP in database make sure there are no errors||17||60|
|qry in a qry worked by week ending date! how do I get it to work by weeks (y-t-d) instead of one week at a time?||25||86|
|SQL Server 2008 R2, need a pivot/cross tab query...||4||48|
|SQL Database Restore 2008 R2||1||27|