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

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 indicate the job,...

Just for fun here are two alternative methods, a single table scan solution without recursion and a dual self-join

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

BEGIN

CREATE TABLE dbo.TBL_DATE_SAMPLE

(

...

Have you tried to add the Code Snippet Manager Command to the Tools menu?

😎

Edit: typo

Quick thought, there is...

A straight forward way of doing this is to calculate the running total on the first column, here is an example

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_SHIFT') IS NOT NULL DROP TABLE...

Hi and welcome to the forum.

Not certain what you are after but this is my first interpretation

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA;

CREATE TABLE dbo.TBL_SAMPLE_DATA

(

...

patrickmcginnis59 10839 (3/19/2015)

---

Eirikur Eiriksson (3/17/2015)

---

First thought is that fixing the ageing OS/SQL Version should be...