I suggest running this to see the count with and without the NOLOCK to see if it is even related to the NOLOCK hint:

declare @st datetime;

set @st = getdate()

SELECT count(*)...

Try this:

SELECT

ForcastUnitsTimesOMSCost,

SUM(isnull(CTCBOHAndWCSBOHTimesOMSCost/nullif(ForcastUnitsTimesOMSCost,0.00),0.00)) as Calculation

FROM

MyTable

Where

(CONVERT(date, GETDATE()) BETWEEN EventStartDate AND EventEndDate)

Group By

ForcastUnitsTimesOMSCost

The building has a guard on duty at the building entrance 24x7. Everyone has to use their card to enter the building through a turnstile, and everyone has to...

This should do it:

select TodayAt4am = dateadd(dd,datediff(dd,0,getdate()),'04:00:00')

Results:

TodayAt4am

-----------------------

2013-10-11 04:00:00.000

AndrewSQLDBA (10/2/2013)

---

Thanks Michael

Those other options are what SSMS put there. I used the "wizard" and then did the "script to new window".

I did a test, but the size of the...

That code will create a full backup that includes all filegroups.

You don't need the NOFORMAT, SKIP, NOREWIND, and NOUNLOAD options. They only apply to tape.

You should probably leave out...

Convert them to datetime values and use the DATEDIFF function to find the difference.

SQL08Kid (9/27/2013)

---

Thanks Gail for the response.

I don't ever deal with licensing so I don't know much about it....

With that being said, are the only two options for SQL Server 2012...

The only new license option for SQL Server 2012 Enterprise Edition is Core-based. Server/CAL is not an option for new 2012 Enterprise Edition licenses.

There is an option for Server/CAL...

Jeff Moden (9/26/2013)

---

Michael Valentine Jones (9/26/2013)

---

Jeff Moden (9/26/2013)

---

Although...

Jeff Moden (9/26/2013)

---

Although I certainly prefer you method,...

paul.j.kemna (9/25/2013)

---

We don't own the calendar table, so that is not really an option.

Anyway, my boss and I came up with this code as an option as well:

DECLARE @someDate as...

You have to execute the command once for each user, but you can have multiple commands in your script.

Create a table that holds the DST start datetime and end datetime for each timezone you need to convert, and do a lookup against that table to determine if the...

bugg (9/16/2013)

---

Hi All,

I need to create an attribute table for say a product. Each of the attributes for a product can have have different fixed 'look-up' types.

My question is do...