encore India India, Secunderabad   04:32

Message

webmaster, 16 March 2009
India India , Secunderabad


Attendance Query

select src_icd, * from att_attndnc_log_dtls where src_icd='11065'and rgstrtn_cd='r080001200585'

React to this message

Picture and video

Experience the adventures even better and surprise the author.

Reactions to this message

Address

16 March 2009

select a.src_icd,rgstrtn_cd,stdnt_nm,stdnt_c_addrss,stdnt_c_cty,stdnt_c_pncd,stdnt_c_phn,stdnt_c_mbl from reg_stdnt_dtls a, reg_stdnt_rgstrtn_dtls b
where a.src_icd='11065' and a.stdnt_cd=b.stdnt_cd and b.rgstrtn_cd in ( ) and a.src_icd=b.src_icd

meena

29 March 2009

i wanted to now how can get these types of queries

..

29 March 2009

select distinct a.stdnt_nm,b.rgstrtn_cd,b.stdnt_cd,b.stdnt_stts,b.crs_cd,b.smstr_cd,b.crrnt_btch_cd,a.stdnt_c_phn,a.stdnt_c_mbl,a.stdnt_c_addrss,
b.rgstrtn_dt,sol_dt,b.src_icd,b.curr_cd from reg_stdnt_dtls a join reg_stdnt_rgstrtn_dtls b on a.stdnt_cd=b.stdnt_cd where b.rgstrtn_cd='p889226'and b.src_icd='17899'

wting

30 March 2009

SELECT reg_stdnt_dtls.src_icd,reg_stdnt_dtls.stdnt_nm as stdnt_nm,
reg_stdnt_rgstrtn_dtls.rgstrtn_cd as rgstrtn_cd,
reg_stdnt_rgstrtn_dtls.crs_cd as crs_cd,
reg_stdnt_rgstrtn_dtls.rgstrtn_dt as rgstrtn_dt,
reg_stdnt_rgstrtn_dtls.sol_dt as sol_dt , reg_stdnt_rgstrtn_dtls.stdnt_stts
FROM reg_stdnt_dtls , reg_stdnt_rgstrtn_dtls where reg_stdnt_dtls.stdnt_cd=reg_stdnt_rgstrtn_dtls.stdnt_cd and reg_stdnt_rgstrtn_dtls.stdnt_stts='wting' and reg_stdnt_dtls.src_icd='11065'

ICT & ICS FULL QUERY

2 April 2009

select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts in
('WTING','BREAK','BDOUT','VALID','DEFLT','CLSOL','COMPL'Wink and a.stdnt_cd=b.stdnt_cd and a.crs_cd in('ICS','ICT'Winkand a.src_icd='11065'

OB QUERY

2 April 2009


select a.cntr_cd,a.cntr_nm,new_ctgry,d.rgstrtn_cd,d.stdnt_cd,stdnt_nm, stdnt_c_phn,stdnt_c_mbl,
fee_cmpnnt_cd,b.amnt_pybl,amnt_pd,"Month" = month(due_dt),prvsnl_flg,ordr_bk_stts,d.crrnt_btch_cd
from ccl_mst_cntr a,acc_ordr_book_dtls b, acc_ordr_book_hdr c, reg_stdnt_rgstrtn_dtls d,reg_stdnt_dtls e
where --a.rgn_cd in ('R06'Winkand
a.cntr_cd=b.src_icd and cntr_stg = 'opr' -- and prvsnl_flg ='Y'
and b.src_icd=c.src_icd
and c.src_icd=d.src_icd
and d.src_icd=e.src_icd
and b.ordr_bk_nmbr=c.ordr_bk_nmbr
and c.rgstrtn_cd=d.rgstrtn_cd
and d.stdnt_cd=e.stdnt_cd
and d.rgstrtn_dt < '2008-03-01' --and c.ordr_bk_stts<>'X'
and b.due_dt >='2008-03-01' and b.due_dt <='2008-03-31'
and d.src_icd in ('11065'Wink
and new_ctgry='METRO'
and d.stdnt_stts in ('WTING','VALID','DEFLT','BREAK','PPWTG'Wink
and b.amnt_pybl > 0
order by d.rgstrtn_cd

student phone detail

11 April 2009

select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts in
('VALID','clsol','certf','compl','deflt'Wink and a.stdnt_cd=b.stdnt_cd and a.crs_cd in('cjev2'Winkand a.src_icd='00017'

with batch code

11 April 2009

select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts,crrnt_btch_cd from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts in
('VALID','clsol','certf','compl','deflt'Wink and a.stdnt_cd=b.stdnt_cd and a.crs_cd in('cjev2'Winkand a.src_icd='00017'

clsol_null records

15 April 2009

select a.rgstrtn_cd,a.stdnt_cd,b.stdnt_nm,c.apprsl_no,c.ttl_scr,a.crs_cd,enrllmnt_nmbr,crrnt_btch_cd,
datediff(dd,cmpltn_dt,getdate())"TAT",b.src_icd, stdnt_stts
from reg_stdnt_rgstrtn_dtls a, reg_stdnt_dtls b,app_stdnt_rgstr c
where a.rgstrtn_cd=c.rgstrtn_cd and a.stdnt_cd=b.stdnt_cd and a.src_icd=b.src_icd
and b.src_icd='11065'
and a.crs_cd='ICT' and stdnt_stts in ('clsol','wting'Wink and c.ttl_scr is null

batch wise attend

31 May 2009

select src_icd, * from att_attndnc_log_dtls where src_icd='11065'and btch_cd='b090673'

icsi enroll_studID

5 June 2009

select a.rgstrtn_cd,a.stdnt_cd,b.stdnt_nm,enrllmnt_nmbr,b.src_icd
from reg_stdnt_rgstrtn_dtls a, reg_stdnt_dtls b,app_stdnt_rgstr c
where a.rgstrtn_cd=c.rgstrtn_cd and a.stdnt_cd=b.stdnt_cd and a.src_icd=b.src_icd
and b.src_icd='11065'
and a.stdnt_cd in

RV query

9 June 2009

select rgstrtn_cd,vchr_nmbr,sbsdy_amnt,cncssn_cd,src_icd from acc_stdnt_sbsdy_dtls
where rgstrtn_cd in ('R081106501537'Wink and src_icd='11065'

feedback

9 June 2009

select * from fbk_form_qstn_dtls where fdbck_nu='FBM100023' and src_icd='11065'

batch wise phone

12 June 2009


select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts in
('WTING','BREAK','BDOUT','VALID','DEFLT','CLSOL','COMPL','CERTF'Wink and a.stdnt_cd=b.stdnt_cd and a.src_icd='11065' and crrnt_btch_cd in('b090672','b090673','b090679','b090699','b100026','b100023'Wink

S.ID = Phone Number

18 June 2009

select a.src_icd,a.stdnt_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where
a.stdnt_cd=b.stdnt_cd and a.src_icd='11065' and a.stdnt_cd in (''Wink

last session

15 July 2009


select a.stdnt_cd,a.stdnt_nm,b.rgstrtn_cd,a.rgstrtn_dt,b.btch_stts,b.sssn_nmbr,
a.stdnt_c_phn,a.stdnt_c_mbl,a.crs_cd,a.sol_dt,a.crrnt_btch_cd,a.smstr_cd,a.stdnt_stts
from reg_view_stdnt_bsc a , reg_stdnt_smstr_dtls b
where a.rgstrtn_cd=b.rgstrtn_cd
and a.stdnt_cd in ('Wink and a.src_icd= '11065'

reg=phone

4 August 2009

select a.src_icd,a.stdnt_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where rgstrtn_cd = 'r071106501343' and
a.stdnt_cd=b.stdnt_cd and a.src_icd='11065'

reg=phone

4 August 2009

select a.src_icd,a.stdnt_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where rgstrtn_cd = 'r071106501343' and
a.stdnt_cd=b.stdnt_cd and a.src_icd='11065'

batch wise

30 August 2009

select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where a.stdnt_cd=b.stdnt_cd and a.src_icd='11065' and crrnt_btch_cd='b100144'

name search

30 August 2009

select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where a.stdnt_cd=b.stdnt_cd and a.src_icd='11065' and stdnt_nm like '%kiranma%'

with email & phone

10 September 2009

select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts,stdnt_eml_addrss
from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts in
('VALID','clsol','certf','compl','deflt'Winkand a.stdnt_cd=b.stdnt_cd and a.crs_cd in('osq','daf','odf'Winkand a.src_icd='10695'

E MAIL& PHONE

12 October 2009


select a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts,stdnt_eml_addrss
from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts in
('VALID','clsol','certf','compl','deflt'Winkand a.stdnt_cd=b.stdnt_cd and crrnt_btch_cd in('b100013','b100012','b100198'Winkand a.src_icd='11065'

DIVYA

30 October 2009

select src_icd, * from att_attndnc_log_dtls where src_icd='11065'and rgstrtn_cd='r080001200585'

Course Ware

30 October 2009

select distinct item_cd, a.rcpt_nmbr,c.rgstrtn_cd,e.stdnt_nm,e.stdnt_c_addrss,e.stdnt_C_phn,e.stdnt_c_mbl, a.smstr_cd,stts, a.fee_cmpnnt_cd,rcpt_dt,crrnt_btch_cd,stdnt_stts,a.src_icd
from acc_invntry_iss_dtls a, acc_rcpt_book_hdr b,
reg_stdnt_rgstrtn_dtls c,acc_ordr_book_hdr d,reg_stdnt_dtls e
where a.src_icd ='11065' and a.src_icd =b.src_icd
and b.src_icd =c.src_icd and c.stdnt_cd=e.stdnt_cd and c.src_icd =d.src_icd
and a.rcpt_nmbr = b.rcpt_nmbr
and b.stdnt_rfrnc_cd = d.rgstrtn_cd
and d.rgstrtn_cd =c.rgstrtn_cd
and rcpt_dt >= '2009-01-01' and a.rcpt_nmbr like '11065%'
and b.cnclld_dt is null
and stts ='N'
order by a.smstr_cd

.......

9 December 2009

fduyfudhufiydfuidhufdhuifydf

tat query

23 December 2009

select a.src_icd,a.stdnt_cd,rgstrtn_cd,b.stdnt_nm,stdnt_c_mbl,stdnt_eml_addrss,crs_cd,crrnt_btch_cd,cmpltn_dt,stdnt_stts,
datediff(dd,cmpltn_dt,getdate())"TAT",b.src_icd
from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b
where stdnt_stts in ('compl'Wink and a.src_icd=b.src_icd and a.stdnt_cd=b.stdnt_cd and a.src_icd in ('00601'Wink

naveen query

29 December 2009

select a.src_icd,a.stdnt_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where
a.stdnt_cd=b.stdnt_cd and a.src_icd='00601' and a.stdnt_cd in ('s100060100405','s090060100455'Wink

sankar_new update

13 January 2010

select a.src_icd,a.stdnt_cd,a.rgstrtn_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where rgstrtn_cd = 'r071106501343' and
a.stdnt_cd=b.stdnt_cd and a.src_icd='11065'

snk_reg_phone_status

13 January 2010

select a.src_icd,a.stdnt_cd,a.rgstrtn_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where rgstrtn_cd = 'r071106501343' and
a.stdnt_cd=b.stdnt_cd and a.src_icd='11065'

snk_certif_issued

13 January 2010

select * from trx_rqst
where rgstrtn_cd in ('R091109400141'Wink and src_icd='11094'

snk_certif_printed

13 January 2010

select * from crt_crtfct
where rgstrtn_cd in ('R091109400141'Wink and src_icd='11065'

snk_stud_reg_phone

13 January 2010

select a.src_icd,a.stdnt_cd,rgstrtn_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where
a.stdnt_cd=b.stdnt_cd and a.src_icd='11065' and a.stdnt_cd in (''Wink

cert no i null

27 January 2010

select * from crt_crtfct
where rgstrtn_cd in ('' ) and cft_no is null and src_icd='11065'

with reg date

26 February 2010

select a.src_icd,a.stdnt_cd,rgstrtn_cd ,rgstrtn_dt,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where rgstrtn_dt>='2009.10.01'and a.stdnt_cd=b.stdnt_cd and a.crs_cd in('djvt','ddnt'Winkand a.src_icd='11065'

ICSI URL

19 March 2010


URL :: http://icsi.in/ICSIInternal.aspx

Login-ID à poonam_niit

1qaz2wsx

compl

26 April 2010

select a.src_icd,a.stdnt_cd,a.rgstrtn_cd,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts = 'compl' and
a.stdnt_cd=b.stdnt_cd and a.src_icd='00601'

aptc voucher data

10 May 2010

select a.src_icd,substring(a.stdnt_nm,1,30),a.rcpt_nmbr,a.rcpt_dt,c.pymnt_cd,b.fee_cmpnnt_cd,c.pymnt_amnt

from acc_rcpt_book_hdr a,acc_rcpt_book_dtls b,acc_rcpt_book_pymd c

where a.src_icd=b.src_icd and a.rcpt_nmbr=b.rcpt_nmbr and

a.rcpt_nmbr=c.rcpt_nmbr and b.rcpt_nmbr=c.rcpt_nmbr and a.src_icd=c.src_icd and b.src_icd=c.src_icd and

a.rcpt_dt between '2009-07-01' and '2009-07-31' and a.src_icd='11065' and b.fee_cmpnnt_cd in('A73','A74','026'Wink

and b.cnclld_dt is null

Midlaunch_Batches

18 May 2010

Select src_icd, btch_cd, strt_cntct_nmbr, smstr_cd, btch_strt_dt, prjctd_end_dt, fclty_cd, cnfrmd_stdnt from bsh_btch where src_icd = '00601' and cancld_stts = 'n' and cnfrmd_stdnt > 1 and smstr_cd not like 'SM [5-6}00' and btch_clos_dt is null

course reg with date

24 May 2010

select rgstrtn_dt,a.src_icd,a.stdnt_cd,rgstrtn_cd ,stdnt_nm,stdnt_c_phn,crs_cd,stdnt_c_mbl,stdnt_stts from reg_stdnt_rgstrtn_dtls a,reg_stdnt_dtls b where stdnt_stts in
('COMPL','certf','clsol'Wink and a.stdnt_cd=b.stdnt_cd and a.crs_cd in('ccnap'Winkand a.src_icd='11065' and rgstrtn_dt >='01/01/2010'

bbg

8 November 2010

select a.src_icd,substring(a.stdnt_nm,1,30),a.rcpt_nmbr,a.rcpt_dt,c.pymnt_cd,b.fee_cmpnnt_cd,c.pymnt_amnt

from acc_rcpt_book_hdr a,acc_rcpt_book_dtls b,acc_rcpt_book_pymd c

where a.src_icd=b.src_icd and a.rcpt_nmbr=b.rcpt_nmbr and

a.rcpt_nmbr=c.rcpt_nmbr and b.rcpt_nmbr=c.rcpt_nmbr and a.src_icd=c.src_icd and b.src_icd=c.src_icd and

a.rcpt_dt between '2010-11-01' and '2010-11-08' and a.src_icd='00601' and b.fee_cmpnnt_cd in('a73'Wink
and b.cnclld_dt is null

Rooms

1 December 2010

Hi, we got rooms for rent
In Goa, Panaji 500 rps per day
call for info 00919881260737
Calum

ms

13 January 2011

Location: http://ho(tfixv4.microsoft.com/Windows%20XP/sp4/Fix239730/2600/free/359413_ENU_i386_zip.exe)
Password: %DNsc![%

ob n case y case

25 February 2011

select a.cntr_cd,a.cntr_nm,new_ctgry,d.rgstrtn_cd,d.stdnt_cd,stdnt_nm, stdnt_c_phn,stdnt_c_mbl,
fee_cmpnnt_cd,b.amnt_pybl,amnt_pd,"Month" = month(due_dt),prvsnl_flg,ordr_bk_stts,d.crrnt_btch_cd
from ccl_mst_cntr a,acc_ordr_book_dtls b, acc_ordr_book_hdr c, reg_stdnt_rgstrtn_dtls d,reg_stdnt_dtls e
where a.rgn_cd in ('R06'Winkand
a.cntr_cd=b.src_icd and cntr_stg = 'opr' and prvsnl_flg ='n'
and b.src_icd=c.src_icd
and c.src_icd=d.src_icd
and d.src_icd=e.src_icd
and b.ordr_bk_nmbr=c.ordr_bk_nmbr
and c.rgstrtn_cd=d.rgstrtn_cd
and d.stdnt_cd=e.stdnt_cd
and d.rgstrtn_dt < '2008-03-01' and c.ordr_bk_stts<>'X'
and b.due_dt >='2008-03-01' and b.due_dt <='2008-03-31'
and d.src_icd in ('11065'Wink
and new_ctgry='METRO'
and d.stdnt_stts in ('WTING','VALID','DEFLT','BREAK','PPWTG'Wink
and b.amnt_pybl > 0
order by d.rgstrtn_cd

niit bbg

4 March 2011

hello david sir

hanumanth rao

17 May 2011

i want niit queris

hanumanth rao

17 May 2011

please send query

NIIT

23 February 2012

please send nitat quries please

NIIT bbg

23 February 2012

Please send Nitat quries please

NIIT

23 February 2012

ob quries are not working please send once

poonam

27 April 2012

select a.src_icd, rgstrtn_cd, a.stdnt_cd, stdnt_nm, stdnt_c_addrss,stdnt_c_cty,stdnt_c_pncd,stdnt_eml_addrss,
stdnt_c_phn, stdnt_c_mbl, crs_cd, smstr_cd,
crrnt_btch_cd, stdnt_stts, rgstrtn_dt, sol_dt from reg_stdnt_dtls a, reg_stdnt_rgstrtn_dtls b
where a.src_icd = b.src_icd and a.src_icd = '00125' and a.stdnt_cd = b.stdnt_cd and stdnt_stts = 'break'
ssa

Concern ...

14 August 2012

Respect the purpose of the website. SQL Queries on a Travel oriented site is grossly misplaced.

Attendance Query

25 August 2012


select src_icd, * from att_attndnc_log_dtls where src_icd='11065'and rgstrtn_cd='r080001200585'

icici

4 September 2012


Your Request has been created successfully.

Your service request number is : SR237332068.

Please note the same for future reference.

Your request would be processed by 05-Sep-2012

You can also check the status of your request through Track your Service Request

Rao and Rao

7 August 2013

Hi

file

12 August 2013

http://www.filecrop.com/1z0-052-latest-dumps.html

query

2 April 2014

ob query

I want to know FACT test score.....what query we can use....????

Profile


Current location:
India India, Secunderabad

Today:

16°/30°

Tomorrow:

16°/30°

My travel status:
I will depart in 0 days
My current travel:
encore
My visited countries:
IndiaNetherlands

Latest messages

India  16/3/2009 Attendance Que... (59)
Netherlands  16/3/2009 Welcome! (4)

Keep in touch!

Email
RSS

Yes, I would like to receive an email whenever a new message is posted!

My emailaddress:

Add hyperlink to your favorite RSS reader



What's this?

This diary was visited 24486 times and is part of WhereAreYou.net