Hi,

BOL is best option to find the answer of your questions.

DBCC DROPCLEANBUFFERS Removes all clean buffers from the buffer pool.

Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache...

Hi Jason,

I think it should work.

I tried here and working fine at my machine.

--Try this

CREATE TABLE Test(Col int DEFAULT 0)

INSERT INTO TEST DEFAULT values

SELECT Col FROM Test

Even you can use same query if Col is IDENTITY like:

CREATE TABLE Test(Col int Identity(1,1))

INSERT INTO...

Hi

Just change your Group By statement like:

GROUP BY Tidspunkt,DATEADD(hour,0,DATEADD(hour, DATEDIFF(hour, 0, Tidspunkt), 0))

toolman (7/21/2008)

---

Just so you know why the IIF doesn't work: IIF is a function. SSRS reads the entire statement kind of from the inside out. It sees...

thatok,

Its not clear about your source...

Samarth,

see the result now:

CREATE TABLE...

rosh (7/22/2008)

---

Do you just need the column list from the table #T

If so then see if this query helps you.

SELECT * FROM tempdb.sys.columns

WHERE object_id = (SELECT object_id FROM tempdb.sys.objects WHERE...

USE [AdventureWorks]

GO

SELECT JobCandidateID,Resume FROM HumanResources.JobCandidate

-- Consider Resume column

Hi Rosh,

Thanks for reply.

I know that temp tables get created into system DB (tempdb).

Can you write a query for that?

Suppose my stored procedure looks like this:

CREATE PROC TestProc

AS

BEGIN

...

Do they have same data types?

I think some column is of varchar

WHERE T_Customers.ExpiryDate = DATEADD(day,7,GETDATE())

=JOIN(Parameters!ParameterName.Value,",")

or

=JOIN(Parameters!ParameterName.Label,",")

Hi Satish,

Below mentioned link will help you a lot to learn SSRS

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/

Hi,

You need to write following expression in Group Header/Footer:

=SUM(Fields!FieldName.Value)