Yup, can't say I like table names with spaces (inherited one system with plenty of those).

Thanx for clearing this out for us.

Ya thanx Sergiy, great little nugget of information on transactions in there.

LOL.

SELECT Name FROM dbo.SysObjects WHERE OBJECTPROPERTY(id, 'ExecIsStartup') = 1

That works for me...

CREATE TABLE #Demo (a DECIMAL(7, 4))

INSERT INTO #Demo (a) VALUES (11)

SELECT a FROM #Demo

--11.0000

ALTER TABLE #Demo

ALTER COLUMN a DECIMAL(11, 6)

SELECT a FROM #Demo

--11.000000

DROP TABLE #Demo

Maybe you have...

You can't do that.  You need a date column.  Timestamp, contrary to his name, has no association with date nor time.

The round seems to win constantly on my slow PC :

USE SSC

GO

DUMP TRAN SSC WITH NO_LOG

GO

CheckPoint

DECLARE @Start AS Datetime

DECLARE @BitBucket AS int

DECLARE @Counter integer

SET @Counter...

No clue which one is fastest.  Make a test, run it and post the results then we'll talk about it .

Lol, his name is

Michael Valentine Jones

Grasshoper is linked to the number of messages he posted .

DECLARE @Mon AS Money

SET @Mon = 1.23

SELECT 1 WHERE @Mon = CONVERT(INT, @Mon)

SET @Mon = 2

SELECT 1 WHERE @Mon = CONVERT(INT, @Mon)

I'll let you work out the inner join but the pivot looks like this :

Select

col1,

col2,

case when fish = 'Jack' THEN CatchNumber ELSE NULL END,

case when fish...

Thanx for the idea.. I'd never have thaught of that one (the price to pay for working with only 10 employees on the DB .

So the last 6 orders completely regardless of the date?

Here's the link... easier to find if you have the right keywords to search for .

http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp

The whole article is awesome but if you're...

Speaking of better late than never.  Congrats on the 3000th post.