Comments by aryanbharti

aryanbharti 11-May-11 1:54am View

JobCode is int. my Query was runing well but today i truncate table and insert new data then it enable to fetch data.

aryanbharti 11-May-11 1:38am View

I have put jobcode in where condition see in query

rp_tbl_family.family_id=rp_tbl_professional.family_id where 1=1 and rp_tbl_CreateNewJob.JobCode =' + convert (varchar(50),@JobCode)+ ' and rp_tbl_personal_details.dob BETWEEN ' + ''''+ convert(varchar(50),@dob) + ''''+' and ' +''''+ convert(varchar(50),@do)+''''
if (@prof_qual!='')
begin
set @proce =@proce + ' and rp_tbl_academic_details.prof_qual in ('+'''' + convert (varchar (50),@prof_qual)+''')'
end
if (@prof_stream!='0')
begin

aryanbharti 4-May-11 7:32am View

http://demos.telerik.com/aspnet-ajax/calendar/examples/datepicker/custompopup/defaultcs.aspx

Hope it will help you

aryanbharti 3-May-11 9:20am View

Hi It will be better to do it using stored procedure. It will be easy to bind Grid and show data from database.

aryanbharti 13-Apr-11 8:58am View

yes i got it. thanks

aryanbharti 13-Apr-11 8:58am View

yes i got it. thanks

aryanbharti 22-Mar-11 3:14am View

Deleted

its not working same error. what is n here
SELECT DATENAME(MONTH,DATEADD(MONTH,n,@subscriptionstartdate)) AS MnthName
FROM Nums
WHERE N<=256 AND DATEADD(DAY,DATEDIFF(DAY,0,DATEADD(MONTH,n,@subscriptionstartdate)),0) <= @subscriptionenddate
GO

aryanbharti 22-Mar-11 2:28am View

I have tried same query just few minutes before and again there was same error
Msg 207, Level 16, State 1, Line 15
Invalid column name 'n'.
Msg 207, Level 16, State 1, Line 13
Invalid column name 'n'.

aryanbharti 22-Mar-11 2:14am View

Deleted

there is erroe.

Msg 207, Level 16, State 1, Line 15
Invalid column name 'n'.
Msg 207, Level 16, State 1, Line 13
Invalid column name 'n'

aryanbharti 21-Mar-11 8:08am View

I have use asp.page and also .ascx controls. and when i am inserting any data using my page or controls then its takes more time to response.

Comments by aryanbharti (Top 10 by date)