It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!

Jeff Moden (11/11/2013)

---

Lynn Pettis (11/11/2013)

---

Just a suggestion based on my own philosophy, regardless of collation used (case sensitive or case insensitive) you should write your code as if it is...

mister.magoo (11/11/2013)

---

Lynn Pettis (11/11/2013)

---

If I read your code correctly, this may work:

INSERT INTO FarzinIntro

SELECT

r.Role_ID,

r.User_ID,

dt1.n,

GETDATE()

FROM

...

Just a suggestion based on my own philosophy, regardless of collation used (case sensitive or case insensitive) you should write your code as if it is always case sensitive. ...

Express12 (11/11/2013)

---

thx for helping me out here.. Our code is proprietary therefore I created a short example in my original post. The comma is actually in my "live" EXEC...

If I read your code correctly, this may work:

INSERT INTO FarzinIntro

SELECT

r.Role_ID,

r.User_ID,

dt1.n,

GETDATE()

FROM

...

First, be careful with making a covering index. Depending on how many columns of data and their sizes may make a covering index quite large. If this is...

Select the max inspection date for each office, identify...

I find that the more I have learned there is also a lot more to learn. As you gain experience, for instance, in tuning SQL code you start to...

Revenant (10/25/2013)

---

Luis Cazares (10/25/2013)

---

I'm losing faith in humanity here as I've been interviewing some candidates for BI developers at my job. The last one claiming to have 8 years of...

SQLDCH (10/24/2013)

---

You saved my bacon. That's what I get for spending too much time in one league.

Game is on in an hour so, get those lineups updated.

Matchups:

SSC Steelers (3-4)...

Jeff Moden (10/20/2013)

---

I'm curious... please explain why you don't want to...

Short circuited the loop even more:

declare @Str1 varchar(10) = 'ABBA';

declare @IsPalindrome bit = 1;

declare @LoopCnt int = 0;

while @LoopCnt < len(@Str1) and @IsPalindrome = 1 and (1 + @LoopCnt <...

And if you must use a loop then how about this?

declare @Str1 varchar(10) = 'ABBA';

declare @IsPalindrome bit = 1;

declare @LoopCnt int = 0;

while @LoopCnt < len(@Str1) and @IsPalindrome = 1

begin

select...

And what is wrong with using the reverse function?