The following will split the data as you require (based on Remi's universal split query)

SELECT o.UserID,

LTRIM(SUBSTRING(',' + o.OrderID + ',', n.number + 1,

CHARINDEX(',', ',' + o.OrderID + ',', n.number...

Can someone tell me how to create a linked server to Active Directory?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp

And, sushila....

why is it everytime you join a thread it goes awol and off the beaten track

Besides,

I always like to wait for our Lord and Master, Supreme Being to produce the light for us to see forth into the wilderness, hail Remi

I think the duplicate problem stems from the users,webrequest,internaloffice link.

unworkable deptworker

my guess

DECLARE @today datetime

SET @today = DATEADD(day,DATEDIFF(day,0,GETDATE()),0)

SELECT u.UdeptManager, u.Uname, o.IOofficeName AS [Office],

ISNULL(sc.Workable,0) AS [Workable], ISNULL(sc.Unworkable,0) AS [Unworkable]

ISNULL(b.Bills,0) AS [Bills], ISNULL(b.AvgBill,0) AS [AvgBill], ISNULL(b.Dollars,0) AS [Dollars]

(CAST(b.Bills...

Somebody suggested that I should partition the query

Using linked server, that is your only choice. Try changing...

DECLARE @var varchar(8000)

SELECT @var = [textcol] FROM

will retrieve the first 8000 chars

SELECT @var = SUBSTRING([textcol],10,10) FROM

will retrieve 10 chars starting at char 10

Nice set of articles, Steve

You seem to be well versed in the intricacies of employment, ever thought of starting up an Employment...

Have you actually determined what is causing the error.

Is it disk space, the version of SQL Server or is the database in question not allowed to extend?

If it is disk space...

OK, remi, I stand corrected

SELECT COUNT(a.quizid)+1 AS [rank]

FROM (SELECT score, datentime FROM x

WHERE x.quizid = @quizid AND x.username = @username)...

It will populate the index using the data already present, if any.

But you cannot count 'AllTheRowsThatComeBeforeThatOne' without ordering the data and giving each row a sequential id

CREATE NONCLUSTERED INDEX IX_FuelCOMP ON FuelMaster.dbo.Fill (filldate, companyno)

will alleviate the need for the USE statement

If there is a 'rank' column populated with results then yes, your're right, if dynamically created then no, you're not.