See if this helps: http://support.microsoft.com/default.aspx?scid=kb;EN-US;280102

Actually I guess the 2. example contains a typo and that you're after the last effectivedate for each entry in employeeID. If so, this might help

USE Northwind

SELECT t1.* FROM [order...

Something like this?

DECLARE @OneYearAgo DATETIME

SET @OneYearAgo  = DATEADD(YEAR,-1,DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0))

SELECT @OneYearAgo

SELECT DATEADD(MONTH, Number, @OneYearAgo)

  FROM master..spt_values

 WHERE Type='P' AND Number BETWEEN 1 AND 12

See if this helps: http://support.microsoft.com/lifecycle/?p1=2852

Just for fun, here's another variation on that topic

SELECT

 PARSENAME(REPLACE('EXISTING SERVICE-DESKTOP HARDWARE-PC', '-','.'),1)

You might try using a linked server or http://pgfoundry.org/projects/dbi-link/

No need to query the system tables directly. It's better to use something like

USE Northwind

SELECT COLUMN_NAME

  FROM INFORMATION_SCHEMA.COLUMNS

 WHERE TABLE_NAME = 'Orders'

or even

EXEC sp_columns 'Orders'

How much more opinions do you need?

Anyway, if you also like to overclock your servers, check this out: http://www.sqlservercentral.com/columnists/rmarda/letsblockthedba.asp

Brian, check out http://www.rssbandit.org/ It's now an Open Source project using the .Net framework. Like Sharpreader it is mentioned here http://www.microsoft.com/communities/guide/rss.mspx

Latest version of RSSBandit also allows NNTP access, so...

As I'm being told, MS dropped their announced new DATE data type from SQL Server 2005. What a pity!

Btw, when you are interested -...

Aah, yes, I forgot about these hex thingies which are convertible to INT. One of these strange days, I get following results

SELECT ISNUMERIC(0X0e) AS E, ISNUMERIC(0X0f)  AS F

E           F          

----------- -----------...

Sergiy.......... CAST( CAST( ( MyTs - 0.5 ) as integer ) as smalldatetime )

PW............... convert(smalldatetime, floor(convert (float, MyTs )))

David Burrows... CAST(DATEADD(day,DATEDIFF(day,0,@dateField),0) as smalldatetime)

Frank Kalis..... CAST(CAST(SUBSTRING(CAST(MyTs AS BINARY(4)),1,2) AS INT) AS...

You might want to check out my reply here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=202581 CHAR(160) is a non-breakable space and as such considered a "noise" character in SQL Server. At least CAST treats it...

This will create a number table with 1 millon sequential numbers

 CREATE TABLE Numbers(Number INT NOT NULL PRIMARY KEY)

 GO

 INSERT Numbers

 SELECT HundredThousand * 100000 + Tenthousand * 10000 + thousand  *...

Just for giggles. You can also use the internal storage format of a SMALLDATETIME to get rid of the TIME portion.

DECLARE @dt SMALLDATETIME

SET @dt =...