Update A set A.col4 = dtMaxDates.Col4 from TableA a inner join

(Select col1, col2, col3, max(col4) as col4 from dbo.TableB group by Col1, Col2, col3) dtMaxDates

on A.col1 = dtMaxDates.col1 AND A.col2...

Here's a demo with the system tables.

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name + ',...

Or maybe there won't be enough work done on Oracle... I've often seen that sql server will import the whole table(s) and do the work locally without indexes. while...

The more indexes you add, the more it costs to maintain them. But if that costs is less than the cost of a slow query then it can be...

Sure :

GO

CREATE PROCEDURE dbo.Test @Dividor as int

AS

SET NOCOUNT ON

Declare @Er as int

begin tran

Select 10 / @Dividor

Set @Er = @@Error

if @Er 0

begin

print 'There''s an error'

rollback tran

end

else

begin

print 'No problem --...

How the heck did he do that without noticing he was screwing something up??

Good idea, it's true some forums are very specialized...

You'd never do that, would you??

No, I don't know that trick... I usually just copy/paste the whole thing directly and it works.

1=2 returns only the metadata, no select is actually done.

Care to outline the logic of this thing???????????????????????

I can so picture myself doing that .

Maybe we should redo that disaster contest. Looks like we'd have a few new inputs

I see you have way more experience in that area than me. Thanx for sharing.

While I don't know anything about reporting services either, I can suggest that you have a single query (stored proc) with DateFrom parameter that you can set on the client....

I knew you could help him . I must be able to see the future or something