Generally over small datasets a CTE will be faster.

Can...

You can't create a view this way. Where are you getting the id from in the case statement? It can't be from the earlier selects. I think...

Q (4/28/2008)

---

Jack,

wouldn't this query work in 2000?

select * From syscolumns

where autoval is not null

to get more specific info

select a.name as ColumnName ,b.name as TableName

From syscolumns a

inner join...

I think I see what you are asking for now. I never mention in the...

The question CLEARLY states "In SQL...

I thought the article was well-written and easy to follow. I do agree with others that loading the first row (header) as data in the source would be the...

Excellent Peter, I should have thought of that, too! It's a simple solution.

I believe you need to use "*" in SSRS as it is not SQL, but .net.

I think this will work:

[font="Courier New"]CREATE TABLE #db_size

   (

   data_Id INT,

   run_Date DATETIME,

   data_size_mb DECIMAL(15, 2)

   )

  

INSERT INTO #db_size

   SELECT

       3311, '2007-01-02 00:00:00.000', 2977404.13

   UNION

   SELECT

       3327 ,'2007-01-04 00:00:00.000',...

junkmail (4/25/2008)

---

It appears that the problem is that you cannot use an "@" in a Create Table.

So somehow I need to be able to generate the GetDate() result and...

Run Select @@Version and you get something like this:

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

Mar 23 2007 16:28:52

Copyright (c) 1988-2005 Microsoft Corporation

Developer Edition on Windows NT 5.1...

How are you going to change the logo? Are you going to put in a switch statement that loads an image from a file?

The only way I know to...

Prasad Bhogadi (4/25/2008)

---

Just you need to verify if your web.config file under Report Server and Report Manager have any xmlns links inside the Configuration tag and remove them.

configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" then...

If you have installed SP2 this could be your issue.

I thought there was a way to assign a style tag to elements in a report, but I can't find the way to do it now.