Maybe T means "Absolutely 100% true", and t means "well, maybe about 75% true, give or take..." ?

🙂

Or use COLLATION

CONSTRAINT ss CHECK (adp IN ('T', 'F') COLLATE SQL_Latin1_General_Cp437_BIN)

Or from sys.dm_exec_connections

Have a look at the CONNECTIONPROPERTY function

SELECTCONNECTIONPROPERTY('client_net_address')

You want the client name?

Because your query is run on Machine2, so Machine2 need to see your Machine as "originator" to query to run?

I only have 92 column in my master.sys.columns.

This is because I have an edited very slim version of MASTER database.

This...

One would think that using the index with most columns would minimize the risk of having to bookmark and use key lookup later in the execution plan.

But on the other...

This?

DECLARE@Sample TABLE

(

theStock CHAR(6),

theDate DATETIME,

theValue MONEY

)

INSERT@Sample

SELECT'000001', '20041230', 6.59 UNION ALL

SELECT'000001', '20050103', 6.52 UNION ALL

SELECT'000001', '20041230', 6.59 UNION ALL

SELECT'000001', '20050103', 6.52 UNION ALL

SELECT'000001', '20050104', 6.46 UNION ALL

SELECT'000001',...

It does make a difference, especially if you have multiple concurrent users trying to access the same table.

See here how to make a really fast moving average.

According to OP, he wants the numbers PRINTED, because they then are stored in the log file.

And to make sure Jobs really are taken FIFO style, use

UPDATEf

SETIssued = 1

OUTPUTinserted.JobId

FROM(

SELECT TOP 1JobID,

Issued

FROM@t

WHEREIssued = 0

ORDER BYJobID

) AS f

I have posted a new function on my blog.

The function can compute the Nth weekday in a month, either from the beginning or from the end of month.

http://weblogs.sqlteam.com/peterl/archive/2009/06/17/How-to-get-the-Nth-weekday-of-a-month.aspx

You can try...

ROW_NUMBER() was introduced with SQL Server 2005 and need the compatibiity level set to 90 or higher.

And it's also well established that

ABS(CHECKSUM(NEWID())) % 100

gives random numbers between 0 and 99 with very high, good and even distribution.