Jeff Moden (12/7/2015)

---

pwalter83 (12/7/2015)

---

msbisyed (12/7/2015)

---

HI Mays,

Same Issue was there when I'd work on the Excel to SQL and vice versa.

This is ('01/01/1900 ) default time stamp.

TRY This: -...

msbisyed (12/7/2015)

---

HI Mays,

Same Issue was there when I'd work on the Excel to SQL and vice versa.

This is ('01/01/1900 ) default time stamp.

TRY This: - Select the column...

pwalter83 (12/4/2015)

---

GilaMonster (12/4/2015)

---

The TIME data type stores a time of day, not a time interval. Since a day has only 24 hours, that's the max that TIME can store (well,...

GilaMonster (12/4/2015)

---

The TIME data type stores a time of day, not a time interval. Since a day has only 24 hours, that's the max that TIME can store (well, 23:59:59.9999...).

Time...

pwalter83 (9/23/2015)

---

Hi,

I have an issue wherein I need to do a normal SUM in the bottom row of the COUNTDISTINCT in the above row. It returns an incorrect value if...

John Mitchell-245523 (7/14/2015)

---

I would advise you to calculate the time difference in minutes. You can display it as hh:mm in your presentation layer. That said, what is it...

Hi Jason,

Thanks a lot for the code. However, I am facing an...

Lowell (6/2/2015)

---

yes.

on codeplex.com, there is free, available source code for at least two projects i know of that lets you do data driven subscriptions from SQL Standard instead of...

imex (5/13/2015)

---

Hi,

Try:

with

CTE_Months as

(

select DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) as MonthYear

...

Thanks very much it worked perfectly !

Just one more thing if you can help me with, I need to...

Lynn Pettis (4/10/2015)

---

pwalter83 (4/10/2015)

---

Hi,

I am getting an error when running this query in SSRS- "an expression of non-boolean type specified in a context where a condition is expected , near...

I have clearly mentioned it is a SQL server and SSRS related question. Where did Excel...

Can anybody please help on this ? Any ideas would be appreciated.

ScottPletcher (3/25/2015)

---

You should get rid of the DISTINCT in the subquery; since you're GROUPing on BL_ID, you don't need it anyway.

Otherwise it's difficult to re-write because there are no aliases...

Yes, those are all varchar fields. Is there...