bob.bell 82064 (6/23/2014)

---

I have been trying to download Lahman's database to my home SQL Server Express 2008 (we use 2008 at work), but no joy so far. Lahman's .SQL...

Murder

What have you tried?

ByronOne (6/23/2014)

---

Hi everyone

I hope someone can help

I have the following query which uses Row_Number

WITH A1

as

(

SELECT

,ID

,DATE

,NAME

,STATUS

,PRODUCT

,RowNum = ROW_NUMBER() OVER (PARTITION BY ID ORDER BY DATE desc)

FROM Table1

)

SELECT * FROM A1

I...

Ty

Muppets

SQLRNNR (6/19/2014)

---

Stuart Davies (6/19/2014)

---

Sean Lange (6/19/2014)

---

SQLRNNR (6/19/2014)

---

JAZZ Master (6/19/2014)

---

SQLRNNR (6/19/2014)

---

Ed Wagner (6/19/2014)

---

crookj (6/19/2014)

---

...

As SQLRNNR said, maybe.

We would need to see the reset of the query.

ramrajan (6/19/2014)

---

Question 1 : can you rewrite the same with parantheses to understand how it is executing

INNER JOIN dbo.controllersystem cs WITH (NOLOCK)ON sl.SubLocationId IS NULL

...

Visual Studio

Talib123 (6/16/2014)

---

All,

I need to give a SQL account read access to a log shipped db. Encoiuntering issues due to it being read-only.

How do I achieve this, unable to fix any...

Erland Sommarskog (6/12/2014)

---

I'm afraid that I don't understand the question. If you are running a stored procedure, the logon trigger till not fire, because you are already logged in.

But if...

If a procedure tries to access the database using SQL authentication but the login is disabled will the trigger then log the try if the trigger is modified to "EXECUTE...

Luis Cazares (6/6/2014)

That's why I consider zip codes, phone numbers, credit card numbers & others should be stored on string type columns. You could enforce to use just digits (or...

An expert converted our database from Access to SQL2000. We now have zip codes that are float, column names with spaces and #.

One thing I do not...