Link to cross post on Stackoverflow

There is no built in function - you would need to create your own.

See http://blogs.msdn.com/rextang/archive/2008/01/13/7091118.aspx

ignore

There are no 64-bit OLEDB drivers for Excel.

You can normally get around this on a 64-bit machine by executing the package with the 32-bit version of dtexec - typically found...

If it works some of the time, it's not permissions related.

You may or may not know that Linux is case-sensitive for file and folder names. Is it possible that you're...

This looks like a permissions issue on the FTP server. Using the same account as the SSIS package, are you able to create a file using an FTP client?

You might be able to do this with a script task.

However, having Googled a bit there is apparently no native support for SFTP within the .Net framework.

There are various...

What's the error message?

You may need to restart the SSRS and, if that fails, IIS services to flush the old style sheet out of the cache.

Like RBarryYoung, I can't replicate the behaviour you describe between SQL 2005 Management Studio and Excel 2003.

However, I can think of two possible sources of confusion here.

When represented as an...

Your query doesn't return the correct results because you don't limit the join to only connect to the next record in the sequence - you're comparing each record with every...

I don't think this is possible in pure T-SQL. There might be a way to do it with CLR, storing the value in a large decimal field and using an...

I think perhaps we're talking at cross purposes.

My understanding is that the original question asked how to assign a single row, single column result set from a SQLCMD query...

Grant, do you have a working example of how to assign a value back to a CMD variable using SQLCMD that you're able to post here?

It seems like something one...

The way I done this in the past to direct the output of SQLCMD to a text file, then read the value from the text file back into a variable:

sqlcmd...