mickyT (11/7/2013)

---

Hi

If you have a look at this article[/url] by Jeff Moden, it will explain how to group by contiguous islands of dates. This is essentially what you are...

spaghettidba (11/7/2013)

---

You probably won't be getting many replies if you don't give us some data in a consumable format.

Please read the first article linked in my signature line: you'll...

erikd (11/7/2013)

---

I don't use any VARCHAR columns; they're all NVARCHAR, though I do control their sizes in increments of 64 to keep data from being truncated.

I've gotten some feedback...

mark 4643 (11/7/2013)

---

Thanks!

I had played around with a derived table and...

Jeff Moden (11/6/2013)

---

dwain.c (11/5/2013)

---

Jeff Moden (11/5/2013)

---

dwain.c (11/5/2013)

---

Jeff Moden (11/5/2013)

---

I assure you, it's just words...

Based on cursory review of the information surrounding the quote, I'm in a position of "initial reluctance to agree."

I'm thinking that part of that 97% he talks about should be...

Jeff Moden (11/6/2013)

---

dwain.c (11/6/2013)

---

Jeff Moden (11/6/2013)

---

GilaMonster (11/5/2013)

---

Jeff Moden (11/5/2013)

---

I'm well aware of that. You and I have had this conversation before and I absolutely agree. I should have...

Something like this might work though:

DECLARE @InventoryNames varchar(100)

DECLARE @sql nvarchar(max)

SET @sql=

'

WITH names(n) AS

(

SELECT Name

FROM dbo.iNamesExcel$

)

INSERT INTO TEMP

SELECT * FROM OPENQUERY (

ADSI,

''SELECT displayname,

samaccountname,

telephonenumber,

mail,

department,

title

FROM ''''LDAP://domain name obfuscated''''

WHERE

objectClass = ''''user''''...

Alan.B (11/6/2013)

---

You could do something like this (I changed @name to @names):

DECLARE @names varchar(max);

WITH names(n) AS

(

SELECT Name

FROM dbo.iNamesExcel$

FOR XML PATH('')

)

SELECT @names=CHAR(39)+LEFT(n,LEN(n)-1)+CHAR(39)

FROM names

Then, in your DSQL change your and...

Oh, and by the way. This is the kind of allocation problem that bean counters are going to jump on you about if you don't get the rounding just...

There may very well be an easier way to do this, but this is what I came up with:

WITH AllDepts AS

(

SELECT DeptID, JobNo

...

Here is your code posted so others can see it easily.

-- Using SQL2008 R2

IF OBJECT_ID('tempdb..#Sales') IS NOT NULL

DROP...

Jeff Moden (11/6/2013)

---

GilaMonster (11/5/2013)

---

Jeff Moden (11/5/2013)

---

I'm well aware of that. You and I have had this conversation before and I absolutely agree. I should have said "and that...

Glad to hear you got it working finally.

Obviously, what I gave you was impossible for me to test.

Jeff Moden (11/6/2013)

---

I'm doing some additional testing (when I have the time) with adding the binary collation as well as a slightly different take on the cCTE for creating the...