Viewing 15 posts - 46,696 through 46,710 (of 59,062 total)
Oblio Leitch (12/8/2008)
That looks pretty good, but I was just working with a reduced dataset as an example. I need to expand it to use groups of IDs. ...
December 8, 2008 at 7:10 pm
rbarryyoung (12/8/2008)
Anyway, this corrected version gives...
December 8, 2008 at 7:08 pm
rbarryyoung (12/8/2008)
Kris (12/8/2008)
December 8, 2008 at 7:01 pm
Alan Naylor (12/8/2008)
Ths is the correct solution.
No... it's not... not if it has a cursor in it. 😉 But, if you would rather do that than posting the...
December 8, 2008 at 12:36 pm
Kris (12/8/2008)
Do you have any advice on increasing the performance of this query?
Heh... yeah... use the CrossTab code instead. 😉
The reason it must dragged into a spread sheet is because...
December 8, 2008 at 12:28 pm
rbarryyoung (12/7/2008)
Actually, a couple of tweaks to noel's version will make it much better:
You need to check the output on that... 😉
December 8, 2008 at 5:44 am
Kris (12/5/2008)
Is it save to assume that both Pivot and Cross Tabs preform better than tabulating the data from a view that inner joins the table on itself for...
December 8, 2008 at 5:07 am
Suraj (12/7/2008)
Thank you Jeff.
You bet... thanks for the feedback.
December 8, 2008 at 4:54 am
Bob Hovious (12/7/2008)
December 8, 2008 at 4:54 am
leonp (12/7/2008)
To Jeff's question -
Tr data is never truncated - it has a few DMLs issued very infrequently
To Gail/Krishna's question -
As I understand, since...
December 7, 2008 at 10:15 am
Patricia Monreal (12/7/2008)
December 7, 2008 at 10:09 am
Yihong (12/7/2008)
Thank you guys, it worked beautifully in my code.
You bet... thanks for the feedback.
December 7, 2008 at 9:50 am
Ken Simmons (12/7/2008)
Thanks Jeff.I knew there was a way to do it without the math, I just cound't think of it last night.
S'ok... Heh... not much coffee at night. 😛
December 7, 2008 at 9:49 am
Replace the derived table in the from clause with your real table...
SELECT PARSENAME(d.IpAddr,4) As ColA,
PARSENAME(d.IpAddr,3) As ColB,
...
December 6, 2008 at 11:44 pm
Viewing 15 posts - 46,696 through 46,710 (of 59,062 total)