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) -...

I didn't mean to upset anyone.

I was just trying to understand why it didn't work, now I do understand.

I really appreciate you guys taking the time to help.

Good karma to...

is this wrong?

original way:

WHERE

isnull(datediff(dd,ld.delq_dt,getdate()),0) < 30

this:

WHERE

isnull(datediff(dd,ld.delq_dt,'2009-09-30'),0) < 30

I'm not getting the same results

could it have something to do with not using the 'isnull' ?

thanks so much for helping me out...

I need the month of september

So...if I want to only see last months (september) then I would change it to

WHERE ld.delq_dt < dateadd(mm, datediff(mm, 0, '2009-09-30'), 0)

or

WHERE ld.delq_dt < dateadd(mm, datediff(mm, 0, '2009-30-09'), 0)