And with some error checking

alter function dbo.ConvertIp2Num(@ip varchar(15))

returns bigint

as

begin

returncase

when @ip like '%[^0-9.]%' then NULL

when @ip like '%.%.%.%.%' then null

when @ip like '%..%' then null

when @ip...

No need to cast either

alter function dbo.ConvertIp2Num(@ip varchar(15))

returns bigint

as

begin

return16777216.0 * parsename(@ip, 4)

+ 65536 * parsename(@ip, 3)

+ 256 * parsename(@ip, 2)

+ 1 * parsename(@ip, 1)

end

I am confused since table variables doesn't have statistics.

DECLARE@Sample TABLE

(

Company VARCHAR (100) NOT NULL,

[Hours] INT NOT NULL

)

INSERT@Sample

SELECT'Some Company 1', 10056 UNION ALL

SELECT'Some Company 2', 1354 UNION ALL

SELECT'Some Company 2', 8979 UNION ALL

SELECT'Some...

Sure. I forgot to see which version it was.

😀

The only difference is the version row.

See http://msdn.microsoft.com/en-us/library/ms191479.aspx

Change the version row to 9.0 and you can use if with both versions.

Are you using Enterprise Edition?

If so, read about CDC (Change Data Capture).

Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=129492

OP got an answer with 50% better performance; 20 minutes instead of 30.

Not with the OUTPUT operator.

Yes, I am quite sure.

For a few years ago, I was called in to solve a replication error. There were 3 records out of 2 billion that was not...

It will an issue for your indexing strategies.

A GUID is 16 bytes wide, an INT is 4 bytes, which essentially means your indexes will be 4 times as big than...

A worktable is an internal table created by SQL Server as a helper table to solve certain things.

These things can be aggregations, joins and so on.

And to simplify the date math even more

SELECTDATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), -1)

Where is LOCATION located?

Maybe you can use synonym instead?

Retired!?

You lucky bastard...