My guess is it's just some quirk with the output clause and ROW_NUMBER(), because the expected row gets kept even when the OUTPUT seems to indicate otherwise:

declare @t table (a...

If possible, you want to specify contiguous clustered key ranges on the main/larger table to UPDATE. You only want to each affected block of that table one time.

If you (almost) always provide created_date in the WHERE clause when querying that table, change the clustered index on the table to be on created_date. That will 100% solve...

Those queries themselves are relatively trivial. You'll sort that out quickly.

But the clustering index is the most critical overall factor in performance and two tables need changed. Without...

FWIW, sure potentially sounds to me like homework or the equivalent.

I don't know exactly how you want to order the results, but something like this should do what you want:

SELECT

ol.OrdNo, ol.ProdNo, ol.Descr,ol.DPrice, pr.PictNo, pr.NoteNm as DescriptLong,

(ROW_NUMBER() OVER(ORDER BY ol.OrdNo,...

You can use CROSS APPLY to assign alias names to expressions:

select distinct top 100 filedate, transaction_date, duedate,

event_instance, event_name, eventstatus, age,

DaysAged,

coalesce (DaysAged, new, 0) as aged

from...

Best is to always strip non-numeric chars before storing the value. If you have to, store both the original, edited version and a stripped version, or, better yet, a...

Does that user/login also exist in prod? If so, the SIDs of the prod login and the nonprod login are different. If you want the user to work...

GilaMonster (10/29/2014)

---

ISNULL (IntegerColumnName, ReplacementValue)

The data type returned will be the 'larger' of INT and whatever the replacement value is.

btw, SQL doesn't have booleans. It has the bit data type which...

I think this is the general structure you need:

SELECT p.*, d_outer.date

FROM Project p

INNER JOIN Date d ON

p.ProjectID = d.ProjectID

CROSS APPLY (

VALUES(d.Date1),(d.Date2),(D.Date3) /*,...,D.Date20*/

)...

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. ...