I...

Just a small correction to J Livingston's query to avoid scanning the whole table.

SELECT

Custmer,

location,

SUM(CASE WHEN [Date] >= @mth_st...

djj (7/26/2016)

---

TomThomson (7/24/2016)

---

Jeff Moden (7/24/2016)

---

Hugo Kornelis (7/22/2016)

---

That will give you the...

It's actually a leftover from when I had to process the whole table at once. It's taking the GroupID value from the parent node and comparing it each child to...

ah0996 (7/25/2016)

---

Hi,

I need help with my CTE; All I need to find is the match between groupID and memberID and set nodelevel; once the result is...

lynns (7/25/2016)

---

Thanks. I understand the comment portion. What has me confused/concerned is that a stored procedure with a parameter of data type float will take a non-numeric value...

That should be a lot simpler.

Double hyphens define a single line comment. Everything to the right of them will be ignored.

--This is a single-line comment

/*

This is

a multi-line

comment

*/

drew.allen (7/25/2016)

---

Alternatively, you could cast your DATETIME data as DATE and compare those.

WHERE CAST(DateCol AS DATE) = CAST(DATEADD(DAY, -1, GETDATE()) AS DATE)

Since CASTing from DATETIME to DATE is still SARGable,...

What are you using the product_stat table for? Will you have more than a row per product? Will it keep history? If it'll always show the products in orders, maybe...

CREATE TABLE #SampleDuplicates(

A int,

B varchar(10),

C varchar(10),

D ...

You have 2 variables named @res. One inside the dynamic code, and one outside. The one inside the dynamic code is lost and the one outside is printed but never...

It's obviously meant to include the whole gender...

If a daily backup is enough for this database, I'd suggest to change the recovery mode to simple. Be sure that you don't have any uncommitted transactions that would prevent...

You're missing the begin and a different set of begin...end. You're also missing the commit transaction. You're also using the slow option.

BEGIN TRANSACTION;

IF EXISTS(SELECT * FROM db1.dbo.Jobs where status in...