How about something like this?

select < column list > from users inner join

(SELECT User_ID, MAX(Start_Date) as LatestStartDate FROM Users group by User_ID) sub

on Users.User_ID = sub.User_ID and...

Two questions.

Why do you only want to insert/update the first row if there are multiple rows in the insert?

How do you define 'first row'? SQL doesn't put any meaning on...

Less on the security and more on the performance, see if you can secure a separate server for dev/test. Letting developers develop on the prod box is asking for an...

The temp table will be automatically dropped when the procedure that created it ends or the connection that created it closes. It's exactly the same whether you explicitly create it...

If you're in simple recovery, then running a truncate log will do almost nothing. The...

Certain features (merge replication, filestream) require the presence of a rowguidcol in the table. Other than that, nothing that I'm aware of

Sure it is, but that's not going to add rows for months that aren't in the original data.

No need for dynamic SQL at all.

CREATE TABLE #AgeList (

Age tinyint

)

IF @PropType = 'Student'

BEGIN

INSERT INTO #AgeList (Age)

...

You can't programatically control what triggers fire.

Write a single trigger that has logic to be able to send the different types of mail. It doesn't really sound complex. Bear...

It's an orphaned distributed transaction. Basically something has cancelled a distributed transaction badly and SQL's left with locks it doesn't know what to do with.

You can kill them safely, unfortunately...

First thing you need to to get management's buy-in for the tightening of security. The people who currently have privileged access aren't going to want to give it up, and...

No relationship.

Isolation levels affect how long locks are kept within a transaction and how isolated changes made by one transaction are from another transaction.

Indexes speed up data retrieval by giving...

I'll probably hear a day or so after it's available. If I hear anything, I'll let you know.

See if you can pick up a 2008 licence. I don't know if there's a difference in pricing, but picking up a 2008 server to act as the distributor gives...

Dugi (10/6/2008)

---

I know for the wide question...but just to know couz some people and also some report and articles in the Internet many of them they said that the SQL...