Jo6205 (8/27/2015)

---

GilaMonster, first let me say I love your avatar.

Thanks for your quick response. When I use IF, I receive an error - Incorrect syntax near the keyword 'IF'.

I'm...

blake.hartman (8/25/2015)

---

Lynn Pettis (8/25/2015)

---

blake.hartman (8/25/2015)

---

Nevermind, I see the problem

It should be this

DATEADD( ww, DATEDIFF( ww, 0, <dateparam>-1 ), 0 )

I thought I was going crazy, but someone copied the wrong...

blake.hartman (8/25/2015)

---

Nevermind, I see the problem

It should be this

DATEADD( ww, DATEDIFF( ww, 0, <dateparam>-1 ), 0 )

I thought I was going crazy, but someone copied the wrong grouping expression and...

Actually, this is the expected behavior.

What should it return for the Sunday date?

blake.hartman (8/25/2015)

---

We have bee using something like the following to get the Monday for the specified date.

However, we came across a scenario where this is not working

DECLARE @dt AS datetime

SET...

mariandalalau (8/25/2015)

---

I didn't guest, I've read a lot of forums.

you can check this link: http://sqlblog.com/blogs/paul_white/archive/2010/08/27/sorting-row-goals-and-the-top-100-problem.aspx

Actually the problem on that forum is different, is based on the big difference on...

Here is the real problem, we can't see what you see. It's like calling your mechanic and expecting him to fix your car without seeing it or touching it.

Everything...

DuncEduardo (8/24/2015)

---

I'm less disappointed in the quality of questions than with the lethargy in replying.

Sometimes, and I've been there myself, due to work pressures, it is often quicker to post...

So, I am going to ask again, can (and does) EndDate have dates that AREN'T 06/30/YYYY where YYYY is any given year? If so, and you don't want those...

mtillman-921105 (8/20/2015)

---

Lynn Pettis (8/19/2015)

---

And then there are those Oracle people seeking help on a MS SQL Server forum and seem surprised that a T-SQL solution won't work on an Oracle...

serviceaellis (8/20/2015)

---

Jacob Wilkins (8/20/2015)

---

I might be missing something, but it doesn't seem so mysterious why those don't return the same results.

I'm assuming here that you're actually comparing the second version...

And then there are those Oracle people seeking help on a MS SQL Server forum and seem surprised that a T-SQL solution won't work on an Oracle server.

Silver spoon, silver spoon, silver spoon, when are you going to admit you are in over your head and really need to find a different career.

I could the see the problem from the git go:

DECLARE @TableName VARCHAR (50)

DECLARE @BatchSize int

DECLARE @ArchiveYear Date

DECLARE @RowCount int

SET @TableName = 'tblCall'

SET @BatchSize = (SELECT BatchSize FROM PrismDataArchive.dbo.ArchiveDriver WHERE TableName...

Or this:

SELECT

*

FROM

[ThomasSci].[dbo].[tsi_gdserial_vw]

where

date_shipped >= cast(dateadd(day, -1, getdate()) as date) and

date_shipped < cast(getdate() as date)

order...