Please help me in vb6.0 and sql 2000

[Dev1511 via VBMonster.com]

Please help me:i am doing programming into vb6.0
i want create one procedure with below requirement in sql 2000.
1)first want run below given select query in VB 6.0

select max(defdate)'DEFERDATE',imageno from logsheet where imageno not in (
select imageno from logsheet where querystatus ='N') and cast(convert(varchar,
defdate,101) as datetime)>= '" & mskdate1 & "' group by imageno

2) i want store 'DEFERDATE', and image number into temp table.
3)Then i want run one more select query with condition 'DEFERDATE', and image
number which i was got into previous query.

"select AccountNo,QueryType,TicklerDate,defcomments,TatDeadLine,defdate,
OperatorId,docketsrecd,SerialNo,source,convert(varchar(10),Starttime,101)
'StartDate',imageno from logsheet " & _
"where convert(VarChar(10),'" & rsGetrecord("DeFERDATE")
& "', 101) between '" & mskdate1 & "' and '" & mskDate2 & "' and ImageNo='" &
Trim$(rsGetrecord!ImageNo) & "'" & _
" and defdate is not null and QueryStatus ='D' And
imageno not in (select imageno from logsheet where QueryStatus = 'F')"

--
Message posted via http://www.vbmonster.com

[Michael Cole]

Dev1511 via VBMonster.com <u49734@uwe> wrote in message
<news:92d7d80f4fbd9@uwe>

> Please help me:i am doing programming into vb6.0
> i want create one procedure with below requirement in sql 2000.
> 1)first want run below given select query in VB 6.0

This really isn't a VB question, its an SQL question. I would suggest that
you repost in microsoft.public.sqlserver.programming

Be aware that they will probably want DDL and queries to populate test data.

--
Regards

Michael Cole