Hi

Is this a good way of having all the possible values

FOR periodheader IN( [JAN A HEADER], [FEB A HEADER], [MAR A HEADER],

...

Hey Jeff,

That is Sixth-Sense...;-)The way i see is by looking at the requirement this is a report. Either this report is comming from SSRS or any front-end application.:hehe:

In one of...

But if we go with thumb rule.."-s" is option to run it in silent mode. Not sure is this applicable at the SP level...

Looks like there is no way to do it...

Hi

Check out the below link

http://support.microsoft.com/default.aspx/kb/913089

Hi

Before start doing this, first you need to find out what kind of errors you are expecting!!! then code it accordngly.

Check out the below link

http://www.sql-server-performance.com/articles/dev/exception_handling_p1.aspx

Hi,

No Idea why do you want to do that way. Going forward you will have face issues. Lets haev the Numbers to the rows in the query and control how...

Hi

It would be nice if you tell us final solution/implementation.

Let us know if you have any questions.

So for time being you can live..but you need to keep this in mind.

On the other note are you thinking about partitoins. You can easily modify the query but it...

Group by doesn't take Column Numbers. You need to specify the columns which are doens't have any Group functions.

Hi

Check out the below link this will solve your problem.

http://databases.aspfaq.com/general/how-do-i-concatenate-strings-from-a-column-into-a-single-row.html

Maximum length of paramter is 128.

it looks like you are passing dynamic WHERE condition and you are going to HIT boundary on the length. So why dont you break you...

it looks like you are passing dynamic WHERE condition and hitting the boundary on the length. So why dont you break you conditions and pass it smalll chunks like first...

Why dont you construct the WHERE condition and pass this as a string to the stored procedure.

do you have any front-end application for this??