Neat Sign up page

www.signupgenius.com

Histogram - How to get pivot in SQL Query showing same ACN from 3 different archiveID

select distinct A.Field1 as ACN,

(select count(Field1) from ssfields where ArchiveID = '1' and Field1=A.Field1) as Row_Count_1,

(select count(Field1) from ssfields where ArchiveID = '5' and Field1=A.Field1) as Row_Count_5,

(select count(Field1) from ssfields where ArchiveID = '8' and Field1=A.Field1) as Row_Count_8

from ssfields A

SQL Script NOT IN with multiple fields

SELECT COUNT(*)

FROM dbo.ssFields

WHERE field7='Legal'

AND  ArchiveID =  '1' --Travel Agency

AND (Field1 + ' ' + Field3 + ' ' + CONVERT(VARCHAR,Field5, 23) + ' ' + field12 + ' ' + field18) NOT IN(

       SELECT (Field1 + ' ' + Field3 + ' ' + CONVERT(VARCHAR,Field5, 23) + ' ' + field12 + ' ' + field18) AS CompareString

       FROM dbo.ssFields

       WHERE field7='Legal'

       AND  ArchiveID =  '8' --Travel Agency - Date Fix

)

SQL script to compare what is NOT IN...

SELECT COUNT(*)

FROM dbo.ssFields

WHERE field7='legal'

AND  ArchiveID =  '1' --Travel Agency

AND (Field1) NOT IN(

       SELECT (Field1) AS CompareString

       FROM dbo.ssFields

       WHERE field7='legal'

       AND  ArchiveID =  '8' --Travel Agency - Date Fix

)

New to GP: Basic Transaction Flow

New to GP: Setting up EFT for Payables and Sales

New to GP: Paid Transaction Removal

New to GP: 1099 Maintenance

Join us in this session about 1099...Understanding how GP records 1099 amounts...researching and validating 1099 data, how to provide correct tax information by updating 1099 information, and 1099s Printing/Filing.