Show us your inators....

Luis Cazares (12/3/2015)

---

To always return a row, either with a value or a null. I might have done...

dallas13 (12/3/2015)

---

Thanks but its not working the way it should work. Its bringing false emails. And instead of user name it brings DOMAINNAME\LOGINNAME that I put inside EXECUTE AS 'DOMAINNAME\LOGINNAME'

I...

Since nobody mentioned it I will. You really should avoid using the sp_ prefix. You should use a different prefix, or even better drop the prefix entirely. http://sqlperformance.com/2012/10/t-sql-queries/sp_prefix

I am curious about a couple things here.

Why MAX(c)?

(MAX(c),'No Colour')

Also, why wrap the column and the variable with LOWER? Unless this is a case sensitive collation this provide any...

Nilssond (12/3/2015)

---

PROBLEM:

Table has multiple dated records for each category, I need to extract the 2 most recent records by category.

SAMPLE DATA:

CREATE TABLE CATEGORYHISTORY(

CAT_ID VARCHAR(5),

STARTDATE DATE,

ENDDATE DATE,

REASON CHAR(1))

INSERT INTO CATEGORYHISTORY...

Lowell (12/3/2015)

---

i have a couple of model DDL triggers that execute as specific users; i think that's the...

Checking it twice...

Thanks!!

Steve Jones - SSC Editor (12/3/2015)

---

Yes and no. We've almost always required a login, which helps us support the site, and I've been hearing this complaint for 15 years.

We are...

It is not exactly clear what...

mw112009 (12/3/2015)

---

This query works fine,

Can anyone add a join and make it useful so that it will show the name of the

person running the query( or stored proc )

Right now...

Save time? It is like 3 seconds to wrap that in a cte. Certainly...

dndaughtery (12/3/2015)

---

Hey guys, I have a need to query a table grouped by Col_A, Col_B, Col_C, Col_D and return only one record because each has a primary key that I...

How about this? http://connectionstrings.com/%5B/url%5D

mastersql (12/2/2015)

---

Hi SSC

I've now found a YouTube clip which says you shouldn't use export and import for SQL database to SQL database.

It says use the Copy Database option with SSMS...