Edit: completely misunderstood the question. Where's the coffee?

Can't you ask your boss?

The reason I'm asking is because - if (s)he isn't aware that your script can't be shaped into a view, (s)he probably isn't aware that...

dhananjay.nagarkar (2/4/2014)

---

I have date field named "[Latest Filled Date]" - format smalltimedate.

I'm trying to do-If the "[Latest Filled Date]" equals the previous weeks Monday - Saturday dates...

crazy_new (2/5/2014)

---

My boss wants this script as a view, and I told him you cant put this in a view, just wanted to make sure im right.

Thanks for your help...

Another way:

,row_number() over (

partition by AD.UnitNumber,AD.AccountNumber order by AD.VisitID) as [Index]

,COUNT(*) over (partition by AD.UnitNumber,AD.AccountNumber) as [MaxIndex]

filter on [Index] = 1 OR [Index] = [MaxIndex]

What's going to consume the result set from the view? How will it handle an unknown number of columns with some unknown names? Can't you concatenate the variable address elements...

Nice work, Helmi. The best possible outcome here is when the OP - that's you - figures out the problem themselves given a few pointers.

You may wish to examine your...

The BETWEEN range ends at 'V'. If you have a vendor with exactly this value then it will be included. Vendors called 'V' + anything else will be excluded because...

Eliminating rows with a null value could play havoc with your [Status] values. Try this to see what I mean:

selectdistinct

ph.ProdHeaderOrdNr,

ph.PartCode,

ph.[Description],

ph.Qty,

[Status] = (

select max(psl.ProdStatusCode)

from ProdStatusLog psl

where psl.ProdHeaderDossierCode = ph.ProdHeaderDossierCode),

[Uitgifte] =...

Here's your query rewritten to replace old-style joins and with table aliases to reduce noise:

selectdistinct

ph.ProdHeaderOrdNr,

ph.PartCode,

ph.[Description],

ph.Qty,

[Status] = (

select max(psl.ProdStatusCode)

from ProdStatusLog psl

where psl.ProdHeaderDossierCode = ph.ProdHeaderDossierCode),

[Uitgifte] = (

select max(psl.LastUpdatedOn)

from ProdStatusLog psl

where psl.ProdHeaderDossierCode...

L' Eomot Inversé (2/4/2014)

---

Grant Fritchey (2/3/2014)

---

Please, please, please, no piling on, but I'm curious what you guys think about this: Unreasonable Defaults. I think most of the fundamental info is...

Ouch! I remember those...

What datatype is the input column? Remove the CAST, it's unnecessary overhead.

Here's a pure TSQL method to compare with Lowell's string-concatenation method.

;WITH Rates AS (SELECT worker_id, rate_code, rate_count = COUNT(*) OVER(PARTITION BY worker_id)

FROM #worker_rate r)

SELECT

rate_group = DENSE_RANK() OVER(ORDER BY...

Something so timecritical should not be subject to the...