I have a requirement to duplicate the database on the WAN?

What is the way to go about it. Our main concern is data integrity should not be lost?

Ok, I manage to work out most of the things with the dynamic sql way. but there is another problem.

The stored procedure is defined as

CREATE PROCEDURE sp_abc(@vSdate datetime,@itemids as...

thanks it works,

but now i have another question

What if i would like to declare a cursor in stored procedure with a query which is stored in the variable

What is the...

Thanks for your reply,

But, if i run the query in query analyzer it works

select * from test1 where itemid in ('I000010','I000020') it works, however when the same statment is executed...

Thanks for your reply, What i did was took the query into a variable and printed that query using Print Command.

When i tried to run the query individually it...

I have deduce the problem. The mistake i was doing is using the statement as

Select ItemId, AddSub,Qty, Cast(Qty as numeric(8,4))

From InventoryAdjustmentDetail

instead of

Select ItemId, AddSub,Qty, Cast(Qty as numeric(18,4))

From InventoryAdjustmentDetail

Thanks Frank for...

I need a scale of 5 decimals. Following is the Create Table Statement for your reference

CREATE TABLE [dbo].[ItemQty] (

[ItemId] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[AddSub] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

The data is only a subset of the complete data i have. I have around 2800 rows of data. Should I send it and if yes, in what format? Also...

Please find the sample data

I000000068-86814.0

I000000068-450000.0

I000000068-600000.0

I000000068-1050000.0

I000000068-200.0

I000000069-100000.0

I000000069-67066.0

I000000069+450000.0

I000000069+4028.0

I000000069-2100000.0

I000000069-2100000.0

I000000069-2100000.0

I000000070-1.3

I000000070-221.56999999999999

I000000070-2.5499999999999998

I000000074-0.23000000000000001

I000000076-0.40999999999999998

I000000078-0.23000000000000001

I000000078-0.65000000000000002

I000000078+5.0000000000000003E-2

I000000078+0.65000000000000002

I000000082-2.9999999999999999E-2

I000000082-4.0000000000000001E-2

I000000086-0.01

I000000086-5.0000000000000003E-2

I000000090+0.0

I000000163+0.5

I000000571-0.80000000000000004

I000000581-0.11

I000000583-0.67000000000000004

I000001165-0.35999999999999999

I000001364+0.0

I000001544+0.90000000000000002

I000001589+0.90000000000000002

I000001611-0.0

I000001691-0.28999999999999998

I000001737-0.82999999999999996

I000001745-0.53000000000000003

I000001768-0.33000000000000002

I000001769-0.66000000000000003

I000001807+0.0

I000001970+0.0

I000001990-0.5

I000002666+0.01

I000002737+0.67000000000000004

I000002739-0.5

I000002775-0.12

I000003284+0.01

I000003284+0.01

I000003284+0.01

I000003284+0.63

I000003333-0.98999999999999999

I000003333+0.02

I000003333-0.01

I000000069-2100000.0

I000000069-2100000.0

I000000069-2100000.0

Thanks for the reply, i tried

Select ItemId, AddSub,Qty, Cast(Qty as numeric(8,4))

From InventoryAdjustmentDetail

It gave me this error

Arithmetic overflow error converting float to data type numeric.

I dont understand why?

There was a list of articles i found on the link you provided but none spoke of locking. Can you please tell which of those articles dealt with Database Locking

How to lock a table in SQL Server 2000? I mean i would like to run a stored procedure and want that during the time the stored procedure no change...