raj_paandy

The output similar to my question. All what I want to see is when user input an Employee Id, it should show their superior manager (means manager's manager). In...

Jason Selburg (4/28/2011)

---

No need to CAST.

SELECT

NAME, LASTNAME,

CASE WHEN AGE > 25 THEN '1' ELSE '' END AS QUALIFIED

FROM

...

When running your code (eight consequtive runs) on SQL 2008 Developer edition as

CREATE TABLE #pwdTbl(Pwd Char(10),C2 CHAR(6),C3 DATE)

declare @ctr int

declare @seed int

set @ctr =1

WHILE @ctr < 10

BEGIN

set @seed=@ctr + 2048

insert...

Steve Jones - SSC Editor (4/27/2011)

---

Unfortunately, I think some people are going to have to get hurt, and companies sued before they start to really focus on the quality of...

You might want to also read this blog posting of Paul Randal

It is a survey of what other DBA's feel is their most pressing performance problems.

http://www.sqlskills.com/BLOGS/PAUL/post/What-do-you-look-for-when-analyzing-query-plans.aspx

Edited to correct...

One thing I would STRONGLY suggest is to NOT SHRINK THE DATABASE.

In the normal course of working it will only grow again, and shrinking can/may introduce more problems that I...

It is a matter of pride, of self assurance,y...

I take exception to the words "very amateur". Read both and thoroughly enjoyed both.

Thanks...

Kiara (4/26/2011)

---

Wait...

Jeff

Sent to you via email, the latest test results for the 4K splitter test. Just letting you know here to draw your attention to your e-mail

Jason Selburg (4/25/2011)

---

I'll concede that the use of the word Guarantee was not the correct word.

But I will again state, that the purpose was to spark conversation.

My appologies to...

david.holley (4/25/2011)

---

Thanks for that link. I realized over the weekend, that I was asking the wrong question. I don't need to adjust to the nearest week day, but rather need...

From:

http://dictionary.reference.com/browse/guarantee

"something that assures a particular outcome or condition:"

Sorry but my language comprehension is that means the ONLY answers are 2 or 9 or 11 and NEVER another value.

But the given...

Just on transactions (not specifically including identities)

1. Published...

Now none of these are mine but I failed to record who informed me of them.

select DATEADD(wk,DATEDIFF(wk,0,dateadd(dd,6 - datepart(day,getdate()),getdate())), 0)

AS 'First Monday'

--add 4 days of it to get...