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.

It's by design and for good reasons... search the articles on this forum for best practices + fully qualified object names + cached plans.  You'll surely find the missing link in...

Most of the time.

But you can have more than 1 plan per procedure / object / query.  That's why as a long shot I proposed the recompile.  A more drastic...

Changing the sp recompiled it, or more to the point changed the current execution plan.  So that threw out any possible bad plan out the window and more importantly out...