memymasta (12/12/2011)

---

========== Jim-720070 version ==========

Warning: Null value is eliminated by an aggregate or other SET...

memymasta (12/12/2011)

---

Here's the result with real data:

========== Jim-720070 version ==========

Warning: Null value is eliminated by an aggregate or other SET operation.

(3336 row(s) affected)

Table 'Worktable'. Scan count 0, logical reads 0,...

Use Wingdings next time and see how that works out for you 😉

Next time, I might even read the whole thread before I post!!

Corrected.

SELECT userid, firstname, lastEndDate AS lastJob, DATEDIFF(dd, lastEndDate, GETDATE()) AS daysSinceLastJob,

MAX(jobname) AS jobname

FROM (SELECT a.id AS userid, a.firstname, a.lastlogin,...

This article discusses the options[/url]

Phil Parkin (12/12/2011)

---

Thanks, but that returns the current user - not quite what I am after.

I want the name of the user which is running the SQL Server service for...

No problem.

Out of curiosity, which performs better on your real data? (I won't be offended...

Assuming I understand you correctly

SELECT SUSER_NAME()

You're right, I did miss that requirement.

Here's the corrected version for my code: -

SELECT userid, firstname, lastEndDate AS lastJob, DATEDIFF(dd, lastEndDate, GETDATE()) AS daysSinceLastJob,

MAX(jobname) AS jobname

FROM (SELECT a.id AS userid,...

DECLARE @str NVARCHAR(MAX) = '1,2,3,4'

SET @str = '''' + REPLACE(@str,',',''',''') + ''''

SELECT *

FROM emp

WHERE empid IN (@str)

GilaMonster (12/10/2011)

---

Cadavre (12/9/2011)

---

Sorry if it feels like I'm pestering you Gail, I just like to understand why. For me, what you're describing contradicts what I believed as the why,...

Surprisingly difficult, especially considering the % of correct answers!

Thanks for the question and the point 😀

memymasta (12/12/2011)

---

Oh, i just run the code without removing the "WHERE RecentJob = 1" part.

The code works exellent and has alot better...

BEGIN TRAN

--Create sample data to play with

SELECT Identifier, priority, accountnumber

INTO #SampleData

FROM (SELECT 123456, 1, 9999999999

UNION ALL SELECT 123456, 1, 8888888888

...

GilaMonster (12/9/2011)

---

Kiara (12/9/2011)

---

Hm... that would...