Ah, but it does...

sysprocesses.spid contains the actual spid

sysprocesses.blocked if > 0 means two things - spid is being blocked, and the value here is the blocking spid.

Have a look in...

Not sure this is the most elegant solution, but it does seem to fulfill the requirement to return only the house that complies to all elements in the IN clause.

'Top 100' by itself doesn't return the 'first', it returns the 'first found by the query'.

If 'first' is implied by some kind of order, you must use ORDER BY on...

What I guess Ray means, is that SQL is not very well suited for formatting purposes - it's a data retrieving / manipulating setbased language, quite different from your 'normal' structured...

If you look inside sp_who / sp_who2 you can see that they get their blocked info from master..sysprocesses.

/Kenneth

The usual answer is 'do it on the client, SQL is no good at this sort of thing'

However, if you really need to anyway, there are a few different ways...

When we move from inner joins to outer joins, the rules changes accordingly.

(assuming the example with just two tables)

For an inner join, both tables are 'equal', thus if a filter...

Well, if you think that the solution to your (unknown?) problem is to use dynamic SQL, I strongly recommend reading The curse and blessings of dynamic SQL first.

It's crucial that...

It's a bit more than difficult, it's impossible. Can't be done.

Views are built on <select statement> - you cannot 'select procedure', so it won't work.

Please have a look in BOL...

It's Norwegian, Vladan.

(quite similar to Swedish, a bit farther away from Danish)

/Kenneth

My guess is that it's not in an index, since it seems to be a bit datatype. (referred to as to be set to 'true' and the variable is also...

I don't believe there's any other way than to drop and recreate.

You can check current settings by select objectproperty(object_id('dbo.myTable'), 'IsAnsiNullsOn')

In the notes on the  'IsAnsiNullsOn' property, BOL says:

IsAnsiNullsOn Scalar...

Well, then I guess you're stuck.

(though getting the client to provide it *will* solve your problem)

You can't audit information not provided with the connection

Whew - lotsa text..

I'd guess that - No, it's not the same as the case (though this is a guess)

But the case seems...

That will give you the servers IP, not the current user...

For a complete networkaddress, you need two things:

IP + subnetmask or IP...