In SQL, you can do DELETE FROM too

see how many count(1) you get?

DELETE PW -- COUNT(1)

FROM performance_esx3_workload PW

INNER JOIN performance_sample PS

ON PW.sample_id =...

I have a question

If a subscriber wants a report at 9 AM

won't it still be 9 AM after the DST change?

The SQL time changes with the OS time change

Mnn, darn, I haven't touched SSRS in this deep level for a while

so are you doing this in Table or Matrix?

If you're using Table, are you using any Group By?

because...

See if this gives you a headstart

Not the ultimate best solution without knowing all details

[font="Courier New"]DECLARE @test-2 TABLE (

region_id INT,

reviewed_date DATETIME,

grade FLOAT

)

INSERT INTO @test-2

SELECT

'1','10/10/2008','1.0'

UNION ALL SELECT

'1','09/09/2008','2.0'

UNION ALL SELECT

'1','08/08/2008','1.0'

UNION ALL...

or the non-set operation (not recommended, ha)

SELECT data FROM A WHERE id = @id

IF @@ROWCOUNT = 0

SELECT data FROM B WHERE id = @id

is it a Email Group name like "All Company"?

or an email list like "sqldba@company.com" that actually consists of multiple emails

There shouldn't be a difference between Individual@company.com vs Group@company.com as far...

to clarify, given your Excel #'s (let's take HMO 20081001)

# of non-contracted clean claims processed/adjudicated* within 30 calendar days (<=30 days)6673

# of non-contracted clean claims processed/adjudicated* within the reporting...

You should provide code to populate the sample data (see Best Practice for Forum)

If you're using SQL 2005, I suggest you look into PIVOT functions (cross-tab)

This is what it's for

Otherwise,...

Thanks for the heads up, I don't like my domain provider more now

I recall I have remvoed 2005 components AFTER I have installed 2008, it should be safe

It is Microsoft...

Computed column is the way to go

make it PERSIST if you can too

http://msdn.microsoft.com/en-us/library/ms191250.aspx

Computed columns can be used in select lists, WHERE clauses, ORDER BY clauses, or any other locations in...

If you right click on the installer, can you see the version?

My 2008 RTM setup.exe has this version = 2007.100.1600.22

As far as I know, RTM all come in ISO images

I...

I would prefer they not be upgraded by default

There are cases where one needs both SSMS 2005 & SSMS 2008 installed (what I currently have)

For me, it's more for BIDS...

what are the SQL 2005 and 2008 versions?

It should work fine

Can you connect to the SSRS 2005 using the "Reporting Service Manager" in your SQL 2008 Program Menu\Configuration shortcut?

or if that's all you need

declare @sql varchar(max)

select @sql = COALESCE(@SQL,'') + FieldName + ','

from (

select 'REQUESTOR_NAME' AS FieldName

union all

select 'REQUESTOR_EMAIL'

) T

print 'SELECT ' + @sql + ' FROM BidData...

If you're using SQL 2005, look into PIVOT functions

http://msdn.microsoft.com/en-us/library/ms177410(SQL.90).aspx

Although if there's unknown # of rows, PIVOT may not work so well

Google for 'crosstab'