Will surely try this.

My other issue is I have to get this working in Sybase as well which probably does not allow this syntax.

Anyway, thank you so much for the...

"Object a not found..." error occures

not a problem!

You are welcome.

Actually yoiu need to develop a custom Split function

you can refer -

http://www.sqlservercentral.com/Forums/Topic129079-150-1.aspx?Highlight=fnSplit

are you checking if the page is PostBack?

Set the RepeatHeaderOnNewPage property of the Table to TRUE and

RepeatOnNewPage property of the Table Row that has the headers - to TRUE.

I suppose you want to show some column value depending on some condition and also some other column value depending on some condition combined with the 1st column.

e.g.

SELECT ...

Correct me if this is an incomplete/wrong observation but I tried and observed that following info also needs to be present in the URL in addition to the one you've...

Do you have a criterian for the First of ward and code as the first occurrence according to the date column i.e. for the minimum date?

talking about seperation of date and time datatypes(SQL 2008)

I am sure everybody's visit to http://www.sqlservercentral.com/articles/News/3253/

in this regard......

You can use the .Net ReportViewer Control for this.

Have you concluded that fixing this using SQL would affect perofrmance? (like using group by).

Otherwise using SQL similar to following can get you the desired result:

select * from YOURTABLE t...

Resourse database is not system database available directly so the answer is wrong. Correct answer should be master,model,msdb and tempdb only!

First Option is correct, no error is displayed whatsoever.....

I want the point 🙂

Have you tried something similar to the following already?

declare @cnt int

declare @STR nvarchar(50)

set @cnt=1

set @STR = SELECT TOP ' + Convert(char(1), @cnt) + ' cost...