Quick thought, unless you can afford to lose it, do the check!

😎

Brandie Tarvin (3/23/2015)

---

Eirikur Eiriksson (3/23/2015)

---

GilaMonster (3/23/2015)

---

If you find it, I think this query can only be done if the WITH (CrystalBall) join hint...

Repeat

Brandie Tarvin (3/23/2015)

---

Eirikur Eiriksson (3/23/2015)

---

GilaMonster (3/23/2015)

---

If you find it, I think this query can only be done if the WITH (CrystalBall) join hint...

Thanks Gail, thinking...

Just brilliant work as always Jeff!

Your version of Itzik's solution is good but it leaves still some room for improvement, here is my "adjustment";-)

😎

PRINT '========== Eirikur''s version of Itzek Ben-Gan...

There are two solutions, either add an explicit drop table statement before the IF or change the logic to drop the table every time if it exists, here is the...

Quick thought, use Audit for...

Quick question, are the queries pass-through or executed directly on the linked tables? Have a quick look at this article "Microsoft Access Pass Through Queries to SQL Server[/url]"

😎

Then we have to do this slightly differently than Mark's solution, this code should be easy to understand

😎

USE tempdb;

GO

SET NOCOUNT ON;

Declare @continents Table

(

id int identity (1,1)

,continent_id int

,continent_Name...

Quite interesting but my suspicion is that the picture painted there is slightly skewed as there is...

jaggy99 (3/22/2015)

---

The amount 300,000 is a budget figure which I'm given. I'm just trying to use sql to blend data so thinking if I can create a view to spread...

Quick modification to Mark's code adding the counts

😎

USE tempdb;

GO

SET NOCOUNT ON;

Declare @continents Table

(

id int identity (1,1)

,continent_id int

,continent_Name varchar(100)

,continent_surface_area varchar(100)

,country_id int

,country_Name varchar(100)

,country_code varchar(10)

,country_surface_area ...

Now where is the Crystal Ball?

😎

So where is the data coming...