Viewing 15 posts - 3,181 through 3,195 (of 4,087 total)
GSquared (5/3/2012)
MS documentation makes it very clear exactly what's being deprecated, which is the use of *= and =* in the Where clause for an outer join.
If it's so clear,...
May 3, 2012 at 1:30 pm
Eugene Elutin (5/3/2012)
Actually this material wasn't written by SQL Server team and I would say it's irrelevant to MS T-SQL...
How do you know who wrote it? I don't see...
May 3, 2012 at 11:01 am
marksquall (5/3/2012)
May 3, 2012 at 10:04 am
I agree with you that CROSS JOIN being explicit is a superior syntax, for readability mainly. I don't use commas that way for that exact reason. But your...
May 3, 2012 at 9:46 am
Jeff Moden has a great article on this very subject. Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]
Drew
May 2, 2012 at 2:13 pm
It clearly says,
Joins that use the deprecated syntax fall into two categories:
Inner Join
...
Outer Join
or were you referring to not finding CROSS JOIN?
It doesn't specifically state anything about CROSS JOINS. ...
May 2, 2012 at 12:27 pm
Cadavre (5/2/2012)
FROM CTE x, CTE y;
drew.allen (5/2/2012)
This join syntax has been deprecated. You shouldn't be using it in new development. Use CROSS JOIN instead.
GSquared (5/2/2012)
The Outer Join...
May 2, 2012 at 11:03 am
Cadavre (5/2/2012)
NLV (5/2/2012)
Hi,I want to insert 100 rows like (1,2,3,4,..100) without using loops into a table using CTE. can you please help.
WITH CTE(n) AS(SELECT 1
...
May 2, 2012 at 7:17 am
Please don't start multiple threads on the same topic. It fragments the replies.
Please post in the original thread: http://www.sqlservercentral.com/Forums/Topic1293567-338-1.aspx.
Drew
May 2, 2012 at 6:58 am
I think that this is just a language problem. When Sean said to replace = with IN, he only meant the one in the WHERE clause, not all of...
May 2, 2012 at 6:53 am
You want to be careful here. Life isn't nearly as simple as your model implies. For example, someone could get married, divorced, and then re-married. Their current...
April 30, 2012 at 6:59 am
Sean Lange (4/26/2012)
bpowers (4/26/2012)
Not yet, but I am working on it. It didn't like the P.USED.
Not sure what you mean by "It didn't like". 😛
I should be the same as...
April 26, 2012 at 12:18 pm
It's actually very easy. It's simply concatenating two conditional expressions together. The SSRS equivalent would be something like the following
=IIf(InStr(VIEW_Creditors.DISCREPENCY_CODE.value, Parameters!Contingent_Code.value) > 0, Parameters!Contingent_Code.value, "") & IIf(InStr(VIEW_Creditors.DISCREPENCY_CODE.value, Parameters!Unliquidated_Code.value)...
April 25, 2012 at 2:37 pm
The problem is that you're trying to do it all with one function, but you need separate functions for each week.
SELECT Resp_ID, Brand
,COUNT(DISTINCT CASE WHEN [Week] = 2 THEN Q5...
April 25, 2012 at 7:31 am
ColdCoffee (4/24/2012)
But if u insist in using single query to do that, then u...
April 25, 2012 at 6:54 am
Viewing 15 posts - 3,181 through 3,195 (of 4,087 total)