Viewing 15 posts - 16 through 30 (of 57 total)
Thanks for the feedback guys. unfortunately I've been pushing our clients to convert over to distribution lists for years now, but the majority dont want to do it, so i'm...
June 10, 2011 at 4:19 pm
Thanks for the suggestions, guys! I'll have our sales team work with the clients to see if they will accept .csv, if so then then we'll go that route, otherwise...
March 9, 2011 at 11:17 am
Thanks, Mike. I was in the middle of re-writing my original post so it would be more intuitive as you suggested. I see what is going on in the script...
July 7, 2010 at 3:16 pm
Thanks for the reply. Iām having trouble coming up with the correct syntax for your solution, can you help? This is the direction I was going, but I could be...
June 23, 2010 at 1:46 pm
Thanks for the help Gsquared. The problem with the script you posted is that once you execute and it cycles to the next database on the list you receive the...
March 1, 2010 at 4:06 pm
Since that statement loops though multiple databases the declaration goes at the end so start and end dates are set when it runs against each new DB. Also, iit's a...
February 25, 2010 at 2:23 pm
Like I said, I tested these statements:
select @startdate = ''dateadd(mm,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))''
select @enddate = ''dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))''
and they failed. Did you test your code within a dynamic statement? Below is...
February 25, 2010 at 1:29 pm
Hi Pam,
I had already tried that and received the same error.
Thanks,
Code
February 25, 2010 at 1:17 pm
OMFG! *smacks forehead with sledge hammer*
Lynn, you rock!! Thanks!
January 15, 2010 at 12:01 pm
Hi Lynn,
This is what I have in the job as of right now.
SET @start_dt = (SELECT dateadd(day,datediff(day,0,GetDate())- 9,0)) --if RUNS SUNDAY, THIS GRABS FRIDAY @ 12:00AM OF THE...
January 15, 2010 at 11:54 am
Thanks for the link. I already am familiar with all those, it's the time portion im struggling with.
January 15, 2010 at 11:34 am
Thanks. I labled the column last night, and it got me a little futher, however I was getting a new error stating no column was mapped to the text file,...
January 15, 2010 at 9:57 am
Duh! Thats what I get for over thinking things. Thanks. š
November 10, 2009 at 12:30 pm
Viewing 15 posts - 16 through 30 (of 57 total)