ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,731 through 5,745 (of 10,143 total)

RE: how to insert one column of table in one databse to other column of table in another databse

vinay.varaala (9/4/2012)
Dispenser_pump_mapping TABLE:
create table Dispenser_pump_mapping
(
dis_pump_map_id int IDENTITY,
simmons_id int not null,
dispenser int primary key ,
fp int not null,
nozzle int not null,
tank_id int foreign key (tank_id) references
Tank(tank_id)
)
So, what 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

September 4, 2012 at 9:00 am

#1533333
RE: how to insert one column of table in one databse to other column of table in another databse

Can you post the CREATE TABLE script for fuel.dbo.Dispenser_pump_mapping?
Looks to me like this column is possibly a FK.
^{“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

September 4, 2012 at 8:37 am

#1533317
RE: Are the posted questions getting worse?

Cadavre (9/4/2012)
Note: I'm from England.
I was once taken aside by a manager and told off for pronouncing "router" as "root-er" to one of our American clients. I was told that...
^{“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

September 4, 2012 at 7:49 am

#1533270
RE: Running Values ( Cummulative)

farooq.hbs (9/4/2012)
...
Hoping will get the Solution for this
Thanks
Of course - but you will get a solution much quicker if you can set up DDL and DML for some sample data....
^{“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

September 4, 2012 at 7:04 am

#1533249
RE: Outer join not working correctly

cmc_dermo (9/4/2012)
id really like to understand what the cross join does, but if it is too much time to describe i will go look it up 🙂
Every row on the...
^{“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

September 4, 2012 at 6:53 am

#1533245
RE: Outer join not working correctly

cmc_dermo (9/4/2012)
believe it or not i tried to work it out and got it working...
That's exactly the result that everybody here hopes to see 😀
If there's anything you're unsure about,...
^{“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

September 4, 2012 at 6:27 am

#1533230
RE: Outer join not working correctly

cmc_dermo (9/4/2012)
ok that works but i want to add week as well (sorry guys) as soon as i add vs.week = 36 it doesn't work.
It has to be part of...
^{“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

September 4, 2012 at 6:14 am

#1533223
RE: Outer join not working correctly

cmc_dermo (9/4/2012)
now i am getting confused 🙂
Maybe i need to explain better?
I need all the items from the items table but i would also like the query to look in...
^{“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

September 4, 2012 at 5:39 am

#1533218
RE: Outer join not working correctly

John Mitchell-245523 (9/4/2012)
Chris, are you sure about that? Referencing a column from the outer table will turn an outer join into an inner join if the reference is in...
^{“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

September 4, 2012 at 5:12 am

#1533209
RE: Outer join not working correctly

SELECT
Items.Item_Desc,
Items.Updated_By,
it.Item_Type_Desc,
Opening_Balance = ISNULL(vs.Opening_Balance,0),
v.Venue_Name
FROM m_Venue v
CROSS JOIN m_Items AS Items -- every venue has every item
INNER JOIN m_Item_Type it
ON Items.Item_Type = it.Item_Type_ID
LEFT 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

September 4, 2012 at 4:48 am

#1533194
RE: Outer join not working correctly

cmc_dermo (9/3/2012)
...I have a query where i would like to show all items from the items table even if no data exists for that item in the stock table...
Having read...
^{“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

September 4, 2012 at 4:01 am

#1533185
RE: Are the posted questions getting worse?

BrainDonor (9/4/2012)
ChrisM@Work (9/4/2012)
BrainDonor (9/4/2012)
ChrisM@Work (9/4/2012)
David Burrows (9/4/2012)
Fal (9/3/2012)
Quick poll: how would you pronounce the word "Route"?
I'll explain why later, if I'm not too embarrassed. :blink:
Steve.
I am English so naturally...
^{“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

September 4, 2012 at 2:52 am

#1533163
RE: Are the posted questions getting worse?

BrainDonor (9/4/2012)
ChrisM@Work (9/4/2012)
David Burrows (9/4/2012)
Fal (9/3/2012)
Quick poll: how would you pronounce the word "Route"?
I'll explain why later, if I'm not too embarrassed. :blink:
Steve.
I am English so naturally /ru?t/
Likewise -...
^{“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

September 4, 2012 at 2:40 am

#1533153
RE: Basic Design Question

Without any prior experience of this type of data, I'd be tempted to add a time dimension. That would give you team history, the team as it is right now,...
^{“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

September 4, 2012 at 2:17 am

#1533149
RE: Are the posted questions getting worse?

David Burrows (9/4/2012)
Fal (9/3/2012)
Quick poll: how would you pronounce the word "Route"?
I'll explain why later, if I'm not too embarrassed. :blink:
Steve.
I am English so naturally /ru?t/
Likewise - but how...
^{“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

September 4, 2012 at 2:08 am

#1533146

Viewing 15 posts - 5,731 through 5,745 (of 10,143 total)