ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,771 through 7,785 (of 10,143 total)

RE: No data returned in JOINED columns

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
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 9:24 am

#1182213
RE: display only one record with summed quantity of the ones that have similarites

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 8:00 am

#1182142
RE: insert multiple values

You're welcome.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 7:55 am

#1182141
RE: Are the posted questions getting worse?

The Dixie Flatline (6/18/2010)
I'm reasonably soft-spoken at most times.
Pardon?
Yeah I know - cheap - but it's friday 🙂
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 7:30 am

#1182124
RE: Are the posted questions getting worse?

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 6:43 am

#1182085
RE: insert multiple values

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 6:23 am

#1182067
RE: How to combine two view in single query.

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 6:15 am

#1182062
RE: How to combine two view in single query.

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 5:49 am

#1182049
RE: Sql Server Joins

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.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 5:42 am

#1182045
RE: Result table join based on active or inactive flag in table two

You're very welcome.
Come back if you have problems with the output formatting.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 5:28 am

#1182038
RE: Result table join based on active or inactive flag in table two

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 5:17 am

#1182035
RE: How to combine two view in single query.

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 5:05 am

#1182033
RE: Result table join based on active or inactive flag in table two

Try this:
-- create some sample data
CREATE TABLE #MS_USER(
[USER_NUM] [int] NOT NULL,
[USER_LOGIN] [varchar](25) NOT NULL,
...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 4:39 am

#1182023
RE: Result table join based on active or inactive flag in table two

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 4:12 am

#1182006
RE: Result table join based on active or inactive flag in table two

Chaitanya Patil (6/18/2010)
Have a look at the snap shots, you may get idea what I'm trying to explain...
I this snap shot I've taken one particular USER_NUM to show.
Can we use...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 18, 2010 at 3:50 am

#1181998

Viewing 15 posts - 7,771 through 7,785 (of 10,143 total)