You could use one of the Standard Reports provided in SSMS (Right click the database -> Reports -> Standard Reports -> Disk Usage ( or Disk Usage by Table or...

I reformatted the query to be slightly more readable (I'd say).

From my point of view there's no need to add all those extra nested ELSE CASE stuff since this will...

It...

You could upgrade to either one (including 2008 R2 Standard or 2008 R2 Enterprise).

However, you might consider that Mainstream Support for 2008 R2 will end 2014/07/08 which is just...

You could try something along those lines (assuming the subroutines will include a RETURN 1 for success):

... get a set of values from a queue table ...

DECLARE

@returnValueSP1 INT =...

Greg Edwards-268690 (11/23/2013)

We had SQL Server, DB2, Sybase, and Oracle. But we moved the application from Oracle to SQL Server. And DB2 was for the ERP System, and moved to...

Lynn, I'd say give it a try and talk to them. Figure out what they're looking for and go from there.

At least you'll know if they're really looking for Superman...

From my point of view a competent database developer knows his/her limits (= when a given scenario would require to leave his/her "comfort zone") together with understanding what concept would...

You could ignore the namespace by using a pseudo-namespace and a * to name all namespaces:

;

WITH XMLNAMESPACES(DEFAULT 'some_string')

SELECT

pref.value('./text()[1]', 'varchar(MAX)') AS 'BankAccount'

FROM @MyXML.nodes('//*:GetEmployeeDetails/*:return/*:BankAccounts/child::node()') AS RequestXml(pref)

where pref.value('local-name(.)[1]',...

Even though stuff like that should be done at the presentation layer, it could also be achieved using T-SQL.

The "magic word" is CrossTab (see the related link in my signature).

Since...

There are definitely ways to speed this process up (or at least make the code more compressed).

But you're not seriously asking in a web forum if someone could tune your...

@luis:

The "simple" CrossTab version won't work since the column names need to be dynamic.

Hence my recommendation to use the Dynamic CrossTab version.

Is there any way you can provide a setup that could be used to reproduce the odd behavior of the sproc on a standalone machine (meaning that we can test...

Isn't that more a scenario for CROSS JOINS rather than a recursive cte?

I would use a Tally table to expand the number of coins per denomination and the CROSS JOIN...

It still doesn't make much sense. Please provide the expected result in a SELECT ... format.

Something like

SELECT

'20131105' as Date,

'HOLD' as Location,

1 AS ArvlCount,

9 AS ArvllHour,

1...