dsmith402 (12/17/2016)

---

Thanks for the info.

The reason I need to avoid functions is because I need this to execute in Excel. Based on my experience Excel doesn't always like complex coding....

dsmith402 (12/17/2016)

---

Thanks for the info.

The reason I need to avoid functions is because I need this to execute in Excel. Based on my experience Excel doesn't always like complex coding....

dsmith402 (12/16/2016)

---

Looking for a non-user function that will allow me to separate items within a field, only separated by a comma, into new rows.

I'm not too familiar with SUBSTRING and...

RD Francis (12/16/2016)

---

Jeffrey Williams 3188 (12/16/2016)

---

How did you determine that only 11GB of space is in use? I have seen this kind of issue with one or more tables...

SQL-DBA-01 (12/16/2016)

---

Hi

I am calling this below command from .cmd batch file as I have no SQL Agent (express edition). But getting the below error while I try to run that...

Is the DELETE able to make use of...

v.razaghzadeh (12/16/2016)

---

Dear Steve

Thank you so much for the time you spending on this.

I have tried your suggestion and do not get any results back. Is the second select statement should...

yuvipoy (12/16/2016)

---

No actually i guess there is an issue in SQL server 2012 which ever data column which is having as float or convert(float ) has an issue,where as in...

Doug.F (12/15/2016)

---

sgmunson (12/14/2016)

---

Doug.F (12/14/2016)

---

sgmunson (12/14/2016)

---

Doug.F (12/14/2016)

---

Sonova...yep, I see where the hole is, in my logic =/

To be completely honest, I had rewritten it with ISNULL by the time I got...

randy.moodispaugh (12/15/2016)

---

Recently, we cloned a VM Reporting Server that was MSSQL 2012 Enterprise. On this clone (We will call SSRS02) was the SSRS services. The original SSRS Server...

dan-572483 (12/15/2016)

---

All:

I have been asked to upgrade an existing SQL 2012 instance to SQL 2014.

This can be a simple operation of an in-place upgrade (after making sure we have good...

sqlfriends (12/15/2016)

---

We have a developer that has powershell script that generate SSRS reports. Previously it is fine. But recently he got the below message:

CreateReports Error: Exception calling "Refresh" with "0"...

I'm not 100% sure, but I don't think @@ROWCOUNT is going to have a non-zero value at the point that you test it, which is right at the beginning. ...

halifaxdal (12/15/2016)

---

Thank you Steve,

Your solution is nice however will sometimes not applicable to some cases, like mine: I am not allowed to create stored procedures or functions on that...

Here's the changes for the CTE to only have customers who bought something in a Men's department AND in any other NON Men's department within the same calendar time frame....