Sean Lange (5/29/2014)

---

SQL is delicious (5/29/2014)

---

Sean Lange (5/29/2014)

---

SQL is delicious (5/29/2014)

---

KoldCoffee (5/29/2014)

---

Sean, I've taken a look at Jeff's article and it does chain to another prerequisite read on Tally Tables...

Sean Lange (5/29/2014)

---

SQL is delicious (5/29/2014)

---

KoldCoffee (5/29/2014)

---

Sean, I've taken a look at Jeff's article and it does chain to another prerequisite read on Tally Tables to get the most out...

KoldCoffee (5/29/2014)

---

Sean, I've taken a look at Jeff's article and it does chain to another prerequisite read on Tally Tables to get the most out of the 'how'. But...

Try this:

select userid from order

WHERE status = UPPER(status) COLLATE SQL_Latin1_General_CP1_CS_AS

Koen Verbeeck (5/20/2014)

---

SQL is delicious (5/1/2014)

---

brad.mccollum (5/1/2014)

To give you a little more insight as to the general nature of the SSIS package, it will basically be looping through a folder...

hunchback (5/15/2014)

---

I wish you could post table schema and sample data.

SET NOCOUNT ON;

USE tempdb;

GO

WITH C1 AS (

SELECT

T.first_name,

T.last_name,

R.degree,

R.pos,

ROW_NUMBER()OVER(PARTITION BY T.first_name, T.last_name ORDER BY R.pos) AS rn

FROM

(

VALUES

('John', 'Smith', '', 'BA', '',...

Sean Lange (5/15/2014)

BWAHAHAHAHA!!!! That sets the value to 1 and then looks up the row in dbo.numbers where n = 1 and sets the value of @n to the same...

Posting before morning coffee = advice fail.

OK. This won't work unless you do THIS too:

SET @n = 1

SET @n = (SELECT n FROM dbo.numbers WHERE n = @n);

And this:

...

WHEN...

n needs to be a variable; declare n (select n from dbo.numbers) as a variable, set it as SET @N = (SELECT N FROM dbo.numbers) then reference @N in the...

I prefer multiple monitors but where I am now I'm stuck hot-desking with a 15" laptop screen. :crying:

I never thought I'd say this, but I miss cubes. I...

Sean Lange (5/9/2014)

---

jdasilva (5/9/2014)

---

Yes, and it currently is, but that query refines data based on a an office...

jdasilva (5/9/2014)

---

Have not started to play with doing this, but looking it over, it still seems like the work is being done from access, which is what is causing the...

I feel your pain; I did a similar project 9 years ago where I moved an Access 97 database to a SQL 2005 back end, maintaining the Access front end....

logitestus (5/7/2014)

---

My apologies. That row shouldn't be returned as 1200.0 but as 2500.0. I can completely understand the confusion.

The logic is where document type (doc_type column) is 'S'...

I'm always nervous, every time. One of my problems is that it's hard for me to articulate exactly how to do something in SQL, or explain it to other...