InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 19:40:17 GMT20http://www.sqlservercentral.com/Forums/Topic1356668-392-1.aspx[quote][b]raghuldrag (9/11/2012)[/b][hr]hey friend i am executing dis qury on sql server 2000 only...its not server 2008[/quote]I guessed that much from the subject of your post.[url=http://www.sqlservercentral.com/Forums/Forum8-1.aspx]Here [/url]is a link to the SQL Server 2000 forum.Tue, 11 Sep 2012 07:45:07 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1356668-392-1.aspx[quote][b]raghuldrag (9/11/2012)[/b][hr]hey friend i am executing dis qury on sql server 2000 only...its not server 2008[/quote]But we still don't know what the question is. It has been suggested you read the article found at the first link in my signature. Perhaps you could read this one too. [url=http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx]http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx[/url]Tue, 11 Sep 2012 07:21:33 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1356668-392-1.aspxhey friend i am executing dis qury on sql server 2000 only...its not server 2008Tue, 11 Sep 2012 07:07:28 GMTraghuldraghttp://www.sqlservercentral.com/Forums/Topic1356668-392-1.aspxOnce again, I have to remind you that this is a [b]SQL Server 2008[/b] forum.Tue, 11 Sep 2012 01:37:10 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1356668-392-1.aspxwhile em using str in my query its showing error, likeselect slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdatefrom GOALSDTLunionselect str((slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdate),5,2)from GOALSDTL_Historyerror:doest convert date into intMon, 10 Sep 2012 22:41:02 GMTraghuldraghttp://www.sqlservercentral.com/Forums/Topic1356668-392-1.aspx[quote][b]raghuldrag (9/10/2012)[/b][hr]alter procedure Goals_history ( @stuid nvarchar(22), @startyear nvarchar(22), @endyear nvarchar(22), ) as begin select name,class,noofsubject,rank,test from @tab1 union select name,class,subject,rank,test from @tab2 where rank is not null and studentname=@stuid and accodomicyear>=@startyear and accodomicyear<=@endyear end OUTPUT: class noofsubject rank test name 2 5 1 revision ravi 2 5 - monthly raju 2 5 3 midterm ravi 6 4 - monthly somu 2 5 - revision ravi expectin outputrank is null means show first) class noofsubject rank test name 6 4 - monthly somu 2 5 - monthly raju 2 5 - revision-II ravi 2 5 1 revision ravi 2 5 3 midterm ravi :NOTE \ null values ve print first row of output..... not null is ve to print with space.... how to define[/quote]Please see the first link in my signature about best practices when posting questions.Mon, 10 Sep 2012 08:50:55 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1356668-392-1.aspxalter procedure Goals_history ( @stuid nvarchar(22), @startyear nvarchar(22), @endyear nvarchar(22), ) as begin select name,class,noofsubject,rank,test from @tab1 union select name,class,subject,rank,test from @tab2 where rank is not null and studentname=@stuid and accodomicyear>=@startyear and accodomicyear<=@endyear end OUTPUT: class noofsubject rank test name 2 5 1 revision ravi 2 5 - monthly raju 2 5 3 midterm ravi 6 4 - monthly somu 2 5 - revision ravi expectin outputrank is null means show first) class noofsubject rank test name 6 4 - monthly somu 2 5 - monthly raju 2 5 - revision-II ravi 2 5 1 revision ravi 2 5 3 midterm ravi :NOTE \ null values ve print first row of output..... not null is ve to print with space.... how to defineMon, 10 Sep 2012 05:37:55 GMTraghuldrag