Try to see if there is any formatting on this column (in excel spreadsheet) ... if there is any that will not be carried. Only actual data with its datatype...

Thanks guys ... i think i got it this way

DECLARE @val varchar(1000), @delimiter char(1)

SET @delimiter = ','

SELECT @val = COALESCE(@val + @delimiter, '') + ColumnA

FROM TableA

print...

If we use a inner join

we get something like this

ColumnX

--------

1,1

2,2

3,3

4,4

5,5

And i need something like

ColumnX

--------

1,2,3,4,5

Is there any way we could use "for xml" to get the above output. I...

I execute the below statement in management Studio:

EXEC [master].[dbo].[xp_ss_list] @filename = @ArchivePathAndFilename,@debug = 0

and here is the message in prints:

xp_ss_list completed successfully.

dummyFullPRIMARYdummyC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dummy.mdf

dummyFullPRIMARYdummy1C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dummy1.ndf

dummyFullNULLdummy_logC:\Program Files\Microsoft...

Crispin,

The problem is i am not sure what would be the set key and pivot key .... can u please explain little bit more on pivot and unpivot

The above thread defines a different senario .... if i am not wrong!!

The work book gets refreshed every night. The number of sheets in the workbook are fixed.

I use expressions & variables to map to the sheet name (which is the table...

The exact problem is:

I have a excel workbook with each sheet having a table, the number of columns in the table vary. I some how managed to remove the first...

Sergiy, that was a good catch but there are very few instances where we get that kind of a sequence where d --> decimal should be considered as a string....

This could be another way, dont know how much performance you gonna get out of it.

Here's the data in table1

data

1dd

1

1x4

1cc2

1110-345-720a3

11

380-41-3a

10

12983

21

19

--------------------------------

SELECT data,isnumeric(data)

FROM dbo.table1

ORDER BY CASE WHEN ISNUMERIC(data) = 1 THEN...