I guess by your post that you want to check the table structures not the data. The comparison will depend on column sequence.

select c.*

from sysobjects o

inner join syscolumns...

Well Kenneth says it all

Looking at the code is the only surest way. What I would do is script all the procs into...

Is there any way of getting the list of the DTS in a server?

SELECT * FROM msdb.dbo.sysdtspackages...

Ryan beat me to it, however I would write the query as one, thus

SELECT ProductID

FROM tblProductAttributeValues

WHERE av.Active = 1 AND

((AttributeID = 5 AND AttributeValue like  '%gold%') OR

 (AttributeID...

Not sure if this of any use, but it should show the first of 3 consecutive dates that are Mon-Fri. This is written off the top of my head with...

Using

CardNumber LIKE '%1234'

or

RIGHT(CardNumber,4) = '1234'

will at best do an Index Scan

The only way I can see to achieve an Index Seek to do like Frank's suggestion, a slight variation

CREATE TABLE...

Try coming up with another excuse to explain how this question is valid.

Don't need an excuse, depends...

Yes true Frank, the order cannot be guaranteed. However all the times I have done this sql has always updated in order of the rows in the heap but as...

Or

SELECT CAST(FLOOR(Qty) AS int)

Also use SUM(ISNULL(Qty,0))

to avoid the

Warning: Null value is eliminated by an aggregate or other SET operation.

message

Depends on what output you want. To do extract of this type, I use temp tables using the logic as follows (create temp tables with structure required)

Insert into Temp1 from...

The question asked what is 'not a valid action' dependancies is not an action it is a parameter applied using an action.

OK, OK, how about this then

declare @sum int

set @sum = 0

update

set @sum = [col b] = @sum + [col a]

Do you mean like this

UPDATE A

SET A.EntryCntManual = B.EntryCntManual,

    A.EntryDolManual = B.EntryDolManual,

    A.EntryCntSwipe = B.EntryCntSwipe,

    A.EntryDolSwipe = B.EntryDolSwipe,

    A.EntryCntPerc = B.EntryCntPerc,

    A.EntryDolPerc = B.EntryDolPerc

FROM...

hey come on frank, stop stirring it

That combination was not asked for