bumping up!

Yeah sql datetime is in the format u said.. if ur application cannot be changed then I guess create a varchar field and convert the date into format that is...

OPC thanks for a nice write-up.. this write-up inspires me to learn more about handling XML which I will do. I think I need to flatten the xml file first...

Thanks a lot OPC. So is there a way I can query the data and create the destination table for it? And then use your 2nd approach? Data is around...

I do not have XSD or table created.. this is an ad-hoc file and we do not have schema for it... what should be the fastest way to load it...

This is an ad-hoc data analysis so I was not bothered with that.. but please suggest what I can do to optimize it... if it doesn't take a lot of...

I think this should do it:

--Using Test table

Create Table TEST

(Symbol char(3),Total bigint,FreqCnt int, recordnum int identity (1, 1) )

Insert into TEST(Symbol, Total, FreqCnt)

SELECT 'NOK','6000000','3' UNION ALL

SELECT 'NOK','1000000','2'...

Sorry that was not for your response... I am reading the link u sent me.. that is good. Thanks!

hehehe Lowell this is not that I am asking... recharge ur brain :). Sorry for the poorly formated sample data...

Thanks GSquared ... I had used http://www.sqlservercentral.com/scripts/Miscellaneous/31775/ but yours is even better as it takes care of median for even sets correctly. Thanks!

they want mode as well as...

Thanks Johnny that is what I am working on, but got another way to do it in SSIS as I was using SSIS for steps before this.... create a column...

Just to read that SELECT I guess instead of putting in one row insert each line into different row and then you can read it... or try not sure though...

Thanks guys for the response... I was able to do this using Conditional Split Transformation and Derived Column in SSIS... basically all that tedious substring, I had to write in...

Jeff Moden (1/8/2011)

---

Ghanta (1/7/2011)

---

Hi Guys,

I am sure some of you might have dealt with the situation that I am in... wanted to check the efficient way to do this.... I...

Thanks Elliott and Craig for the response. Craig it is positional association only... each line will have different schema based on three characters at position 9, 10, 11 and I...