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)

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)

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!

The table name can't be a variable in the CREATE TABLE statement, so you'll have to use dynamic sql:

DECLARE @sql varchar(max);

SET @sql = 'CREATE TABLE dbo.' + QuoteName(convert(char(10),'2010-09-02 14:56:09.840',101)) +...

Just to ensure there's no confusion, NUMERIC(19,4) and DECIMAL(19,4) are the same... or as BOL states it