Thanks for the reply, when I try to group by multiple columns I get an error using XML path is there any way round it

SELECT id, todate

STUFF((SELECT...

Thanks for your inputs

SQL Noob (2/26/2008)

---

two different issues

SAN will let you manage your storage centrally and you can replicate the data to another SAN at the storage level without worrying about mirroring or...

Thanks Jamie I will continue to explore SSIS using specific scenarios.

Thanks again for your valuable inputs

Sorry guys my bad

here you go

D,CITI CORP,,I,NEW YORK,,

D,SCIENCE & TECH II,,I,JAMES MADISON,,

Sorry again

Commas are column delimiters and are table delimiters.

Below are 4 records

Sorry Jeff, Here you go

We receive data in txt CSV format. Once I import the file to a table I do string manipulation to load it into my schema.

I know...

Thank Jez and David for the solution both of them work

David,

What is Numbers table, how is it created??

Thanks

Jez,

Thank you for your reply, i seem to have a problem at

set @col004 = substring(@col004,charindex(dbo.gettoken(@col004,',',2), len(dbo.gettoken(@col004,',',2) + 2), len(@col004)

I think the problem is with charindex

CHARINDEX ( expression1 , expression2...

Jeff,

As I much as I would like to change the source data, since it is from vendor it has to be converted into our schema from the same format.

Any...

Jez,

I understand it can be done that way only if data if formatted consistently the same way

For example

id col004

1 D,HAINESVILLE CEMETERY,,I,SANDYSTON TOWNSHIP,,

2 ...

Thanks again I didnt know that we can run OS commands from OSQL command.

Jeff,

I want to use the same file name but one thing though, from the stored proc definition you would see that I pass cursor values into osql commmand.

If I...

Jeff,

One more quickie, is there any way to replace the output file with a new output file each time when I run the osql command.

Thanks