Update & Set Query .... Not Working ...HELP

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Update & Set Query .... Not Working ...HELP

Author

Topic

Knives85
Starting Member

6 Posts

Posted - 2010-02-10 : 06:54:35

Hi Guys

i could do with some help please guys

I have two sets of data in too completely different databases and im unable to get them linked together :(

Im trying a different method I have appended all the main data into a table and then im trying to match on the dates and time_group (time_group is 30 minute groupings of the date) so that I can append sales data to the table.

Can you think of anyway to do this

The current method im trying is below. (sorry I couldnt do that query preperation thing)

UPDATE
dbo.tbl_People_Counter_Plus_EPoS

SET
EPoS_Issues = (SELECT Total_Issued
FROM vw_EPoS qry INNER JOIN dbo.tbl_People_Counter_Plus_EPoS pc ON qry.RH_Dateonly = pc.date
WHERE Total_Issued <> pc.EPoS_Issues)

Thanks Boys(and Girls)

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-02-10 : 07:01:45

It would be helpful Knives85 if you could show us the tables/views and what output you want.

Harsh Athalye
http://www.letsgeek.net/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-10 : 08:48:30

[code]
UPDATE pc
SET pc.EPoS_Issues = qry.Total_Issued
FROM vw_EPoS qry
INNER JOIN dbo.tbl_People_Counter_Plus_EPoS pc
ON qry.RH_Dateonly = pc.date
WHERE qry.Total_Issued <> pc.EPoS_Issues
[/code]

------------------------------------------------------------------------------------------------------
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources