Viewing 15 posts - 49,891 through 49,905 (of 59,078 total)
It's just a test to see what the max number of OR's can be...
June 18, 2008 at 6:30 pm
Grant Fritchey (6/18/2008)
Ummmm. That was strange. Where the heck did the execution plan go?
Cool... it's not just my machine and it's not just me... gettin' old enough where I have...
June 18, 2008 at 6:17 pm
ramaanujamr (6/18/2008)
Hi All,This is what i want . Great. I just test with CUBE,ROLLEUP operator. Thanks for everyone.
Thanks.
Ram
Thanks for the feedback, Ram.
June 18, 2008 at 5:48 pm
You bet... thanks for the feedback... let us know if you have problems with the implementation.
June 18, 2008 at 5:46 pm
rbarryyoung (6/18/2008)
Jeff Moden (6/18/2008)
Easy to print? They contain CR/LF's... should print just fine if you display them in a text mode instead of a grid mode...
Well, sort of. ...
June 18, 2008 at 5:40 pm
We're trying to teach you to "fish"... lookup FROM in Books Online and find the writeup on "table_source".
June 18, 2008 at 3:36 pm
Nah... make it easy on yourself...
(IntegerConstant * IntegerColumn *1.0) / IntegerColumn = IntegerResult
June 18, 2008 at 3:28 pm
Ummm... take a look at the following subjects in Books Online...
ROLLUP operator
CUBE operator
GROUPING keyword
June 18, 2008 at 2:36 pm
The link that Kendal referred to has a full example of exactly how to do this along with certain explanations as to why you need to do (or not do)...
June 18, 2008 at 2:28 pm
Yep... a GUID would do it...
What do you want the unique column to look like and why? It may make a difference.
June 18, 2008 at 8:24 am
Suresh B. (6/18/2008)
CLR Integration Data Types ?
Yeaup... and what would you have it do? Fact is, you still can't store out of range dates in the database.
If the front...
June 18, 2008 at 8:17 am
Just curious... do you have any names like the following example?
Dr. and Mrs. J R van de Camp Rosenburg V MD. PHD. Esquire
June 18, 2008 at 8:07 am
On my way to work... I'll try to take a whack at this tonight... but, the split must produce an "array" and then the array must be reassembled by...
June 18, 2008 at 7:48 am
Easy to print? They contain CR/LF's... should print just fine if you display them in a text mode instead of a grid mode...
June 18, 2008 at 7:39 am
I agree... our DBA's have xp_CmdShell, sp_OA*, and a whole bunch of other "ad hoc" access turned off. But, they do allow it through stored procedures that are executed...
June 18, 2008 at 7:35 am
Viewing 15 posts - 49,891 through 49,905 (of 59,078 total)