Viewing 15 posts - 57,871 through 57,885 (of 59,066 total)
Yeah... I forgot that you've been around a long time... didn't even read to see who did the post, Farrell.
Speaking of being around for a long time, whatcha doin'...
August 8, 2006 at 6:20 pm
Don't forget... temp tables are tables, too. You can add indexes...
August 8, 2006 at 6:13 am
You also need to make the 2nd line of the format file equal to the number of columns listed in the format file...
August 8, 2006 at 6:09 am
Your humility is surpassed only by your good nature, John. Well done.
The only time you can do something like what you ask automatically is during the BCP process where you...
August 8, 2006 at 6:03 am
Do a search for "aux calendar table" and "auxillary calendar table" on this site and Google... you'll find lot's of examples on how to make a calendar table. Most things...
August 8, 2006 at 5:29 am
The point is, Mark, instead of having to read through the code to find what you want, you only have to lightly scim through the comments to find out what...
August 8, 2006 at 5:04 am
I will also now shamelssly plug my SQL PROGRAMMING STYLE book that deals with these issues... |
August 7, 2006 at 8:16 pm
1801 --Bundled Services, not including VOIP your documentation is out of date, and the... |
August 7, 2006 at 7:58 pm
Outstanding! That's just what I was looking for! Thank your for the help, Aaron.
August 7, 2006 at 10:37 am
Thanks, Colin,
Yeah, my problem with "just a case of trying" is we don't have it, yet... they keep threatening me with the offer of the Developer's Edition but I don't...
August 7, 2006 at 9:42 am
A basic rule of thumb: if you have to comment the code to explain what you did and... |
August 7, 2006 at 6:13 am
I guess I don't get it... if Table A is referenced by Table B, it would appear that Table A is a parent of Table B. Why would you want...
August 7, 2006 at 5:17 am
How true... fortunately, I have DBA's that do notice the difference
but it's good to check.
August 7, 2006 at 4:16 am
Having a calendar table would certainly assure correctness. If you can do that, that would probably be the best way to go...
August 7, 2006 at 4:12 am
Correct... SQL Server's UPDATE statement is one of the more useful ones in that it actually has TWO from clauses that are specifiable... most people leave out the first FROM...
August 6, 2006 at 9:58 pm
Viewing 15 posts - 57,871 through 57,885 (of 59,066 total)