Comments by Hitesh Varde

Hitesh Varde 12-May-14 8:04am View

Can you please provide some code you implemented for gridview to get better idea for your query?

Hitesh Varde 3-May-14 5:12am View

you have to check condition in code behind event raised by CustomValidator Control.

Hitesh Varde 29-Apr-14 5:53am View

I just pointed if you want to update.

Hitesh Varde 29-Apr-14 5:02am View

you not need to take 'from @temp' at the end in your query.

Hitesh Varde 23-Apr-14 3:08am View

To be clear,
you are looking to insert CustId from CustomerVoterInfo into Voterinfore, and rest from Voterinfore remains the same?

Hitesh Varde 22-Apr-14 3:10am View

SET @vQuery ='SELECT Child.gpmctc as gpmctc,Child.village as village ,Child.habitation as habitation,
Child.cname as cname, Child.sex as sex,Child.dob as dob,Child.sch_code as sch_code,Child.class as class,
Child.nereason as nereason,Child.droupout as droupout,Child.highclass as highclass
FROM ' + @ChildTblName + ' As Child
WHERE Child.distt = ' + @DistrictID + ' and LTRIM(RTRIM(ISNULL(sch_code,'''')))='''' and Child.block=' + @blockcode + ' and age>=6 and age<=14'

Hitesh Varde 21-Apr-14 7:22am View

Got what you want?

Hitesh Varde 21-Apr-14 4:40am View

Can you provide insert script for your data and expected result (Not the result you are getting in query editor)?

Hitesh Varde 21-Apr-14 3:10am View

Hi,

declare @rollnumber varchar(max)
declare @str nvarchar(max)
set @rollnumber ='4197'',''4195'

set @str= 'SELECT studentname from [Student]
where [id ] in (''' + @rollnumber + ''')'

exec sp_executesql @str
Try above query, let me know if it helps?
Can you please provide some sample data and expected result to provide you with suitable solution?
Thanks,
Hitesh Varde

Comments by Hitesh Varde (Top 9 by date)