Viewing 15 posts - 46 through 60 (of 63 total)
Thanks for the link Steve,
This is a lot more complex than I had hoped for but it looks like it should be what I was looking for.
Remember when a terabyte...
February 16, 2010 at 10:54 am
Thank you Jeff,
That explains the problem and suggests a solution. But I took the easy way out and violated a couple of Dr. Codd's rules and created a table in...
December 23, 2009 at 8:05 am
Hi Jeff,
Yes, I tried to remove the GO statements. I tried to replace them with ; as well.
With the GO statements in the query, the message is:
Error Source : Microsoft...
December 22, 2009 at 1:28 pm
Yes, I am still in need of getting this into DTS. The database is vendor provided and changes I make are problematic and make me responsible for any problems, real...
December 21, 2009 at 12:32 pm
Hi Jeff,
This is basically the code you gave me earlier, glad I didn't muck it up so badly as to be unrecognizable. 😛
As to the good Doctor, business development has...
December 19, 2009 at 12:54 pm
Thanks Adam,
I've tried that and it chokes on the "GO" statements. It doesn't run without them.
What I've tried is a simple OLE DB connection and a Text File (Destination) connected...
December 18, 2009 at 8:18 am
I guess I never came back to let everyone know that the suggestions worked great! Using a temp table to add the columns gave us what we needed.
I'm trying to...
December 17, 2009 at 1:02 pm
Thank you Seth,
I think this will do just what I need - apologies to those who read my erroneous message about errors.
Thanks again,
Norman
December 10, 2009 at 12:42 pm
Thank you Jeff -
When I copy and paste and run this code, I get errors. Is this SQL2000 code? Or does it need SQL2005?
The errors are:
Msg 156, Level 15,...
December 10, 2009 at 12:33 pm
Thank you Seth, new functions to learn about. I'll try this when I get back to work tomorrow. (We had a big snow storm and I'm at home today.)
I've been...
December 9, 2009 at 10:21 am
Sorry, should have done that - here is what I would like to get
Simpson, Homer JSimpsonHomer J
Simpson, Bartholomew JoJoSimpsonBartholomewNULL
Simpson,MaggieSimpsonMaggieNULL
Bouvier Simpson, Margorie "Marge"Bouvier SimpsonMargorieNULL
Simpson, Lisa M.SimpsonLisa M
Burns,Charles Montgomery "Monty"BurnsCharlesNULL
Smithers, Waylon Jr.SmithersWaylonNULL
Basically...
December 8, 2009 at 2:35 pm
I should add this is part of a much larger extract to provide data to a third party, so I don't know if I can get by using variables. The...
December 8, 2009 at 1:49 pm
Thank you Jeff for your input. When I run the example in SQL 2000, I don't get what I expected. It appears the offset is being subtracted from the month,...
June 3, 2009 at 12:00 pm
The offset is the number of minutes between my time (US Central) and UT so -300 would 5 hours and -360 would be 6 hours. I may not have been...
June 2, 2009 at 1:48 pm
Thank you Jack,
This looks like it should work but will have to wait until I get back into the office to test.
As for what happens if the offset is positive?...
May 29, 2009 at 2:55 pm
Viewing 15 posts - 46 through 60 (of 63 total)