Search results for query: *

I have the following, and need to be convert and insert into a new table. This could be done in a some sort of reporting tool, but for now this what I need. Server: SQL 2000 ------------------ table1 Acct Date Tran Qty 101 10/1/2008 A 500 101 10/2/2008 A 1000 101 10/3/2008 A 200 102 10/5/2008...

select * into #table1 from ( select 49 rowid, 7373194 id, 3 ProdType, 200 Amount , 180 Qty union all select 49 , 106049 , 2 , 0 , 180 union all select 1096 , 5008960 , 1 , 0 , 120 union all select 1096 , 108891 , 2 , 0 , 120 union all select 1096 , 6627903 , 1 , 0 , 250 union all select 1096 ...

I have the following: Select t0, t1,t2,t3,t4,sum(x1)as tx1,sum(x2)tx2 into tbl2 From Tbl1 Group by t0,t1,t2,t3,t4 Having (sum(x1)+sum(x2))> 10 trying to ungroup the above by flaging the tx column to 'Y': update a set a.tx='Y' from tbl1 a inner join tb2 b on a.t0=bt0 and a.t1=b.t1 and...

I'm trying to limited many network round-trips call from the ASP.NET. What is the best method to insert these into the table: Customer Order: items,qty,price,desc: 102, 1, 250, 'Sql books' 105, 2, 10, 'Book binder' 106, 1, 5, 'Special Pen' 110, 5, 2, 'Paper Box' I looking into Array and pass...

Hi all, I need the following to sort out base on the condition of the 3 & 2 col. eg: c1 c2 c3 x y 0 x c y x n c x a b x b n c1 c2 c3 x a b x b n x n c x c y x y 0 -if 0 start, get col2 value next line, the col3 must match col2 previous value and so on.