thats correct as you cannot compare a null value as the result comes back as unknown so is excluded from the result set

http://msdn.microsoft.com/en-us/library/ms191270%28v=sql.105%29.aspx

Revenant (6/7/2012)

"This must be a Thursday," said Arthur to himself, sinking...

Something like this perhaps

But without the table definitions and sample data like Gianluca has requested, we are clutching at straws.

with cte as

(

select

sub.SubCategoryId,

sub.SubCategoryName,

sub.CategoryId

,(select COUNT(1) from dbo.tblAdSpace where AdSpaceId in

(

select AdSpaceId...

Nope, there isn't a mark as answered on this site, the posts stay open incase someone else comes along with a better idea.

A CTE is a Common Table Expressrion, it acts like a temporary result set

Here is a link to MSDN http://msdn.microsoft.com/en-us/library/ms190766%28v=sql.105%29.aspx as they can describe it better.

If you have a volume licensing subscription you should have access to MS's download website, if not you will need to uninstall reporting services then reinstall it. Not just...

Not a problem, happy to help as always

you will have another problem whan you change to sharepoint mode, as you will need to create a brand new SSRS db as you cannot run a native mode database...

Looks like a case for row_number and a CTE, if I have undersood your requirements

DECLARE @SchDetail TABLE (dbSchCnt int identity(1,1), dbPatCnt int, dbSchTypeCnt int, dbSchDate datetime, dbSchStatus int)

INSERT INTO @SchDetail...

It might be down to rendering the report as I believe this is excluded from the execution time (I could be wrong). In VS it caches the data so...

govindarajan69 (6/8/2012)

I am also getting this error Error: 18456, Severity: 14, State: 8. + Login failed for user 'sa'. [CLIENT: 192.168.4.52], but the user is not accessing SQL Server directly....

Not got 2005 installed any more so not tested it on 2005, but works on 2008R2, but this should give you the basics, might need a few tweaks.

SELECT

IndexName = i.Name,

ObjectName...

i believe the two options are, download the media which has SP4 built in to the setup.exe or uninstall / reinstall then service pack

In the other tablix where you only want to see specfic subtype, can you not change the grouping on that tablix to group by type and subtype1, then do a...

You say you have gotten authorisation for 2 processor licenses, 2012 is core based so you need to purchase 8 core licenses to cover your upgrade if you remove the...