sqlbidev (7/6/2015)

---

Hi there,

I have the following table struction, lets call it table A.

bookidstartdate endate

2001 2000-01-01 2000-01-05

3001 ...

sqlbidev (7/6/2015)

---

Hi there,

I have the following table struction, lets call it table A.

bookidstartdate endate

2001 2000-01-01 2000-01-05

3001 ...

Here's your error:

case

when Rownum<= datediff(day, salesdate, baseenddate) then DATEADD(mm, RowNum, salesdate)

else 0 end

You have two different datatypes returned by your CASE....

mandania (7/3/2015)

---

Hello, i have been trying to solve this for sometime but i cant get around it. hopefully somebody can help me out here.

this is a piece of my code:

...

Koen Verbeeck (7/3/2015)

---

GilaMonster (7/3/2015)

---

No, I'm...

Sean Lange (7/2/2015)

---

jasona.work (7/2/2015)

---

Today is the kind of day (and it's only been an hour and a half since I got to work) that you clock watch...

OTOH, got plenty to...

Ed Wagner (7/2/2015)

---

jasona.work (7/2/2015)

---

Today is the kind of day (and it's only been an hour and a half since I got to work) that you clock watch...

OTOH, got plenty to...

Run this tweak to observe a less irregular usage 😉

;WITH CTE AS

(

SELECT 1 AS ID, 10000 AS SALARY,GETDATE() AS DOJ

UNION ALL

SELECT 1, 13000,GETDATE() - 10

UNION ALL

SELECT 3, 190000,GETDATE() +...

Koen Verbeeck (7/2/2015)

---

ChrisM@Work (7/2/2015)

---

Koen Verbeeck (7/2/2015)

---

BL0B_EATER (7/2/2015)

---

Sounds good to me... were you in the garden sipping on...

Sam Garth (7/2/2015)

---

Thank you all for the suggestion, however If I was to run the following

INSERT INTO #Data

VALUES

(4,'Got Dressed','2015-07-02 06:00:00.000')

And then run my query, It would show me two entries...

Koen Verbeeck (7/2/2015)

---

BL0B_EATER (7/2/2015)

---

Sounds good to me... were you in the garden sipping on a cool beverage...

Eirikur Eiriksson (7/2/2015)

---

Didn't measure the temperature in the Central Line tube yesterday but I've been...

BL0B_EATER (7/2/2015)

---

ChrisM@Work (7/2/2015)

---

That's not so good. Neither were the delays on the train network -...

That's not so good. Neither were the delays on the train network - it took...

Sam Garth (7/1/2015)

---

Hi

I am trying to increase performance of a query that joins a table 19 times.

The current example works similarly to below...

CREATE TABLE #Data(PersonID INT, Activity nvarchar(200), ActivityTime DATETIME)

INSERT...