You cannot specify the database name as variable for a USE call.

if I use this the database does...

Hi

Just out curiosity, why don't you use a linked server or xp_cmdshell to call sqlcmd?

Here a little sample in C#

using System;

using System.Data;

using System.Data.SqlTypes;

using System.Data.SqlClient;

using Microsoft.SqlServer.Server;

public partial class StoredProcedures

{

...

I'm really happy that C# does not give the possibility to implement optional parameters. Reason is that optional parameters are not handled by the library providing a method with optional...

@paul-2: No, still having the same issue.

@Lynn: Thanks for your effort! It's just strange that FireFox seems to handle Office Live better than IE on a x64 box.

Jan Van der Eecken (7/8/2009)

Paul White (7/6/2009)

That looks vaguely like German :unsure:

(Flo: consider Donaudampfschiffahrtsgesellschaftskapitän¹)

edit: better still:

Donaudampfschifffahrtselektrizitätenhauptbetriebswerkbauunterbeamtengesellschaft²

or

Rindfleischetikettierungsüberwachungsaufgabenübertragungsgesetz³

(Ok so I googled)

1:...

@Barry: Good to see you're back and nice new avatar!

@Lynn: Congratulation to >8000!

@paul-2: Congratulation to >1000, didn't see this before, now you can call your self a guru :-D. Your...

GilaMonster (7/2/2009)

Florian Reischl (7/2/2009)

Smells like a cross...

Smells like a cross post:

http://www.sqlservercentral.com/Forums/Topic746129-338-1.aspx

Good catch David! I left a note in the other therad.

Seems like Eswin and alex_pangcats are in same class:

http://www.sqlservercentral.com/Forums/Topic746129-338-1.aspx

Hi mick

please have a look to t.hitendra's snippet. You need to fill your variables inside your dynamic SQL and declare them as output parameter by calling "sp_executesql"

Notice the bold text:

EXEC...

Here are two really good articles about cross tab queries:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/cross+tab/65048/

ASAP always reminds my of my project manager. He came many many times with some completely new tasks which had to...

Should be possible with DENSE_RANK within a CROSS APPLY but...

First:

Your sample data contain:

101656 05/05/09 5' 6.5" 66.50

101656 05/05/09

101656 05/05/09 5' 5.75" 65.75

101656 05/12/09

101656 05/27/09

There is no uniqueness for date...

Seems to be problematic. You would the XPath function "base-uri()" which is currently (until SQL Server 2008) not supported for T-SQL XQuery.

Here is a Microsoft link which confirms this:

http://msdn.microsoft.com/en-us/library/ms345122(SQL.90).aspx