Eirikur Eiriksson (2/6/2015)

---

Sean Lange (2/6/2015)

---

Sioban Krzywicki (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on...

Sioban Krzywicki (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on the Wall)

... Mark one...

Eirikur Eiriksson (2/6/2015)

---

Further on Sean's answer, here is the "hard way" (don't worry, the server does the work:-D) of doing a running total on SQL Server 2008 and earlier

😎

USE tempdb;

GO

IF...

Eirikur Eiriksson (2/6/2015)

---

Just out of curiosity, in this case wouldn't a filter do the job, something like WHERE XX <> '' or WHERE LEN(XX) > 0 or even better, WHERE...

Why in the world is Gender a bit? It should be a char(1) with a constraint of 'M' or 'F'. Which gender is 1 and which one is 0?

I have...

This will help. What should be the output for the sample data you posted? Does the table really have no primary key? Also, why is the...

This sounds like a running total problem. In 2012 this is easier using LEAD and LAG but in 2008 those aren't yet available. Check out this article from Jeff Moden...

johnnyrmtl (2/6/2015)

---

Sean Lange (2/6/2015)

---

johnnyrmtl (2/6/2015)

---

All of the source databases will basically be upgraded from 2008 over to a 2012 sql server and they are named with a long alphanumeric string...

johnnyrmtl (2/6/2015)

---

All of the source databases will basically be upgraded from 2008 over to a 2012 sql server and they are named with a long alphanumeric string ( application created...

You are quite welcome. Glad that worked for you.

Notice this question is nearly 3 years...

giszzmo (2/6/2015)

---

Hi, I'm trying to count the number of scores in a column that are not null the cell is not blank. I know the COUNT function ignores NULLs already...

johnnyrmtl (2/6/2015)

---

My scripting abilities are less than stellar and I need to do this today 🙁

I have backed up all the databases via a maintenance plan on the source server...

Hi and welcome to the forums.

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

johnnyrmtl (2/6/2015)

---

Hello all,

I have backed up databases from a 2008 server and now I would need to restore them to a 2012 , the only issue is that I need...