I wish you the best of luck. I did what everyone comment in here, and I'm happily working as a dba full time for 7 months already. I was working...

one of my Colleagues find a faster way. He compared the total of set and then try to match the values with TableB

Hope can help to someone...

declare @UniqueSegmentationIDs int

declare @UnmatchSegmentationIDs...

did you try it with the 2 select (TableA and TableB) that I post?

Because It didnt work for me when I tried your advice

Thank you

Thank you Ryan for your advices.

Lu, I agree about the var tables. We starting to create a process and see what is the best performance way.

thanks again

it works perfectly, I need to insert the data into a var. Becasue im creating a function

Thank you for all your advices 😀

attached.

Thank you

no because its only one record. I dont understand why it takes long to insert it because when I do only the select, it shows the 400 records in less...

this is the xml ( I just sending you part of that because its huge)

<xml> <version alias="m4l_HSI_006$1" versionidentity="" packid="" versionid="" rowid="1"> <attribute key="t_weight" keyDesc="Weight" value="0" valDesc="" /><attribute key="t_rid" keyDesc="" value="907"...

I dont need the password encryption. I need the hash value of the insert record.

this is a record that already exist in my table. I need to know how to...

no one ??

Ok people.. this is a great link

http://msdn.microsoft.com/en-us/library/bb330962(SQL.90).aspx#intlftrql2005_topic2

more info:

http://www.codeproject.com/KB/aspnet/Encoding_in_ASPNET.aspx

http://msdn.microsoft.com/en-us/library/ms187508(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/bb330962(SQL.90).aspx#intlftrql2005_topic14

http://msdn.microsoft.com/en-us/library/ms143508.aspx

hope it helps you as well

Im actually in this situation right now. My boss want me to be sure if our DB can support unicode.

Anyone knows any link or tell your experience about this...

I dont have another machine to set up my cluster. I will need to do it in the same server. About the max downtime. It has to be in a...

In my case I always use Var tables for small amout of data..

Thank you for the note

Hey,

Thank for the note. Actually I work the same way. I use temp tables for very large data sets. My procedure creates many temp tables to have Report. I...