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

roy.tollison (3/21/2015)

---

I am creating a program that will take a master database and create separate databases for class room training.

creating my own app to do this since it will have...

ramana3327 (3/21/2015)

---

Hi,

I tried to divide the backup into different files. I am using the same drive but using striping option. The drive has more than 600 GB free space. The...

sraghunandana.6 (3/22/2015)

---

Hi Team,

Im upgrading the SQL Database and i've been facing one error.

TITLE: Microsoft SQL Server 2012 Setup

------------------------------

The following error has occurred:

The network path was not found. (Exception from...

mbSanDiego (3/21/2015)

---

I need some help with a select statement joining file1 to file2. File 1 may have 0, 1, or many corresponding rows in file2. I need to...

jaggy99 (3/21/2015)

---

Hi All,

I like to create an SQL view to divide amount 300,000 between 12 month starting from Month July 2014 to June 2015 as shown below

Amount ...

Here is a solution that is based on the data in the OP with some corrections and one multi-month entry added to it. The code is straight forward and somewhat...

Lynn Pettis (3/21/2015)

Thank you Eirikur. Nothing in the help that I found indicated that this needed to be done, it just assumed it was already there in the Tools...