Table data in tabular form

Question

Post reply

Table data in tabular form

Viewing 9 posts - 16 through 23 (of 23 total)

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

freecoder SSC Eights! Points: 951 More actions · Answer 1

It does work!

I am just trying to get my head around it now 😛

never used cross apply before.

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

freecoder (8/7/2013)
It does work!
I am just trying to get my head around it now 😛
never used cross apply before.

Check out the links in Chris's signature about Apply. Those 2 articles explains APPLY in an easy to understand format.

_______________________________________________________________

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/

freecoder SSC Eights! Points: 951 More actions · Answer 3

freecoder

SSC Eights!

Points: 951

August 7, 2013 at 7:41 am

#1639382

Yeah that is what I am reading now 🙂

freecoder SSC Eights! Points: 951 More actions · Answer 4

is there a way that I can get the result in a table format like its displayed. I have to send the table in the email.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

Yep[/url].

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

freecoder SSC Eights! Points: 951 More actions · Answer 6

freecoder

SSC Eights!

Points: 951

August 20, 2013 at 6:02 am

#1643030

how :)??

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 7

The word Yep is a link 😉

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

freecoder SSC Eights! Points: 951 More actions · Answer 8

freecoder

SSC Eights!

Points: 951

August 20, 2013 at 6:05 am

#1643032

oops! lol

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 9

freecoder (8/20/2013)
oops! lol

Heh no worries 😀

Post back if you get stuck.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden