Viewing 15 posts - 21,946 through 21,960 (of 26,484 total)
Yes, you can. I am including a partial copy of the ALTER TABLE statement from BOL:
ALTER TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name...
March 17, 2009 at 9:37 am
Lynn Pettis (3/17/2009)
d_walker (3/17/2009)
SUM(CASE WHEN DateDiff(d,GETDATE(),l.[Due Date]) between -31 and -60 THEN d.[Amount (LCY)] ELSE 0...
March 17, 2009 at 8:46 am
d_walker (3/17/2009)
SUM(CASE WHEN DateDiff(d,GETDATE(),l.[Due Date]) between -31 and -60 THEN d.[Amount (LCY)] ELSE 0 END) as...
March 17, 2009 at 8:42 am
Mh (3/17/2009)
I am really sorry for not responding to the questions. Actually the issue has been resolved. Thanks for all your help!!
Forum etiquette would have you post your resolution so...
March 17, 2009 at 8:08 am
Well, if you've checked my profile you know I live in Colorado Springs, CO. My drink of choice is Dr Pepper. Mostly the diet version, but I do...
March 17, 2009 at 7:23 am
Can you provide more information about the tables? The DDL (CREATE TABLE statments) and the indexes defined would be beneficial.
The key idea is to identify what records you want...
March 16, 2009 at 11:33 pm
Michael Valentine Jones (3/16/2009)
March 16, 2009 at 11:22 pm
You know what? We should move this conversation back to THE THREAD before we actually do have THE SON OF THREAD going. Care to join me?
March 16, 2009 at 11:09 pm
Bruce W Cassidy (3/16/2009)
[font="Verdana"]...and thus was born the son of thread. Oh, wait: we need three wise people. Who is up for a camel ride?[/font]
I don't ride no...
March 16, 2009 at 11:05 pm
Lynn Pettis (3/16/2009)
Bob Hovious (3/16/2009)
I'm in the states, and the choice of beverage is secondary to the opportunity for a good conversation. Do you do caffeine?Soda, not coffee.
Well,...
March 16, 2009 at 11:03 pm
Bob Hovious (3/16/2009)
I'm in the states, and the choice of beverage is secondary to the opportunity for a good conversation. Do you do caffeine?
Soda, not coffee.
March 16, 2009 at 10:59 pm
Bob Hovious (3/16/2009)
Guiness is better. Perhaps some day we'll have opportunity to knock back a pint or two, Lynn. First round is on me.
You'll shoot me...
March 16, 2009 at 9:29 pm
john.arnott (3/16/2009)
Bob Hovious (3/16/2009)
The obvious question to ask is:
If the other Mh wasn't the person that started this thread,...
March 16, 2009 at 9:25 pm
steve dassin (3/16/2009)
Lynn Pettis (3/16/2009)
steve dassin (3/16/2009)
To see for yourself visit my blog (for explanations and examples) or check out the system documentation (chm file):
http://www.geocities.com/d4tosql/D4/Dataphor.zip
Better yet I invite you to...
March 16, 2009 at 9:21 pm
I am not sure if anyone else feels this way, but I won't be hurt if Steve closed this thread.
March 16, 2009 at 8:40 pm
Viewing 15 posts - 21,946 through 21,960 (of 26,484 total)