Viewing 15 posts - 53,806 through 53,820 (of 59,068 total)
Jpotucek,
C'mon... I'm trying to help... I need the answers to the questions I asked above so we can avoid the problems you're having...
November 30, 2007 at 8:48 am
Now isn't that odd... aren't those the same stages as a job? 😉
November 29, 2007 at 9:46 pm
Better think about DBCC UPDATEUSAGE once in a while....
November 29, 2007 at 9:41 pm
Heh... I know the feeling...
Study sp_ExecuteSQL in BOL... it'll show you how to do exactly what you want.
November 29, 2007 at 9:17 pm
It would be very helpful if you put this in just before the exec and printed out the result for us...
PRINT @strQuery
November 29, 2007 at 9:15 pm
Dang, Joe... between this and the NULLs problem, I'm thinking that you've landed in a doozy of a place. Who are these geniuses that you keep having fights about...
November 29, 2007 at 9:08 pm
I appologize ahead of time for the layout of my code on this page.
Heh... if you took 5 minutes out ahead of time to fix it, you wouldn't have...
November 29, 2007 at 8:59 pm
You might have a bit more luck getting a response to your posted this in the "Data Transformation Services" forum...
November 29, 2007 at 8:56 pm
Yeah... that's the disappointing truth...
I'm actually on vacation, right now... I'll see if I can find that script at work on Monday... it's in a piece of automation I...
November 29, 2007 at 8:51 pm
Heh... Jason, I'm sitting here reading where you wrote...
So if a NULL @variable is put in you won't return any records other than NULLS. Likewise, no matter what variable is...
November 29, 2007 at 8:26 pm
Heh... at the very least, I'll go outside to have a smoke before I hit the "GO" button. Gives me time to think about whether I need to reword...
November 29, 2007 at 8:11 pm
We have to compare the SRH table with contract_id and from the SRH table we have to take the field values which is lastly updated.. For example for single contract...
November 29, 2007 at 7:55 pm
Thanks, Ian... great feedback! I really appreciate it.
November 29, 2007 at 7:48 pm
dbaltazar (11/29/2007)
So let me ask a follow up question. Under what circumstance would a cursor be good? Small data set?
Another possible reason is if you have to write...
November 29, 2007 at 7:45 pm
Michael Meierruth (11/29/2007)
Jeff Moden (11/28/2007)
Heh... speaking of "details"... once done and you go to format it, you wanna use commas or periods for the thousand separators? 😀
FYI, in France they...
November 29, 2007 at 2:43 pm
Viewing 15 posts - 53,806 through 53,820 (of 59,068 total)