You can use OPENXML but why? Usually for small data sets or ad-hock tasks is SSIS good enough and it is faster do design than pure T-SQL. Then you go to large data sets and you need extraction, transfer and load optimization. For this task it is T-SQL ...

You can use OPENXML but why? Usually for small data sets or ad-hock tasks is SSIS good enough and it is faster do design than pure T-SQL. Then you go to large data sets and you need extraction, transfer and load optimization. For this task it is T-SQL ...

Solution to TSQL Beginners Challenge 21...

This challenge deals with String aggregation. On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. ...

The reasons are very good, but I cannot agree with Cons: *4. There will be problem if No.of records cross the Max.Value of Bigint(But its rare).* Bigint is 2^64, which is around 10^19 rows. If you just store 1byte per row you will have to store more...