Viewing 5 posts - 1 through 6 (of 6 total)
I have it in a Stored Procedure that pulls 7 days of data. I'm thinking that my best bet is to populate two temp tables and pull from the temp...
June 16, 2014 at 11:16 am
Here is my query with identifying information removed.
SELECT'01' as [Record Type]
,fv.AccountNumber as [Account Number]
,g.GuarantorNameLast + ', ' + g.GuarantorNameFirst as [Guarantor Name]
,g.GuarantorAddress1 as [Guarantor Address 1]
,g.GuarantorAddress2 as [Guarantor Address 1]
,g.GuarantorCity...
June 16, 2014 at 11:09 am
Do you mean what tool? Mgt studio and via a sql job. Sorry if that is a really dumb answer.
June 16, 2014 at 10:35 am
They also have indexes on the keys that I am linking them with too.
June 16, 2014 at 10:30 am
They are on the same instance and easily linked together.
June 16, 2014 at 10:30 am
Viewing 5 posts - 1 through 6 (of 6 total)