Jeff, did you tweak the CustomerID MOD value from 50000 at all for that?

Jonathan AC Roberts (3/29/2012)

---

mister.magoo (3/29/2012)

---

Hi Jeff,

Great Spackle, thanks!

In my tests, using your code to build a million row test, I found this method to be twice as fast for the...

Hi Jeff,

Great Spackle, thanks!

In my tests, using your code to build a million row test, I found this method to be twice as fast for the same logical reads.

SELECT DISTINCT

CustomerID

FROM...

This is one way...but almost certainly not the best way....works ok on a million rows

BEGIN TRAN ; -- just for repeatability

CREATE TABLE #DATA(ID INT, VALUE1 INT,VALUE2 INT,TYPE INT);

INSERT #DATA(ID,VALUE1,VALUE2,TYPE)

SELECT 1,...

Thanks for the feedback..

I can't tell exactly what is wrong from reading that code, but why not try REPLACE instead of your own function?

REPLACE(myString,"'","''")

A1 --> B1

A2 --> B2

Count B = 2

A1 --> B1 --> C1

A1 --> B1 --> C2

A2 --> B2 --> C3

Count B = 3

What I mean : Row 1 in A...

Do your users have email applications on their desktop?

If so, why not just use a mailto: action?

Go into the textbox properties, select Action, Go to URL and enter an expression...

bubs (11/20/2011)

---

Thanks for the help mister.magoo!!

The query works great for retrieving the remaining vacation to date.

However, the report allows the user to select a date range to query the remaining...

Maybe something like this?

SELECT E.ID

, (E.LastName + ', ' + E.FirstName) AS Name

, V.TotalVacationDays

, V.RemainingVacationDays

, sum(CASE AH.AbsenceTypeID

WHEN 2 THEN

(datediff(DAY, AH.StartDate,...

JonFox (11/19/2011)

---

If I'm understanding the OP correctly, that's not quite what he's looking...

If you use JonFox' sample data...

SELECT RecordSeq, Account, ActivityDate, Rep,dense_rank() OVER(PARTITION BY Account ORDER BY rep)

from #Cases

One word - ROWVERSION - I don't think you can break this...

BEGIN TRAN

-- Let's have a test table with an identity (to be forced out of order)

-- and a varchar...

Yes, but first can you answer these:

Why do you work in hours for absence history and days for vacation?

What is the meaning of TotalVacationDays...

m0n (11/12/2011)

---

Hello

When I select table1.colA + table2.colA it return null value when colA is 0

At table1.colA and table2.colA I already use isnull function to convert null to 0 before

Please suggest.

Thank...