Actually, it doesn't. It works as long as the last three characters aren't repeated anywhere else in the string, but...

Eric M Russell (7/21/2011)

---

SQL_By_Chance (7/21/2011)

---

Assuming that changing the data is not an viable option, then I suggest you try modifying the SQL like below, doing a left outer join(s), and...

It helps if you provide expected output based on the data provided. As it is, I had to guess at what you were looking for.

The following code should at...

There is a separate forum for Analysis Services http://www.sqlservercentral.com/Forums/Forum17-1.aspx. You might get a better answer in that forum.

Drew

It's not an arbitrary behavior, it's just that you can't predict the value for the week based on the values for each day.

If the same five users log in every...

From BOL http://msdn.microsoft.com/en-us/library/ms175623.aspx:

DistinctCount is nonadditive, which is why you don't get the results you expect when you compare the...

The OP asked to specifically break on spaces. This only seems to work, because this particular test string has spaces at positions 60...

SUBSTRING is not SARGable, so it's better to write this using LIKE.

select Letter, COUNT(*)

from #Letters

LEFT JOIN Emp ON...

Use FOR XML PATH instead of FOR XML AUTO.

Another options is to use the ELEMENTS directive.

FOR XML AUTO, ELEMENTS

Drew

The expression in the COMPUTE clause's aggregate has to EXACTLY match an expression in the SELECT clause. Your SELECT clause contains a function call, whereas your COMPUTE clause does...

The problem is with the following fields: mersum.subisonum and mersum.repnum.

You're grouping on the actual values (including NULLs), so you could potentially have a row with NULL and another with 0...

sqlusers (6/30/2011)

---

Please check the below.

CREATE TABLE tblGetEmp (EmpName CHAR(8),Salary INT,Dept CHAR(1))

INSERT INTO tblGetEmp

SELECT 'aaa',10000,'a' UNION ALL

SELECT 'bbb',16662,'a' UNION ALL

SELECT 'rrr',73637,'a' UNION ALL

SELECT 'jhfdj',87683,'b' UNION ALL

SELECT 'jhk',7382,'b' UNION ALL

SELECT 'ewkjhk',98798,'b'...

opc.three (6/29/2011)

---

UNION ALL used how it was just shown in your post (as a 2005-compliant row constructor equivalent to VALUES() ) will allow you to use the APPLY technique in...

opc.three (6/29/2011)

---

Itzik has it down, use the APPLY operator for this. UNION ALL will scan the data multiple times, APPLY will only scan it once, and it's cleaner than the...

Here is why UNPIVOT doesn't work with multiple sets of data.

Suppose you have the row:

JOB Name1 Name2 ...