Can you provide the XML ?

WITH XMLNAMESPACES('EmployeeXSD' AS E)

SELECT

nref.value ('@DepartmentID', 'int'),

nref2.value('@EmployeeID', 'int'),

nref2.value('@Salary', 'money')

FROM@xml.nodes('/E:Department') AS R(nref)

CROSS APPLY R.nref.nodes('./E:Employee') AS R2(nref2)

this is the sample query u could tryout from this query.

its all depend on your business logic. If you are managing the transaction in SP then should check it will not create any lock / deadlock for any application same...

dats really amazing that nobody replied for this question. its okay i got the answer

you just have to write a simple sql statements for getting the data from source table and inserting it into destination.:cool: if you want to put a check that if...

You should go for SSIS or you can also create the job which can execute the batch script to migrate the data.

you can try for ApexSQL Diff. this is the 3rd party utility. You can compare as well as synchronize the databases

Scripting is the best way to keep the updates perfect. while deploying updates on production database this helps to to deploy the exact changes. what we prefer is alway deploy...

Hi Khalidhussain,

Instead of wasting your time in writing a script for comparing database objects, I'll suggest to to better go for third party tool available.

global_temp tables logic is specially created for wide use/purpose, Microsoft has not any permission for these tables. the reason behind it its scope.

this could be better implemented as mention below...

IF OBJECT_ID('tempdb..#tbl') IS NOT NULL

DROP TABLE #tbl

CREATE TABLE #tbl(

lngTransactionCnt intPRIMARY KEY CLUSTERED,

strStatus varchar(2),

strStatusDate varchar(8),

strStatusTime varchar(4)

)

INSERT#tbl

SELECTlngTransactionCnt, strStatus, strStatusDate, strStatusTime

FROMtblTransactionHistoryCtmpA

with (nolock)

WHEREstrStatus in ('BP', 'BN',...

one more query..

select object_name(object_id), * from sys.objects where object_name(object_id) like 'sys%' and type = 'U'

Okay, the scenario is i have custom filter, which stores the SearchTable, SearchColumnName & SearchParameterValue in table in different columns like Product in 1 column | ProductName in 2 column...

Can post your question with more clarification.. we didn't get you what exactly you want to do.

As per my understanding the below script will give you the desired result set.

DECLARE @SQLColumns VARCHAR(4000), @sql VARCHAR(8000)

SET @SQLColumns = 'AddressID, AddressLine1, AddressLine2, City'

SET @sql = 'SELECT '+ @SQLColumns +'...