It will be easy if we have all the fileds of staging table as VARCHAR or CHAR fields. We will get the values exactly as in the text or csv...

If it is allowed to use stored procedure remove Insert, Update and delete rights for application user on the tables. Do everything by stored procedures. Give rights to Exec rights...

Within the same server we can do everything with a query analyzer as well as DTS Package(transfer data between databases, append, truncate, delete check previous rows). Also original poster says...

Cool. Updated query looks good. Thanks. I will try with my table. For now I have to make it for 4 since 4th source they say will be using this...

Data Table or Data View can be sorted just by mentioning sort contion.

DV.Sort = "ColumnName ASC"; will work fine.

We don't have such thing in SQL. So sort it based...

text area is web/html control. It is a big text box like the one we use to type body of EMail message or messages for Forums. There are chances that users can...

Okay I updated my post

I agree. But in this case any criteria will not give more than few rows. I checked the entire table and maximum rows now is 3. It is like each...

Remi we can remove the else NULL part. It works in the same way.

I agree with paul. This error will come when we try delete duplicate rows with enterprise manager. Entire row is a duplicate. Since there is no key specified for this table...

You cannot use it directly as an array or table.

Workaround is cocatinate the values with usually '|' and split it in the stored procedure to avail it as...

Or use xp_cmdshell if have to use it in a stored procedure or query analyzer. Call dts in a loop for each country.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=190039#bm190692

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=190039

It is not could Phil you should or must use ISNUMERIC

SET NOCOUNT ON

DECLARE @myTable TABLE

(

myNumChar VARCHAR(10)

)

INSERT @myTable VALUES('111111')

INSERT @myTable VALUES('1AAA1')

INSERT @myTable VALUES('AA11AA')

INSERT @myTable VALUES('111A11')

INSERT @myTable VALUES('2AAAAA')

INSERT @myTable VALUES('AAAAA2')

INSERT @myTable VALUES('222222')

SELECT...

You cannot use it directly as an array or table.

Workaround is cocatinate the values with usually '|' and split it in the stored procedure to avail it as a...

Thanks vasc. Sure it is liitle more better.

But in case if I am asked to add another column to check(There is another field in the table) the case statement will...