Can you give some example data and table structure(s)?

Are you returning all the data needed in the report in one data set or multiple data sets? What does the...

I don't know that I would say "evil", but dangerous would be a good term. I mean how can it be evil when the whole point of storing data...

Here is a link to another forum discussing parameterized views (which SQL Server does not have) which applies to what you want to do, I think.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73034

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...