how to give next line to stored procedure

Question

1.00/5 (1 vote)

See more:

Store procedure output as follows

SNO Course Startdate Enddate Description

1 ERS 27 may 2015 30 may 2015 seats 20
1 MFA 2 june 2015 5 june 2015 seats 30
1 PSC 4 June 2015 6 June 2015 seats 40
2 ERS 29 may 2015 30 may 2015 seats 20
2 MFA 4 june 2015 8 june 2015 seats 30
2 PSC 6 June 2015 9 June 2015 seats 40

I want output as follows to give next line as follows

1 ERS 27 may 2015 30 may 2015 seats 20
1 MFA 2 june 2015 5 june 2015 seats 30
1 PSC 4 June 2015 6 June 2015 seats 40

2 ERS 29 may 2015 30 may 2015 seats 20
2 MFA 4 june 2015 8 june 2015 seats 30
2 PSC 6 June 2015 9 June 2015 seats 40

for that how can i do in sql server in stored procedure

Posted 17-Jul-15 0:37am

narasiman1

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-17T00:59:00

If I understood the question correctly you'd like a blank line between each group of SNO's

If that is the case, SQL is not designed for formatting the output. Formatting should always be done using tools designed for that. SQL is designed for fetching and manipulating data.

Basically you could do this using UNIONs or fetching the data using a cursor and then adding the results into a temporary table and selecting from that or something similar, but I wouldn't suggest doing that.

Have a look at the tools that are available for you on the calling side. If you fetch the data into a gridview perhaps you can use grouping or if you need reporting perhaps Sql Server Reporting Tools would be the solution and so on...

OriginalGriff · Answer 2 · 2015-07-17T01:00:00

Solution 2

You don't: separating data with blank lines is a presentation feature, not a data access feature. You do this in your presentation software, not in SQL.

Posted 17-Jul-15 1:00am

OriginalGriff

Ganesan Senthilvel · Answer 3 · 2015-07-17T01:06:00

Solution 3

You can add new line variable as below. It is used to insert next line for the stored procedure output, as needed.

SQL

DECLARE @LINEBREAK AS varchar(2)
SET @LINEBREAK = CHAR(13) + CHAR(10)

Posted 17-Jul-15 1:06am

Ganesan Senthilvel