Hoping that this is what you are looking for. Create a parameterized stored procedure and then call that procedure passing your input values. Note in the sample I...

Let me ask the obvious question:

What do you want to do if P1 = P2 ?

You may want to look at the CASE Function in BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/658039ec-8dc2-4251-bc82-30ea23708cee.htm

In the lower portion of the page it shows how to use the CASE function to replace the IIF function...

Changing to text output willl not suppres the display of result sets.

You can direct...

Read Books On Line:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a87d0850-c670-4720-9ad5-6f5a22343ea8.htm where you will find the CONVERT function:

The following table shows the values for style that can be used for converting money or smallmoney to...

Sergiy when I run your T-SQL

declare @cn as varchar(2000)

select @cn = notes + char(13) + char(10) + resolution as Combined_Notes

...

Best I could come up with does output the lines at the Top of the report but does NOT print lines between the report header and sub header:

set @output =...

When suggesting backups, backups based on the amount of data added, updated or deleted I should have said, if you...

In addition to other replies you will recieve let me say backups, backups, and more backups both the database and log files. Depending upon your amount of data change...

Presuming that you are going to run the T-SQL statement in SSMS and direct the results to a file. Try this for a fixed row length:

SELECT LEFT(LEFT(SUBSTRING(Entry,1,24) + SPACE(30),30)+...

Applying the Rownumber process to your data for example:

;with numbered as(SELECT rowno=row_number()

over (partition by Invoice, Item, Type order by Invoice),

Invoice,Item, Charge, type from Sales)

select *...

You asked for any ideas? Hopefully this might start your tbinking along a different track to a solution.

If this is new work, that is the column definition in your...

Watch the spelling in the exec line it is misspelled. It does exist in my SQL 2005.

Just hit Amazon and there are SQL 2005 Bible and SQL 2008 Bible (Pre-order due on Jun 22, 2009) by Paul Nielsen each priced at $31.49...

For a full understanding of the DBCC CHECKIDENT command read Books On Line (BOL) at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/2c00ee51-2062-4e47-8b19-d90f524c6427.htm

paying particular attention to what might happed if you use the command improperly ...

If...