CASE WHEN DATENAME(dw , MAX(Date)) = 'Friday' THEN DATEADD(day , 3 , MAX(Date))

ELSE DATEADD(day , 1 , MAX(Date)) END as Date

edit...corrected typo

mm7861 (11/17/2015)

---

Thanks Drew, out of curiosity why do you think LAG is not best for the job? I tried the LAG version and your version and the LAG version runs...

g.debrucker (11/16/2015)

---

Yes the sql code to get this out of my database would be much apreciated.

Probably I will use MySQL in the future so If you could help me with...

g.debrucker (11/16/2015)

---

Hi all,

I'm very new to SQL and MS-Access. But My hobby is driving me to databsetools 🙂 I collect every soccer game around europe but my excelsheet can't handle...

maybe a start

WITH CTE

AS (

SELECT

DATEADD(day , 1 , MAX(Date)) AS Date

, Asset_ID

,...

similar problem here....with a possible solution

http://www.sqlservercentral.com/Forums/Topic1704338-1550-1.aspx

here is one way....this should get you started.....

SELECT

CONVERT(varchar(10) , TimeOut , 101) AS yourdate

, SUM(CASE

WHEN DATEPART(hour , timeout) >= 12

...

mrbill.mt (11/14/2015)

---

J Livingston SQL (11/14/2015)

---

mrbill.mt (11/14/2015)

---

I have the following data:

I have to count data from date A to Date B (e.g: 11/1/2015 to 11/3/2015) and From Hour to Hour (e.g:...

mrbill.mt (11/14/2015)

---

I have the following data:

I have to count data from date A to Date B (e.g: 11/1/2015 to 11/3/2015) and From Hour to Hour (e.g: From0_12: From 0:00 to...

nexus2vijay (11/12/2015)

---

Thanks for the revert Bossman.

I'm not a Techie infact. I'm from Teaching field and new to IT industry and getting to know the DB.

If you could help me out...

nexus2vijay (11/12/2015)

---

Hi,

From the attached 4 Tables Schema Diagram

Will the below query Reduce me the ListPrice by 20% if i didn't receive the order for the last 2 years ? Jammed...

A "test"...

homework I assume?

have you actually set up some sample tables and data and run your answers to see if they are correct?

or are you looking for any easy way out?

think the following will help us all.....please read and post accordingly.

thanks

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

Luis Cazares (11/2/2015)

---

Eirikur Eiriksson (11/2/2015)

---

Lynn Pettis (11/2/2015)

---

It was awesome to get to meet some of the denizens of The Thread last week. Too bad Jeff Moden...