Jeremy,

Do you have an example of how you'd solve the above using the Pivot operator?

You bet, Cali... thanks for the feedback.

I wish I could take the credit for the following bit of SQL prestidigitation, but I can't... thank "Sergiy" 😉

CREATE FUNCTION dbo.fnAddWeekdays (@Start DATETIME, @Days INT)

RETURNS DATETIME

...

Ah, crud... I just noticed that this is a 2k5 forum... the code I posted is most definitely for 2k...

You'll need to do some mods to the code but I...

I guess the best way to help you get this sorted out, is to give you a chunk of "tool" code I made a while back... could easily be turned...

In your code, you never say...

DELCLARE @db_Name SYSNAME

That means you have an undefined variable and it's gonna give you an error. Here's the beginning of your code... and there's...

fosco (12/8/2007)

---

Thanks for the replies, we have an application that actually creates the reports in pdf format, but the data is on sql server 2000 standard backend, when the application...

This takes care of the single letter and blank situations...

--===== This is the solution for the known constraints on the data as posted

DECLARE @MaxWidth TINYINT

SET @MaxWidth...

Drat... both of ours come up with a little problem when we have data like this...

--===== This just creates demonstrable test data and is NOT part of the solution

SET NOCOUNT...

The following is your guide... the rest is dependent on your "Yukon DBA" knowledge of T-SQL 😉

http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx

...or, perhaps, something a bit more "auto-magic"... 😀

--===== This just creates demonstrable test data and is NOT part of the solution

SET NOCOUNT ON

DECLARE @TestData TABLE(String VARCHAR(10))

...

Or... we can cheat like hell 😛

--===== This just creates demonstrable test data and is NOT part of the solution

...

I've seen "Runnable" in 2k, but never "Running" and, as you probably found out, BOL 2k doesn't have much info on the sysProcesses table... but the following URL (from BOK...

sp_MakeWebTask is one way...

Hundreds of other ways using OSQL, OpenRowset, etc to fill spreadsheet templates, make simple text files, etc, etc.

Double posting is so rude... waste time answering one only to find answer on the other.

http://www.sqlservercentral.com/Forums/Topic430841-5-1.aspx

http://www.sqlservercentral.com/Forums/Topic430840-146-1.aspx