How to select from 5 lines but only display 3

Question

How to select from 5 lines but only display 3

Viewing 4 posts - 1 through 5 (of 5 total)

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

whenriksen SSCarpal Tunnel Points: 4752 More actions · Answer 1

Post some DDL and sample data. Your question looks fairly involved and I don't want to waste my time writing a query against data that doesn't accurately represent your problem.

Wes
(A solid design is always preferable to a creative workaround)

jonathanm 4432 SSChasing Mays Points: 619 More actions · Answer 2

whenriksen - Thursday, January 12, 2017 12:12 PM
Post some DDL and sample data. Your question looks fairly involved and I don't want to waste my time writing a query against data that doesn't accurately represent your problem.

The attachment in my original post is sample data. I am trying to right code however not having much success so far. Reason why I reached out.

whenriksen SSCarpal Tunnel Points: 4752 More actions · Answer 3

jonathanm 4432 - Thursday, January 12, 2017 12:15 PM
whenriksen - Thursday, January 12, 2017 12:12 PM
Post some DDL and sample data. Your question looks fairly involved and I don't want to waste my time writing a query against data that doesn't accurately represent your problem.
The attachment in my original post is sample data. I am trying to right code however not having much success so far. Reason why I reached out.

You also need to include your table definition and what you want the results to look like. You will get more help if you put your data into a script rather than an excel file.

Wes
(A solid design is always preferable to a creative workaround)

drew.allen SSC Guru Points: 77014 More actions · Answer 4

jonathanm 4432 - Thursday, January 12, 2017 12:15 PM
whenriksen - Thursday, January 12, 2017 12:12 PM
Post some DDL and sample data. Your question looks fairly involved and I don't want to waste my time writing a query against data that doesn't accurately represent your problem.
The attachment in my original post is sample data. I am trying to right code however not having much success so far. Reason why I reached out.

Attachments can contain malware, so people are hesitant to open them. Attachments are also not readily consumable, which makes it less likely that people will answer your question. Check the first link in my signature for the preferred way to post sample data.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA