RE: [sqr-users] Parameter Flag

["Carlos Loperena Matias" <cloperena@elnuevodia.com>]

Hi Vito, I do a select with paramaters like this. 

select 
h.bdry_nm,dh.special_bdry_type_cd,h.bdry_short_nm,dt.draw_id,dos_id,datename(weekday,dtos_id),dtos_id,
dh.qty,0
from draw_hierarchy dh, hierarchy h, ##driver_table dt
where dh.structure_id = 7 
and dh.bdry_id = h.bdry_id
and dh.draw_id = (dt.draw_id)
and dh.special_bdry_type_cd <> 'RET' 
and h.bdry_short_nm in 
('{Abczone}HDHD','{Abczone}HDEM','{Abczone}HDCT','{Abczone}HDML','{Abczone}SCDL','{Abczone}SCHK','{Abczone}SCSC','{Abczone}SCBK')

Have Fun

Carlos A. Loperena Matías
El Nuevo Dia - Sistemas de Información 787-641-8000x2984
mailto:cloperena@elnuevodia.com

 -----Original Message-----
From:   sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]  On Behalf 
Of Vito Campanelli
Sent:   Thursday, February 05, 2004 10:13 AM
To:     sqr-users@sqrug.org
Subject:        [sqr-users] Parameter Flag

Hi,

I am fairly new to SQR. I am having trouble trying to create the SQR
command line with parameters. The select query that I would like to
execute is as follows:

Select * from employees where id in ('1001', '1212', etc)

Can anybody help with this?

Thanks
Vito


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


The information contained in this message is confidential and is intended for 
the addresses only.  If you have received this message in error or there are 
any problems, please notify the sender immediately.  The unauthorized use, 
disclosure, copying or alteration of this message is strictly forbidden. 




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users