So you're actually storing a date value in a datetime column.

The date value for today is '20141003' (ISO format YYYYMMDD), but the datetime value might be '20141003 10:20:00'.

Therefore, when you...

Steve Jones - SSC Editor (10/3/2014)

---

What's a code based license?

AFAIK there's CAL and there's per processor.

These are admin items, however. There's no limit in the code that determines...

Hard to tell without seeing table def and any sample data...

My pot shot: CalDate holds a date value, therewith excluding the current day using the WHERE clause CalDate >=GETDATE()

SQL Server is growing contiuously for two years, again and again. Shortly before it reaches the "mature status" it drops back with a new version.

Then it starts all over again:...

@mcfarlandparkway: I've seen you edited almost all your posts and replaced the original context with some rather meaningless information.

Please note that this is inappropriate on a forum since...

WITH cte AS

-- get all rows with OldValue ='Off' AND NewValue ='On'

-- this will include CustomerID=6

(

SELECT CustomerID, ChangeType, TimeStamp as Start

FROM Source_tbl

WHERE OldValue ='Off' AND NewValue ='On'

)

SELECT * FROM CTE

CROSS...

If this query is wrapped by a stored procedure (which it should...), it's fairly easy: just replace the bad performing code (but you'll violate contracts by doing so...).

If it is...

TheSQLGuru (9/21/2014)

---

I'm not sure why you think Captcha or similar won't help/stop the attacks. Unless someone has come up with a way for the images to be properly recognized,...

I don't think there's a programmable solution out there that will prevent spammers without affecting the "standard users" (captcha would belong to that kind of solutions). The majority of the...

Lynn Pettis (9/20/2014)

---

It looks like there are 3 to 6 posts being added every minute. This looks to be automated to me. Even doing cut and paste I...

I reported two of those and left the forum afterwards.

If there's nothing done...

Depending on the expected result it can either be wrong or right:

SUM(OrderQty) OVER (Partition by productID) as TotalOrderQty,

will return the Quantity for the year 2001 per productID.

But if you're...

ScottPletcher (9/3/2014)

---

...

There are 3rd party solutions that do that, but they are rather expensive. At least one we investigated uses its own "black box" to hold the data --...

One of the issues when using triggers to audit changes is the ability to disable the trigger, apply the change and re-enable the trigger.

Without any audit for DDL changes the...

The trigger automatically changes the LastUpdateDate column to reflect that this row has been modified.

The purpose seems to be obvious...

Usually, the column would be modified using code that actually performs...