I have experience with T-SQL..and any idea when the exams will be out for R2?

Thank you for the reply guys..I really appreciate that..I have got the result using following query:

SELECT 0,

lev01.CHILD_ID id_01,

lev02.CHILD_ID id_02,

lev03.CHILD_ID id_03,

lev04.CHILD_ID id_04,

lev05.CHILD_ID id_05

FROM PEGGING lev01

LEFT OUTER JOIN PEGGING lev02 ON lev01.CHILD_ID...

its the AdventureWorksDW..FactInternetSales table with 60000 records..

I just learned from someone that BULK insert cannot be used to dump data from Raw file to SQL tables..is it really like that?...

Following expression worked at last..

(DT_I4) SUBSTRING( WEEK,5,2) >=1 && (DT_I4) SUBSTRING( WEEK,5,2) <= 17 ? (DT_I4) (SUBSTRING( WEEK,5,2))+ 35 : (DT_I4) (SUBSTRING( WEEK,5,2))-17

Thanks Deepak

Thank you guys for your help and Jeff Moden for ultra-extraordinary explanation of the basics of asking questions in forums..I was completely unaware of that..That was really helpful..I appreciate that..was...

Thanks a lot mate....that was the perfect solution I was looking for..Thanks a lot mate..You are the savior 😀

Guys..after lots of hrs of convincing mgt..I got the permission to exec stored procedures..so using Dynamic SQL now 🙂

Thanks a lot to everyone for their help..I appreciate that 🙂

I am currently workin as a TEMP in my company..and only permanent guys can execute a proc 🙁

Thank you so much guys.

Unfortunately, I am not allowed to use EXECUTE or SP_EXECUTESQL statements on the db. So, is there any other way?

Guys..what is your opinion about indexes..as per my knowledge indexes are heavily used in OLAP..but I generally disable the indexes before loading new data and again enable them back after...

Thanks mate..thats an excellent solution using pure SQL..thanks again 🙂