select t.PolicyNum, t.RecordID from myTable t where t.PolicyNum = (select a.PolicyNum from myTable a where a.RecordID <> t.RecordID) something along those...
394
Ronda
rka@...
Oct 3, 2003 10:56 am
Not a timely response... but if you didn't figure it out you might take a look at this code: http://www.15seconds.com/issue/011009.htm HTH Ronda ... From:...
393
tmg_e
Oct 3, 2003 10:56 am
Hi all, Could anybody help to solve a query requirement. i want to select field1, field2 from a table in which where condition is field4 < date1 and in that...
392
Maha Rizq
mi_amer
Oct 3, 2003 10:56 am
hi all, I need to design database tables for a school timetaable . how shall I make the relations between classes, lectures,syllabuses and days....
391
bmlakhani
Sep 17, 2003 12:01 am
I forgot the password of user james. Can i retrive it? Only thing i remember that it was of 5 characters. Can i get old password from any table ??...
390
Jeff & Emily Burgess
jeffburgess1975@...
Sep 17, 2003 12:01 am
I don't know what dbms you're using, but if you're using SQL Server (T-SQL), you must omit the word "THEN" from your IF clause. ... From: rick...
389
Ryan McIntyre
ryanm1201
Sep 17, 2003 12:01 am
SELECT product, SUM(ISNULL([d_stock], [amount]-[amount_delivery])) as amount INTO temp_stock HTH Ryan ... From: Tim Musschoot...
388
Jeff & Emily Burgess
jeffburgess1975@...
Sep 17, 2003 12:01 am
SELECT INTO temp_stock product, amount = SUM(CASE WHEN d_stock IS NULL THEN amount - amount_delivery ELSE d_stock END) FROM <your table name here> ... From:...
387
rick
ricksql@...
Sep 17, 2003 12:00 am
(alpha,count,label) a 6 label1 6 label2 b 6 label1 6 label1 6 label2 c 4 label6 d 7 label5 7 label5 sum of count = 23 what would be query to return...
386
Ale600
Sep 17, 2003 12:00 am
Hi! I haven´t tested it, please tell me if it works: SELECT product, Sum(CASE WHEN (ISNULL([d_stock]) THEN [amount]-[amount_delivery] ELSE [d_stock]) END ) AS...
385
George Clay
georgec36@...
Sep 17, 2003 12:00 am
Select Product, Case When d_stock Is Null Then [amount] - amount_delivery Else d_stock End Into temp_stock George Clay ... __________________________________ ...
384
guitarguy2
Sep 17, 2003 12:00 am
Hi everyone. I'm trying to write a sql statement in sql 2000 that will give me all fields that are NOT DISTINCT. In this case, I am trying to get policy...
383
Michael Gerholdt
gerholdt@...
Sep 17, 2003 12:00 am
I'm creating a couple of tables which will hold a heirarchical navigational menu hoping it will be scalable for recursive use, and am curious whether the...
382
PDebski@...
pdebski
Sep 17, 2003 12:00 am
Hi Folks, I am using JDBC to connect to Oracle database. I need to lock some records for quite a long time. SELECT ... FOR UPDATE OF ... allows me to lock the...
381
sgdsp
Sep 17, 2003 12:00 am
hi, how do we define relationships using SQL statements in ACCESS. or is it possible to do it ? i tried using CONSTRAINTS clause and REFERENCES ,FOREIGN...
380
astrologer
astrologer_
Sep 9, 2003 3:01 am
SELECT TOP 1 would be absolutely meaningless without an ORDER BY clause. Depending on the database engine, you'd be returning one row almost at random. ...
379
Dudi Sukma Priyadi
dudi_s@...
Sep 9, 2003 3:00 am
using sql svr database try this one. create #temptable1 insert into #temptable1 select * from #temptable where activity not null and activity not in (select...
378
rick
ricksql@...
Sep 9, 2003 3:00 am
actual table can be smaller or larger. but, within a procedure need to turn a created #temptable similar to (examid is in asc order): (id, p/f, examid,...
377
Razvan Socol
rsocol_fx
Sep 9, 2003 3:00 am
SELECT order, name, activity, SUM(count) INTO #temptable1 FROM #temptable GROUP BY order, name, activity WHERE activity IS NOT NULL Razvan ... From: rick To:...
376
rick
ricksql@...
Sep 9, 2003 3:00 am
while @y > 3 begin update #temptable if @i = 0 then set c1=c1 + ',' + n.name else set c1=c1 + ',,' + n.name __________________________________ Do you Yahoo!? ...
375
Sowmiya Narayanan
sowmiyan
Sep 9, 2003 2:59 am
select order,activity,sum(count) as count from test2 where activity != 'null' group by order,activity order by order asc Try the above query to get the result...
374
Dudi Sukma Priyadi
dudi_s@...
Sep 9, 2003 2:59 am
using sql svr database select * into #temptable1 from #temptable where activity not null ... From: rick To: SQLQueriesNoCode@yahoogroups.com Sent: Monday,...
373
Tim Musschoot
breezerke2000
Sep 9, 2003 2:59 am
Hello, Can someone please help me translate this Jet SQL code to T-SQL SELECT product, Sum(IIF(ISNULL([d_stock]),[amount]-[amount_delivery],[d_stock])) AS...
372
rick
ricksql@...
Sep 9, 2003 2:59 am
actual table can be smaller or larger. but, within a procedure need to turn a created #temptable similar to (examind is in asc order): (id, p/f, examid,...
371
Damhuis Anton
DamhuisA@...
Sep 9, 2003 2:59 am
Because you need to go through the result set in a specified order, you will need to use a CURSOR. So yes in this example it would be best in a SP. So...
370
Jeff & Emily Burgess
jeffburgess1975@...
Sep 9, 2003 2:59 am
After declaring the second temp table, do this: INSERT INTO #temptable1 (order, name, activity, sumcount) SELECT order, name, activity, SUM(count) AS sumcount ...
369
rick
ricksql@...
Sep 4, 2003 3:28 am
#temptable (order, name, activity and count): 1 mark1 null 0 1 mark1 movie 5 1 mark1 game 4 1 mark1 game 3 2 mark2 null 0 2 mark2...
368
richard.bamford@...
Sep 4, 2003 3:27 am
In MS T-SQL it's SELECT TOP 1 ... ... From: astrologer [mailto:astrologer_@...] Sent: 26 August 2003 04:27 To: SQLQueriesNoCode@yahoogroups.com Subject:...
367
Andy.T
yk_andy
Sep 4, 2003 3:24 am
Thanks for everybody's help. The problem was solved with a "TOP 1". BTW, I
was using an Access database. Andy ... From: SQLQueriesNoCode@yahoogroups.com Date:...
366
pnagrecha
Sep 4, 2003 3:23 am
Hi, Lets take an exmple of table emp I want to select changed columns of the records of the table and order it by ascending order of empno and compare deptno...
