Viewing 15 posts - 826 through 840 (of 8,416 total)
darrylc-ssc (2/1/2012)
If anyone can provide some enlightenment I'd be most grateful!
Sorry to disappoint, but there's no obvious cause I can see from the plans. You might try the test...
February 2, 2012 at 7:39 am
gorenak (2/2/2012)
ok but why this code in 10 0000 repeats never change?
Because it isn't random, it depends on code paths within SQL Server which none of us can see. ...
February 2, 2012 at 7:33 am
gorenak (2/2/2012)
My questing is, by witch parameter inside order MS SQL server display data?
It's not defined, because it depends on internal implementation details. So, it's not random exactly,...
February 2, 2012 at 7:11 am
skippybiff (2/2/2012)
Isn't COALESCE ANSI Standard?
Yes.
February 2, 2012 at 7:07 am
rwright-834262 (2/2/2012)
...However, it is a good example of how this could be accidentally misused, and considering it may save someone time debugging I wouldn't suggest that it's poor.
When you rate...
February 2, 2012 at 7:06 am
carlos.magno (2/2/2012)
But I guess that is not the most...
February 2, 2012 at 6:57 am
carlos.magno (2/2/2012)
I don't thought as a suggestion. Just as a fact.But, anyway, may you consider as a suggestion from this moment 🙂
I'll just ignore it, since you haven't presented any...
February 2, 2012 at 6:54 am
George H. (2/2/2012)
February 2, 2012 at 6:53 am
carlos.magno (2/2/2012)
I never use IsNull.I always use COALESCE.
Are you just sharing that fact, or suggesting that as a practice others should follow?
February 2, 2012 at 5:02 am
Rob-350472 (2/2/2012)
That sounds like quite a scary outcome, compared to the possibility of dirty reads!
Just note that refers to snapshot isolation (SI), not read committed snapshot isolation (RCSI).
February 2, 2012 at 4:06 am
CELKO (2/1/2012)
In the current ANSI/ISO standards have the IS [NOT] DISTINCT FROM theta operator, but only DB2 might have it -- I am not sure.
Anyone wanting to vote for SQL...
February 2, 2012 at 2:45 am
Properly formatted, and with a few minor edits, it looks like a reasonable query to me:
SELECT
Center = Territory.ParentMasterGroupValue,
CenterDescription = Territory.ParentMasterGroupValueDescription,
...
February 2, 2012 at 2:36 am
You would need two columns, something like:
...
NoofUnits = SUM(
CASE
WHEN fpsm.InformationDateID = @CurrentMonthEndID
THEN fpsm.NoOfUnits
ELSE 0
END),
PreviousNoofUnits = SUM(
...
February 2, 2012 at 2:26 am
The IN syntax is one of the available 'standard' SQL syntaxes; SQL Server also supports a Transact-SQL extension:
-- Original query
SELECT * FROM [dbo].[table1] AS t1
JOIN [dbo].[table2] AS t2 ON
...
February 2, 2012 at 2:22 am
Koen Verbeeck (2/2/2012)
I know that Google is restricted in China, but is it totally banned in India or something?http://www.sqlservercentral.com/Forums/Topic1245517-391-1.aspx?Update=1
A beautifully researched and detailed question:
I have to insert data from excel...
February 2, 2012 at 2:11 am
Viewing 15 posts - 826 through 840 (of 8,416 total)