Here's my take on this. I listed the break and lunch time as separate columns but would change the final code to instead subtract from the working minutes in...

As a first try, look at that instance, "Reports", "Standard Reports", "Total CPU Time" and "Average CPU Time".

On rebooting, it depends. If you have a lot of non-SQL stuff...

Not really any easy way to get on-going accurate data at the partition level.

View sys.dm_db_index_operational_stats might help, particularly if the index/partition is very busy and thus (almost) never leaves the...

Robert Mark (10/30/2014)

---

I don't know how anyone using an application and seeing a NULL value on the screen would equate the NULL value to anything other than a zero. ...

Starwatcher (10/30/2014)

---

kenambrose (10/30/2014)

---

very simple solution to all the nonsense.

MAKE ALL COLUMNS NOT NULLABLE.

If you can't figure out how to design a schema where that works for your business requirements,...

ZZartin (10/30/2014)

---

Robert Mark (10/30/2014)

---

I don't know how anyone using an application and seeing a NULL value on the screen would equate the NULL value to anything other than a zero....

It sounds like you need something along these lines:

ALTER TRIGGER [dbo].[trU]

ON [dbo].[tblEvent]

AFTER INSERT

AS

SET NOCOUNT ON;

UPDATE c

SET avbl= CASE

WHEN i.[Desc]...

D'OH, quite right, sorry. "13" days should be added, not 19. ...

Yes, "Valued Member", that is basically correct, you do not use parameters like that in a trigger in SQL Server.

Do you really need/want two separate scripts? You can do this in one (complex) date computation:

SELECT

*,

DATEADD(DAY, DATEDIFF(DAY, 5, DATEADD(DAY, 19, DATEADD(MONTH,...

The trigger is firing. You must keep in mind that SQL Server only fires a trigger once per statement, no matter how many rows are INSERTed (UPDATEd or DELETEd).

Therefore,...

To check for anything other than only digits (0 thru 9), use:

NOT LIKE '%[^0-9]%'

for example:

SELECT

TextID,

CASE WHEN TextID NOT LIKE '%[^0-9]%' THEN 'OK'...

Everyone be aware that this is a school assignment; reposted perhaps to avoid disclosing that fact and get a "complete solution" instead of just helpful tips.

dariuslearn (10/23/2014)

---

ScottPletcher (10/23/2014)

---

Sorry [that did seem rather obscure for a starting class on SQL].

In the SELECT list, after the original column name or expression, you can add "AS new_column_name", and...

Sorry [that did seem rather obscure for a starting class on SQL].

In the SELECT list, after the original column name or expression, you can add "AS new_column_name", and the query...