Spikemarks, is it possible to determine what you want to do from these two posts? I don't think so! How about showing two output lists, one containing what you currently...

Dugi (1/12/2010)

Did you reach a 2 billion records in your table ... usually the tables cannot have 2 billion records, at least I don't know any case, all data in...

Ronan

Run this:

SELECT RowMark = ROW_NUMBER OVER (PARTITION BY machname ORDER BY eventtime),

eventtime, [description], machname

FROM scriptlog s

INNER JOIN vmachine v ON v.Agentguid = s.agentguid

INNER JOIN itf_companyID c ON...

Save yourself from a lifetime of misery and pain, do it properly and use...

No problem:

SELECT u.*, dupes.MainLastname

FROM #Users u

INNER JOIN (

SELECT UserID, MIN(LastName) AS MainLastname

FROM (

SELECT UserID, LastName

FROM #Users

GROUP BY UserID, LastName

) d

GROUP BY UserID

HAVING COUNT(*) > 1

) dupes ON dupes.UserID =...

Has anyone played with this yet?

SELECT s.ID, x.*

FROM #Sample s

CROSS APPLY (

SELECT

MAX(CASE d.ColNo WHEN 1 THEN SUBSTRING(d.DodgyStringData, d.b, d.e-d.b) END) AS [Account],

MAX(CASE d.ColNo WHEN 2 THEN SUBSTRING(d.DodgyStringData,...

Try this:

-- parameters

DECLARE @Year CHAR(4), @Month VARCHAR(10)

SELECT @Year = '2008', @Month = 'February'

-- variable

DECLARE @RowsToReturn INT

-- test rowcount using user-supplied values; ignore parameter if NULL

SELECT @RowsToReturn = COUNT(*)

FROM #test...

ahmadjk (1/11/2010)

---

This Report is for only Internal use only. Specially for Technical team.

Secondly, the data itself stored in sql table is for present day only , after 24 hours time...

Fantastic! Three different methods in as many minutes!

DROP TABLE #Users

CREATE TABLE #Users (UserID INT, LastName VARCHAR(20), FirstName VARCHAR(20))

INSERT INTO #Users (UserID, LastName, FirstName)

SELECT 1, 'Smith', 'John' UNION ALL

SELECT 2, 'Jones', 'James Earl' UNION ALL

SELECT 3, 'Sahathevarajan', 'Rajkumar'...

Ahmad

I can see where you're coming from with this and I'm pretty sure that in some circumstances, your suggestion might make sense: you're indicating to the user "No, there isn't...

If there is no matching data for the supplied year/month, then data should be returned for which years / months instead?

I think we've tied this down for months -...

If you are joining table 1 to table 3 via table 2,...

Please post the exact code which you ran, and describe any result set (or error messages). Thanks.

Try this:

select

...