Indeed, the syntax of the FOR SYSTEM_TIME AS OF clause allows only a constant or a variable, not a column.
To overcome this limitation, you can use a table-valued...

Hello, McShorty

The problem is indeed a known bug in SQL Server 2000 SP4, but it is not documented in any KB (as far as I know). The bug is fixed...

This looks like a homework assignment, and we don't like solving homeworks for others.

See example D in http://msdn.microsoft.com/en-us/library/ms175972.aspx and try to modify it yourself to fit your purpose.

Razvan Socol

SQL Server...

You can try something like this:

SELECT * FROM (

SELECT * FROM DB1.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TableA'

) a FULL OUTER JOIN (

SELECT * FROM DB2.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TableA'

) b ON a.COLUMN_NAME=b.COLUMN_NAME

WHERE a.COLUMN_NAME IS NULL...

Hello, Albert

Here is my list of SQL version lists:

For SQL Server 2005:

http://www.sqlservercentral.com/columnists/sjones/2960.asp

http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx

http://www.aspfaq.com/sql2005/show.asp?id=20

SQL 2008 / 2005 / 2000 / 7.0:

http://sqlserverbuilds.blogspot.com/[/url]

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

SQL Server 2000:

http://www.aspfaq.com/SQL2000Builds.asp

SQL 2005 post-SP2 hotfixes:

http://support.microsoft.com/kb/937137

SQL 2000 post-SP4 hotfixes:

http://support.microsoft.com/kb/894905

SQL 2005 / 2000...

KB Article 937137 documents the SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released.

Razvan

Here are some new builds:

9.00.3175 KB936305

9.00.3171 KB937745

9.00.3169 KB937041

9.00.3166 KB936185

9.00.3155 KB933499

9.00.3155 KB933808

9.00.2233 KB933499

9.00.2229 KB935446

9.00.2151 KB904244

9.00.1554 KB926292

Razvan

9.00.3033 is the December 2006 CTP for Service Pack 2

9.00.3027 is the November 2006 CTP for Service Pack 2

9.00.2040 is the March 2006 CTP for Service Pack 1

9.00.2027 is Service...

If you use dynamic SQL, you can use something like this:

DECLARE @String char(20), @stmt nvarchar(500)

SET @String='416E6E61737461736961'

IF @String LIKE '%[^0-9A-F]%' RETURN

SET @stmt='SELECT CONVERT(char(10),0x'+@String+')'

EXEC (@stmt)

And if you want to convert the whole...

You can either uninstall the KB 932555 hotfix (if you don't use those SSIS features) or contact Sage Software support for an updated version of their software.

Anyway, you should open...

Cullen,

Version 9.00.2050 is not SP2, it's just a post-SP1 hotfix. SP2 is 9.00.3042

Razvan

The script posted in this article should come with a big warning: "The xp_delete_file procedure is undocumented and therefore unsupported!".

Here is what a MS employee (Terrence Nevins, SQL Server...

Here are 4 new hotfixes (april 2007), for the same problem (regarding scripts in SSIS):

- post-SP1 hotfix version 9.00.2221, downloadable from KB article 931593.

- post-SP1 hotfix version 9.00.2050, KB...

Peter, the following code:

select cast(cast(getdate() as int) as datetime)

will give incorrect results if the time is in the afternoon.

However, the code that Simon wrote: