A mental point to myself for thinking about the answer and then executing it 😀 It's almost like not cheating!

Combine? Try:

select * from

( <your 1st query>) a

inner join

( <your 2nd query>) b on 1=1

Why don't you just replace the function with a procedure that gets the next box# and updates it in one shot? You don't need to join to the tblOrders table...

Lowell (4/14/2011)

---

not sure what you mean by that... a data source is just a data source.

maybe you mean the...

That's a bad idea. Why not make ID the...

Thanks for the links and info. I hope I never have to migrate an Access database again, but I'll definitely put SSMA into my toolbelt.

suryagiri (4/7/2011)

---

Hi Friends..

how to import access Data Base file in sqlserver ?

the problem is Import access database file extension is ".accdb" in Sqlserver .

if any one knows plz help me...

Any luck with solving this, PaulSp? It would be useful to know since my organization will be upgrading to Win7 soon and I'm supporting an Access2003 to SQL app.

We can't know that from the information we have. All we know is what types of villas are taken, but not which particular villas are taken. We can't know how...

This isn't the whole trigger, is it? What are you doing with the variables @ptFlagIndicator1Var, @ptFlagIndicator2Var, etc., after you set them?

What is the relationship between guest_reservation and reservation? It looks like a one-to-one so it should probably be combined to one table.

smallville69 (4/8/2011)

---

...

To be able to find out a list...

webrunner (4/8/2011)

---

UMG Developer (4/7/2011)

---

Argh! How does something this simple and wrong make it through. Did nobody actually run the code prior to posting the question? :w00t:

Steve, oh Steve, Cleanup on...

If you want to group it by year, as in your original post, then you can get the year from the date with the year() function. Also remember to group...

I think this is what you want. The case expression is very powerful addition to your sql arsenal. Thanks for posting the useful DDL.

SELECT

G.DeadlineDate,

E.Name,

Sum(Case when S.GoalStatusDesc = 'Complete' then...

Try this:

create table A (ID int identity(1,1), col1 int);

insert into A (col1) select 100 union select 200 union select 300;

create table A_audit (A_ID int, col1 int, date_changed datetime);

go

create trigger A_changes...