Viewing 7 posts - 1 through 7 (of 7 total)
quote:
quote:
Quick brainteaser for our beginning DBA's: what's the quickest method to strip out...
November 27, 2003 at 6:41 pm
Instead of joining on a wild card, can you use either an embedded description or a key for the wildcard phrase?
An embedded description would look like the following (assuming that...
November 21, 2003 at 8:45 pm
I have to do this often for reporting purposes; it ain't easy, but this is relatively effecient (even though it uses both cursors and temp tables -- YUK).
--Example creation and...
November 21, 2003 at 11:19 am
"That won't be a good idea if you have 25 columns in the table and you need 24 of them selected. I will rather drop the column I do not...
November 21, 2003 at 4:51 am
Hey Shas
If the login that you are using to connect to the linked server has the appropriate permissions, then anything is possible. it all depends on how the servers...
November 20, 2003 at 6:23 pm
JV,
The nice thing about CONVERT vs CAST is that CONVERT supports a wide range of style codes as opposed to CAST.
See the BOL for a fuller explanation, but ultimately, it...
November 18, 2003 at 9:47 pm
To be honest, it sounds more like a business relationship problem rather than a programming problem; how good is your relationship with this vendor? All of the solutions below...
November 18, 2003 at 9:38 pm
Viewing 7 posts - 1 through 7 (of 7 total)