Viewing 15 posts - 301 through 315 (of 5,502 total)
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...
November 27, 2013 at 1:34 pm
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...
November 27, 2013 at 1:20 pm
Do you think it is even possible to minimize the impact on the entire process and design for the case where this one failed SP doesn't end up rerunning successfully?
It...
November 26, 2013 at 2:50 pm
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...
November 26, 2013 at 11:37 am
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 =...
November 26, 2013 at 11:16 am
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...
November 23, 2013 at 3:51 pm
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...
November 23, 2013 at 10:56 am
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...
November 23, 2013 at 10:35 am
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]',...
November 21, 2013 at 6:09 pm
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...
November 21, 2013 at 5:54 pm
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...
November 20, 2013 at 4:56 am
The "simple" CrossTab version won't work since the column names need to be dynamic.
Hence my recommendation to use the Dynamic CrossTab version.
November 18, 2013 at 11:23 am
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...
November 18, 2013 at 10:54 am
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...
November 17, 2013 at 5:10 pm
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...
November 17, 2013 at 4:24 pm
Viewing 15 posts - 301 through 315 (of 5,502 total)