Viewing 15 posts - 32,191 through 32,205 (of 59,102 total)
My pleasure and thank you for the kudo.
Of more immediate concern is, have you studied the code, know how it works, or have any questions about how it works? ...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 4:35 am
SARG stands for "Search ARGument" and "SARGable" has come to mean that the search arguments in a WHERE clause, ORDER BY, and/or ON clause are capable of doing an INDEX...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 4:31 am
andre-394971 (10/23/2011)
I have tried the pivot table approach but neither column lends itself to an aggregate function and unfortunatly my skill set with SQL is limited
Heh... use MAX instead... it's...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 8:51 pm
First, thank you for providing the data in a readily consumable format. It helps a lot. 🙂
Here's your original data reformatted and put into a Temp Table just because...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 8:37 pm
John Kotuby (4/13/2011)
So much for the rant.
I'd post a rant of my own but you did a pretty good job of it. 😛
I'm trying to find it but there used...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 6:27 pm
If you truly mean to convert row to "columns" as you say...
http://www.sqlservercentral.com/articles/t-sql/63681/
If you actually meant convert the rows to a single, comma delimited column as you've shown...
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Last but not least,...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 5:32 pm
vince_sql (10/23/2011)
daveriya (10/21/2011)
hii have this code in where clause RTRIM(LTRIM(ODER_ID))= ' ',WHAT THis do
It's just removing extra blank spaces, but this is un-necessary as SQL views empty strings as empty...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 9:43 am
It's probably not just the fact that you're looking at Oracle through a Linked Server... I see lots and lots of joins there. This might be a prime candidate...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 9:30 am
The same way that you'd do it for any other well formed file except, IIRC, UNIX uses only the "NewLine" character ( \ N) instead of the "Carriage Return/Line Feed"...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 9:24 am
Cool! Two way street here, though... please tell us what you did to fix it?
Also, where did all that Regex stuff come from? It wasn't in your original...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 9:09 am
Considering that the OP is trying to find those things that only have numeric digits, it sounds a whole lot worse than that. It sounds like there may be...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2011 at 9:01 am
In the presence of the correct index, the following over comes the problem with trying to use ISNUMERIC as an IsAllDigits function (which you shouldn't do), checks for the proper...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2011 at 3:24 pm
"Extended Events"... is that like planning on Friday to actually return to work on Monday? 😛 Or is it an event that lasts more than one day like PASS...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2011 at 2:54 pm
sqlguy-736318 (10/22/2011)
AccidentalDBA:) (10/22/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2011 at 2:50 pm
isuckatsql (10/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2011 at 11:07 am
Viewing 15 posts - 32,191 through 32,205 (of 59,102 total)