Any feeback on this anybody?

Thanks

Hi Jacob,

Thanks a lot for your prompt response. The only problem is I am not a .Net developer and only do database development and administration. One thing that I do...

Hi Jacob,

I read all your workshops on XML and have found it very useful. You have presented it very well with simple to advanced examples. Thank you for your efforts...

Following I am including my sample XML files that I am trying to do variable replacement on.I am attaching them as this does not allow me to paste the xml...

Any idea where can I find complete information or whitepaper on this.

I need to instruct my users here as not everybody has SQL 2k8 yet.

thanks

Sorry Michael,I tried to delete this last night itself,but its not removing it.

I tried again and its still not removing it.

thanks

Hmm...i did the update without the looping through but still same values assigned to all Ids in ##T1.

I just tried yr method and it worked. I am trying to see...

Hi Chris

Thanks for you thoughts. However, without having to introduce a new function to do this,I have the following update script to do this. I am updating the ##T1...

If you are on SQL2005, then you can also use SSIS, which will make this task much easier and gain some performance too since it all happens in memory. You...

Thanks all for useful inputs. I am trying them and will let you know if i have any issues again.

Cheers.

The code is posted just for an example to show how I am trying to capture the @@rowcount to print message whenever 1000 rows updated. There is a lot more...

Hi guys,

Thanks yr prompt feedback and solution. All the solutions seems pretty feasible. The left outer join i guess might just work fine. I was reading about the data partitioning...

Thanks for the response. I just need to get the values (rows) from table1 that does not exist in table2. The values in table1 will be unique, however in table2...

Thanks a bunch Jason for providing the solution to handle the varchar datatype.  I really appreciate your assistance on this.

cheers,

Thanks a lot Jason. This works. I cant thank you enough for this.

I was trying this to see if it will work if my second column in the input table...