SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

select l.loanid, l.branchoffice, l.AcquiredFrom,

l.previouslnnum, b.lastname, b.firstmiddlename,

p.addressline1, p.addressline2, p.city,

p.state, p.zip, l.originalamt,

s.primstat, p.appraisalvalue, l.glplan

--FROM loan L, property P, borrower B, status s

FROM loan L

...

Okay..pretty sure I need the columns in the other tables

I have no idea how to do that can you give me an example?

That didn't work, here's the entire statment:

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

select distinct l.loanid, l.branchoffice, l.AcquiredFrom,

l.previouslnnum, b.lastname, b.firstmiddlename,

p.addressline1, p.addressline2, p.city,

p.state, p.zip, l.originalamt,

s.primstat, p.appraisalvalue, l.glplan

--FROM loan L, property P, borrower B,...

Thanks man

Thanks Bro!!

Thanks Lowell!

Awesome

THANKS GUYS

GOOD KARMA TO YOU ALL!!

I didn't see that...thank you..

but when I remove the rem I get

I get zero byte files!!!

Can't understand why they are zero byte!

here's the output:

NULL

Starting copy...

NULL

0 rows copied.

Network packet size (bytes):...

here's the whole proc -

USE [MASTER]

GO

DECLARE@DBNVARCHAR(10)

DECLARE@sqlNVARCHAR(4000)

DECLARE@COMPNVARCHAR(75)

DECLARE@YRSMALLINT

DECLARE@MONTHTINYINT

SELECT@YR=2009

DECLARE DBS CURSOR FAST_FORWARD FOR

SELECT LTRIM(RTRIM([NAME]))

FROM SYS.[DATABASES]

WHERE NAME NOT IN ('MASTER','MODEL','MSDB','TEMPDB','DYNAMICS','DYNAMICSGP_UTILITIES','LPB_GREATPLAINSUTILS','SETUP')

ORDER BY NAME

OPEN DBS

FETCH NEXT FROM DBS INTO @DB

WHILE @@FETCH_STATUS = 0

BEGIN

SELECT@COMP=SUBSTRING(LTRIM([CMPNYNAM]),1,2) + '_'...

You rock

Thank you sooo much

Good karma to you and have a nice weekend.

Thanks Mark..

where do i put in the account numbers?

Very Interesting...and informative

Thanks guys....good karma to you all.

So there is no other form of SQL...

This is customer sensitive data, SSN#, etc....

I was told my predecessor had configured encryption, but all the data I have seen in all the databases..none of that is encrypted..

Wouldn't I...

I love this method only because I can leave it in place and it will always get the previous month.

but

when I use

WHERE ld.delq_dt >= DATEADD(month, DATEDIFF(month, 0, CURRENT_TIMESTAMP) -...