I guess your first clause should also be like this:

case

when started < '2015-11-01' and finished >= '2015-10-01' then 1

There are 2 formats which are dateformat and language settings independent.

Date only: YYYYMMDD

Date and time: yyyy-mm-ddThh:mi:ss.mmm

That means that your format is not safe. I know it seems inconsistent, but it...

sknox (11/6/2015)

---

Luis Cazares (11/6/2015)

---

sknox (11/6/2015)

---

Luis Cazares (11/6/2015)

---

Rich Mechaber (11/6/2015)

---

Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are...

Maybe some aggregation is needed.

MERGE [dbo].[GiftCard] as target

USING

(SELECT

g.[CardNumber]

,YEAR(MAX(g.[Date]))

,MONTH(MAX(g.[Date]))

,MAX(f.[Period])

...

The Skill, Educational Background and Experience bullet points are a joke. This is the punch line:

?Experience with Kronos Timekeeper software, Remedy Action Request System, ERwin database design tool, Oracle and...

Which of this will define Week 1 for 2016?

2015-10-01 to 2015-10-02

2015-10-01 to 2015-10-03

2015-09-26 to 2015-10-02

2015-09-27 to 2015-10-03

2015-10-03 to 2015-10-09

2015-10-04 to 2015-10-10

j-1064772 (11/6/2015)

---

mister.magoo (11/2/2015)

---

...

/* create a sample stored procedure to demonstrate the logging */

create proc testProc

as

-- log access to the SP

[highlight="#ffff11"]insert logSP default values;[/highlight]

-- Do some work

go

/* execute the test */

exec...

For the backups, don't copy the mdf and ldf files. If you just copy them, they might be in an inconsistent state and won't work if you try to copy...

Sean Lange (11/6/2015)

---

Ed Wagner (11/6/2015)

---

Brandie Tarvin (11/6/2015)

---

Greg Edwards-268690 (11/6/2015)

---

Eirikur Eiriksson (11/6/2015)

---

On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?

Three options given

1) To get the...

When do weeks start? How do you define the first week of the year?

Feel free to ask any questions that you might have.

I'm assuming they use sysadmin credentials as well to connect to the database through the app, because of course it won't work otherwise. (I hope the sarcasm sign was visible)

They...

To simplify this, you could create a calendar table that will contain the fiscal year and week as two of its columns so you don't have to bother with problematic...

Would something like this work for you?

http://www.sqlservercentral.com/Forums/Topic1732401-3412-1.aspx#bm1732424

Steve Jones - SSC Editor (11/6/2015)

---

Luis Cazares (11/6/2015)

---

Aren't those self explanatory? If they don't know the difference, selecting the function and pressing F1 will take them to the page on...