So, are the only valid characters to be the characters on the keyboard? These will have an ASCII code between 32 and 126. So:

declare @test-2 table (Col1 nvarchar(500));

declare @testdata nvarchar(500);

set...

The...

You might want to check out the common date/time routines link in my signature.

This should get you started.

Things still left to to:

1. convert to %, and summarize.

2. probably want this to be dynamic.

Please read the Cross-Tabs and Pivot Tables, Part 1 and Part...

Just call the DelimitedSplit8K function for each one.

However, I sense that there is something else going on. Do you need to...

Thanks. I've been using it so much lately, that I've made it...

anand_vanam (9/2/2010)

---

DECLARE @FileName VARCHAR(8000)

SET @FileName='SSC1, SSC2, SSC3'

CREATE TABLE #FileNames

(FileID INT IDENTITY(1,1),

FileNameList VARCHAR(30)

)

SET @FileName=LTRIM(RTRIM(@FileName))

--SELECT @FileName

BEGIN

...

declare @test-2 TABLE (customerID char(2), Cat varchar(5), Cnt int);

-- See how you start off by actually creating a table and then

-- inserting the data into it? Your doing this...

bpowers (9/2/2010)

---

I am trying to link two tables based on the Work Order ID in a report. However, one of the table stores the Work Order type, ID, Sub ID,...

Glad you got it working... and I'm sorry that I had to disappear (time to drive home to avoid the hurricane).

LutzM (9/2/2010)

---

WayneS (9/2/2010)

---

Probably has something...

And for what is perhaps the best explanation of the issues this causes, see Gail Shaw's blog[/url]

Alvin Ramard (9/2/2010)

---

I wouldn't call it an...

Probably has something to do...

Looks like you just have to verify everything is fine, then you're ready to go!