bagofbirds-767347 (4/9/2013)

---

Hello all, i am having a problem trying to get the sum of a column if a join happens. Basically, i want to sum up a quantity for...

Create an empty database and run the following:

--===== Conditionally drop the test table to make reruns in SSMS easier.

IF OBJECT_ID('tempdb..#TestTable','U') IS NOT NULL

...

To what granularity are you trying to exclude weekends?

rarascon (4/9/2013)

---

I've been searching for something similar, but haven't quite found it. My dilemma is that this table was created with a TransDate of right(CONVERT(VARCHAR(10), TheDate, 103),7), which is...

Steven Willis (4/8/2013)

---

Lynn Pettis (4/8/2013)

---

Steven Willis (4/8/2013)

---

Jeff, just FYI...I created the million row table on my slow laptop and tested the code from your article. With a normal SELECT statement...

Nope, not what I'd want to see. I'd want to see the following:

1) DDL for the...

Post ALL your code, dynamic sql and the sql used to call it.

Steven Willis (4/8/2013)

---

Jeff, just FYI...I created the million row table on my slow laptop and tested the code from your article. With a normal SELECT statement it took appx 19-22...

SQLWannabe (4/8/2013)

---

Wow, is it really that easy? Evidently I was trying to make it harder than it actually is/was.

Lowell, I've read several posts where people keep saying stuff like, "If...

Still unclear. Since all changes to a database are logged, the transaction log is going to grow if there is insufficient space to hold the active transactions.

Have to agree, need DDL, sample data, and expected results.

Care to elaborate? Your question is vague and open to many answers.

Can you post the code for your stored procedure and the scalar function?

Something like this:

CREATE TABLE [dbo].[Products](

[ProductDesc] [varchar](200) NULL

)

INSERT INTO Products(ProductDesc) SELECT 'WidgetA'

INSERT INTO Products(ProductDesc) SELECT 'WidgetB'

INSERT INTO Products(ProductDesc) SELECT 'WidgetC'

INSERT INTO Products(ProductDesc) SELECT 'WidgetD'

INSERT INTO Products(ProductDesc) SELECT 'WidgetE'

CREATE TABLE [dbo].[Exceptions](

[ProductDesc]...

If what you are looking for is Current month (say 2013-04) and next month (2013-05), the following will work (it will also work if currrent month is 2013-12 and next...