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...

Quick suggestion, use either rank or row_number, here is a sample with the latter

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_SKATER') IS NULL

BEGIN

CREATE TABLE dbo.TBL_SAMPLE_SKATER

(

Distance INT...

lmarkum (3/20/2015)

---

I have a DB using random GUID values as a PK. I know it should not be that way but it is third party and I am trying...

Quick question, on the SQL Server 2008, did you store any SSIS packages in the syspackages table in the msdb database?

😎

spaghettidba (3/22/2015)

---

Eirikur Eiriksson (3/21/2015)

---

spaghettidba (3/21/2015)

---

TomThomson (3/20/2015)

---

spaghettidba (3/19/2015)

---

It has to be said that the Italian language doesn't help either: "the surgeon" translates to "il chirurgo", which is a masculine word to...

I've had similar in the past, afterwards everything worked fine...

er.mayankshukla (3/13/2015)

---

Hi Experts,

I use Batch wise delete in my procedures as they help me to reduce log size.

As we know the deletes causes ghost records, so commiting in batches...

wagdy_maher (3/22/2015)

---

storage capcity : over san storage , no problem about storage

It's single database...

timthetraveler (3/21/2015)

---

Guys,

I'm trying to quantify the number of times folks use SQL Server Management Studio to change client data in one of our production databases. Does SQL Server keep...