You could almost certainly do all of this work in a single query if you switched from old-style joins to ANSI-standard joins and learned how to use outer joins. Wikipedia...

Thanks.

Then you should use UNION (ALL). The results of the two queries have widely different column counts. You will have to decide which columns...

DROP TABLE #Turnover

CREATE TABLE #Turnover

(location varchar(50),Total int)

INSERT INTO #Turnover (location,Total) VALUES

('A', 500),

('AB', 200),

('ABC', 100),

('BA', 100),

('BAC', 500),

('BAM', 100)

SELECT NewGroup = LEFT(location,1), location, Total...

Joined...

What happens if you run this

SELECT

...

Please post the definition of function dbo.fn_Nested.

Can you post the whole view definition?

What you've shown of your view definition equates to this:

SELECT

urpx.RoleID

FROM [DBA].dbo.URPX

INNER JOIN [DBA].dbo.URX

ON urpx.RoleID = urx.RoleID

LEFT OUTER JOIN (

SELECT

urx.RoleID,

urx.UserID

FROM [DBA].dbo.URX

INNER JOIN...

Parallel combination or serial? If serial, you will have to match the number and type of output columns between the queries. If parallel, you will require a join strategy.

You're using...

GilaMonster (7/4/2014)

---

You have security vulnerabilities in that. Specifically SQL Injection. DO NOT concatenate user input into a string which will be executed. It is perfectly possible...

Oh boy. Where to start with this one.

First off, the use of multiple right joins in the queries in the stored procedure suggest that the queries were generated using...

hominamad (7/3/2014)

---

Thanks for the quick reply. So basically this is a two-step update, first an update then inserting the duplicates. I will experiment with that and see if it works...

Sneaky 😀

SELECT

NumberString,

[ISNUMERIC] = ISNUMERIC(NumberString),

[ISNUMERIC extra] = ISNUMERIC(NumberString+'e00'),

[Number] = CASE WHEN ISNUMERIC(NumberString+'e00') = 1 THEN CAST(NumberString AS FLOAT) ELSE NULL END

FROM (VALUES...

There are quite a few ways of doing this

SELECT

t.id,

t.idvalue,

[Diff] = ABS(t.idvalue - x.idvalue),

Flag = CASE WHEN ABS(t.idvalue - x.idvalue) > 18 THEN 'failure' ELSE 'success' END...

You should start a new thread for this, and perhaps include the action you would like to take depending upon the distribution of ID's between the two tables. For instance,...