SQL Bits X...

Question

SQL Bits X...

Viewing 10 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Sean Lange (3/30/2012)
I made him read this whole thread. http://www.sqlservercentral.com/Forums/Topic1268991-391-1.aspx :w00t:

Hi-la-rious!

I do admire your patience.

I would probably already stopped looking at that thread after 3 or 4 posts.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

Koen Verbeeck (4/2/2012)
Sean Lange (3/30/2012)
I made him read this whole thread. http://www.sqlservercentral.com/Forums/Topic1268991-391-1.aspx :w00t:
Hi-la-rious!
I do admire your patience.
I would probably already stopped looking at that thread after 3 or 4 posts.

By this point it is actually funny. Sadly by 100 posts the only thing the OP "had so far" was code that was written them.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

CapnHector SSCoach Points: 16143 More actions · Answer 3

Sean Lange (4/2/2012)
Koen Verbeeck (4/2/2012)
Sean Lange (3/30/2012)
I made him read this whole thread. http://www.sqlservercentral.com/Forums/Topic1268991-391-1.aspx :w00t:
Hi-la-rious!
I do admire your patience.
I would probably already stopped looking at that thread after 3 or 4 posts.
By this point it is actually funny. Sadly by 100 posts the only thing the OP "had so far" was code that was written them.

guess you should send him your business card so you can go in there and fix it right.

all volunteer of course.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

capn.hector (4/2/2012)
Sean Lange (4/2/2012)
Koen Verbeeck (4/2/2012)
Sean Lange (3/30/2012)
I made him read this whole thread. http://www.sqlservercentral.com/Forums/Topic1268991-391-1.aspx :w00t:
Hi-la-rious!
I do admire your patience.
I would probably already stopped looking at that thread after 3 or 4 posts.
By this point it is actually funny. Sadly by 100 posts the only thing the OP "had so far" was code that was written them.
guess you should send him your business card so you can go in there and fix it right.
all volunteer of course.

I should probably go ahead and purchase my own plane tickets too. I mean I am sure I owe him that much by now. 😛

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

EL Jerry SSCertifiable Points: 7063 More actions · Answer 5

Sean,

I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

EL Jerry (4/2/2012)
Sean,
I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂
"El" Jerry.

We're building the statue as we speak 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

CapnHector SSCoach Points: 16143 More actions · Answer 7

Koen Verbeeck (4/2/2012)
EL Jerry (4/2/2012)
Sean,
I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂
"El" Jerry.
We're building the statue as we speak 😀

i hear its suposed to be marble and every thing.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

capn.hector (4/2/2012)
Koen Verbeeck (4/2/2012)
EL Jerry (4/2/2012)
Sean,
I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂
"El" Jerry.
We're building the statue as we speak 😀
i hear its suposed to be marble and every thing.

ROFL. You guys are too funny!!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

CapnHector SSCoach Points: 16143 More actions · Answer 9

Sean Lange (4/3/2012)
capn.hector (4/2/2012)
Koen Verbeeck (4/2/2012)
EL Jerry (4/2/2012)
Sean,
I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂
"El" Jerry.
We're building the statue as we speak 😀
i hear its suposed to be marble and every thing.
ROFL. You guys are too funny!!!

well better to be funny then rip our hair out while trying to get DDL and sample data.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

SQLBill SSC Guru Points: 51440 More actions · Answer 10

Talk about perseverance!!! A tip of the hat to you Sean - are you perhaps a dentist? As they say...that was so painful it was like pulling teeth.

-SQLBill