space1000

Just solve the thing with a cursor like declare del_dups cursor for select * from <table_name> group by column_name having count(*) > 1 (column_name where the duplicates are) open del_dups fetch next from del_dups into ...... while @@fetch_status <> 0 begin delete from table_name where current of cursor fetch next …

This will only work if it finds on result in the query "select @sale_id = sale_id from sale where date_modified < (getdate() +0.02) " It's better to do it with a cursor [code]CREATE PROCEDURE Sale_DeleteSaleTimedOut AS set nocount on DECLARE @sale_id int create del_cursor cursor for select sale_id from sale …

Probably your on a uix/linux host. Just edit the file in a ksh session with vi and use ":set list:" (look for the "^M" and "$" Probably there has been a file transfer where the make up of the file was corrupted. Just use a binairie file transfer to make …

Please suplly the original query. I find it a bit hard to imagine what the result must be. The possible sollution solution is a "select ProjectName,extra_data) with a union, where the first sql statement should be "having count(A.UniqueID = 1) and the second should have "select ProjectName ,count(*) from .... …

have a look into a function. I use this a lot for calculated work.

Hello, I have a problem with a varchar(15) field. We export this record with a bcp command and I get an new line in the export file from the specific field. When I look at this field then I just see 12 numbers in it. When I do a len …

it;s easier done in interix/wsh. Cygwin is a bit spartan.