Lynn Pettis (1/15/2015)

---

Stephanie Giovannini (1/15/2015)

---

I've inherited a SQL Server database in which the procedures all have try-catch. In all but one case, the catch is:

BEGIN CATCH

DECLARE

...

Luis Cazares (1/13/2015)

---

Hi, here's one possibility to get that report. There are other possibilities but this just seemed easy for me.

SELECT CustomerID,

DATEDIFF( MM,

...

Correct!

My solution suggestion:

SELECT CustomerID, COUNT(*)

FROM

(

SELECT CustomerID, ReadDate, Usage

,rn=DATEDIFF(month, ReadDate, 0)...

I'll second this.

Congratulations Koen!

Good question Jeff.

Another question: So I've been away from the forum for 6 months and everyone has already forgotten how to use a pattern splitter?

create table

#tbl_1

(txt varchar (max))

insert into...

Emil Bialobrzeski (1/9/2015)

---

dwain.c (1/8/2015)

---

Emil Bialobrzeski (1/8/2015)

---

Try this

SELECT

EMPLOYEE_ID

, LAST_NAME

, SALARY

, JOB_ID

...

Jeff Moden (1/8/2015)

---

dwain.c (1/8/2015)

---

Luis Cazares (1/8/2015)

---

Maddave (1/8/2015)

---

Jeff Moden (1/8/2015)

---

Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers...

You might want to consider using a dynamic search stored procedure for this:

http://www.sqlservercentral.com/articles/T-SQL/103529/

rash3554 (1/8/2015)

---

Hi there,

I have a table with values 10,22,11,15,14,14,13,12,12,11,11,11

Create table test(testno int not null);

insert into test values(10);

insert into test values(22);

insert into test values(11);

insert into test values(15);

insert into test values(14);

insert into...

Look into using CASE/WHEN/ELSE/END.

Emil Bialobrzeski (1/8/2015)

---

Try this

SELECT

EMPLOYEE_ID

, LAST_NAME

, SALARY

, JOB_ID

,...

CHOOSE your poison:

WITH Tally (n) AS

(

SELECT TOP 20 ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

FROM sys.all_columns

)

SELECT CHOOSE(n, 'a', 'e', 'i', 'o', 'u', 'y')

...

aaron.reese (1/8/2015)

---

Dwain, Nevyn,

Wow Dwain that is some complex code! I have only scanned it and like Nevyn says, it requires the user to seed it with a set of predefined...

Luis Cazares (1/8/2015)

---

Maddave (1/8/2015)

---

Jeff Moden (1/8/2015)

---

Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers alike is "How...

I will need to retain the INTriguing BIT[/i] of knowledge in this thread should it ever come INTo play for me.