Divine Flame (12/7/2011)

---

Ninja's_RGR'us (12/7/2011)

---

Divine Flame (12/7/2011)

---

In short, you should use Table Variables when it has to contain very small chunk of temporary data (i.e. few rows only). If the temporary...

Jeff Moden (12/7/2011)

---

Ninja's_RGR'us (12/6/2011)

---

ChrisM@Work (12/6/2011)

---

Ninja's_RGR'us (12/6/2011)

---

There's noone I recognize from this...

Divine Flame (12/7/2011)

---

In short, you should use Table Variables when it has to contain very small chunk of temporary data (i.e. few rows only). If the temporary data size is...

sqlfriends (12/6/2011)

---

Ninja's_RGR'us (12/6/2011)

---

The only thing I know for sure is that you can use SSRS 2008 and connect to sql 2005 (to fetch the report's data)... along with plenty other...

Really???

--This assumes you want to ignore the time part

--Adjust as you see fit

DECLARE @Today DATETIME

SET @Today = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))

SELECT @BeginDate = BD, @EndDate = ED FROM

(

SELECT '1753-01-01'...

Michael Valentine Jones (12/6/2011)

---

Revenant (12/5/2011)

---

Michael Valentine Jones (12/5/2011)

---

Michael Valentine Jones (12/3/2011)

---

The worst abuse is when they set short project deadlines without any attempt to match the workload to the available...

david.ostrander (12/6/2011)

---

Thank you for the tips I was wondering can you suggest how I would or even if I could Inner Join two tables that do not have PK related?

For...

halifaxdal (12/6/2011)

---

Can't deliver coffee to Montreal from Toronto, TH does not provide...

kotha.srikanth (12/6/2011)

---

is there any updates on this. I am facing something similar in my project, I tried everything mentioned in this thread but still not able to repro the defect...

The only thing I know for sure is that you can use SSRS 2008 and connect to sql 2005 (to fetch the report's data)... along with plenty other versions and...

No, use a single @start and @end and use then only once in the where.

Time for coffee :hehe:.

What's the point of having obfuscated yet, 100% accurate data??? :blink:

BTW DATEADD(M, 1, Date) <> DATEADD(D, 30, Date)

AND 1 = CASE WHEN @a = 1 AND date between @start and @end THEN 1

WHEN ... THEN 1

ELSE 0 END

Declare @Begindate & @EndDate

Do your cases first to set the range then use between in the select.

If you insist on the where (making it non sargable)

AND 1 = CASE WHEN...