Viewing 15 posts - 7,771 through 7,785 (of 10,144 total)
Gianluca Sartori (6/21/2010)
CirquedeSQLeil (6/20/2010)
.....
Haha - maybe I should have made a few bets this last week.:-D
Horrible match. Looks like the "world champions" have disappeared.
Just a few notes:
1. Killen should...
June 21, 2010 at 2:45 am
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
June 18, 2010 at 9:24 am
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...
June 18, 2010 at 8:00 am
The Dixie Flatline (6/18/2010)
I'm reasonably soft-spoken at most times.
Pardon?
Yeah I know - cheap - but it's friday 🙂
June 18, 2010 at 7:30 am
Greg Edwards-268690 (6/18/2010)
The Dixie Flatline (6/17/2010)
Testing...Testing...
Is this Thread on?
Do I hear the faint call of a threadaholic echoing in the distance?
Greg E
This is what those damned Vuvu's do to your...
June 18, 2010 at 6:43 am
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...
June 18, 2010 at 6:23 am
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...
June 18, 2010 at 6:15 am
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...
June 18, 2010 at 5:49 am
Adiga (3/16/2009)
Hope this helps..
Yes and no: sample B. Using a self-join to match sales people and their territories isn't a self-join.
June 18, 2010 at 5:42 am
You're very welcome.
Come back if you have problems with the output formatting.
June 18, 2010 at 5:28 am
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...
June 18, 2010 at 5:17 am
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...
June 18, 2010 at 5:05 am
Try this:
-- create some sample data
CREATE TABLE #MS_USER(
[USER_NUM] [int] NOT NULL,
[USER_LOGIN] [varchar](25) NOT NULL,
...
June 18, 2010 at 4:39 am
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...
June 18, 2010 at 4:12 am
Viewing 15 posts - 7,771 through 7,785 (of 10,144 total)