have u tried using the

SELECT @TABLEHTML

Replace the mail code withe the above statement and try executing the procedure

and check what u get

In Reporting Services Configuration Manager - set the web service identity and windows service identity. Then the service has access permission to all the folders.

Excellent question and great to know the deal

START PROGRAMMING.....

You can also use the following query....

select PostCode, count(*) as NumOfRecords,

count(flag) as NumOfFlag

from Demo

group by PostCode

Although the topic is not relevant to the description and question that is being raised...

IS NULL if used against the variable will check

1. Whether the variable is assigned to any...

Very nice question.

Basic and something good to learn

You need the report files with .rdl extension in order to edit the report in BIDS (which will provide better UI enabled editing)....

I am really not sure what is required...

Assuming that you are searching for the rows that do not have transations in year 2010, you can try the following one

SELECT ...

I didnot like the question...

Nothing to learn as the syntax err is quite obviously seen...

Thought as a typo and gone with the wrong option...

IT DOESNT SEEMS TO BE TRICKY AT...

Very Nice question

I am not sure but the query is returning me 5....

I dont have the AdventureWorks db on the server...

Tried using the test database with dbo schema.... may be...

Try this one out!!!!

Assuming the table name is temp

select isnull(a.continent,''),isnull(a.country,''),city

from (select continent,country,min(city) as city1 from temp group by continent,country) as a

right outer join

temp on a.city1 = temp.city

Hope this can be...

Hi,

I am not sure about the best way it can be done, or the way you had tried this .

You can use the following query to get the required stats:

select...