Gianluca Sartori (6/21/2010)

Horrible match. Looks like the "world champions" have disappeared.

Just a few notes:

1. Killen should...

What do you get when you run this?

DECLARE @CommonColumn VARCHAR(20)

SET @CommonColumn = 'A767108'

SELECT * FROM #t WHERE empid = @CommonColumn

SELECT * FROM WB_WF_EMPLID_XREF X WHERE X.WB_LOGON_ID = @CommonColumn

Your output contains three rows, each with an 'Item' which is a prefix of the Item values in your input table. The length of the prefix part is variable. Can...

You're welcome.

Pardon?

Yeah I know - cheap - but it's friday 🙂

This is what those damned Vuvu's do to your...

Query to retrieve the existing rows which we want to clone:

SELECT recipeID, ingredient

FROM recipe_ingr

WHERE recipeID = 12

Hard-code a new recipeID:

SELECT recipeID = 20, ingredient

FROM recipe_ingr

WHERE recipeID...

One of the queries already references a view. Chaining views in this manner decreases the chances of an optimal plan. Neither of the views is particularly complex, I'd recommend you...

Unfortunately I don't have the luxury of tables to run the query against, so I can only offer you suggestions.

1. Run the derived table query

2. Comment out the derived table...

Yes and no: sample B. Using a self-join to match sales people and their territories isn't a self-join.

You're very welcome.

Come back if you have problems with the output formatting.

It's certainly possible to make the change you've requested, but it's firmly in the camp of output formatting.

Also, I think that it would help your understanding of rCTE's do do...

SELECT di.BatchNo,

aim.PartName,

ric.ClassificationDesc,

uom.UOM,

did.IssueQty,

d.Location,

d.PartNo,

d.PartId,

di.DemandNo,

di.SlipNo

FROM dbo.Tbl_DemandIssue di

INNER JOIN dbo.VW_AllItemMaster aim

ON di.PartID = aim.PartID

INNER JOIN dbo.Tbl_RefItemClassification ric

ON ric.ClassificationID = aim.ClassificationID

INNER JOIN dbo.Tbl_RefUOM uom...

Try this:

-- create some sample data

CREATE TABLE #MS_USER(

[USER_NUM] [int] NOT NULL,

[USER_LOGIN] [varchar](25) NOT NULL,

...

So repeated values of user-active-flag - for the same user - should not be returned, only the first one of the set, by date?

The RowID and source columns are...