Actually, MAX can be used in this case to eliminate NULL values, as well; since NULL represents unknown data, using MAX eliminates NULL, as the MAX is either a NULL...

It seems like you're wanting to copy the non-NULL values for any given SKU into the NULL values, correct? If so, this should do it:

;WITH NullFill(SKU,FillPrice,FillCost,FillSalePrice) AS(

SELECT VendorSKU,MAX(Price)AS Price,...

I'll definitely echo Sarah's thanks to the contributors in the community :-D. I barely knew anything beyond the basics of SQL when I graduated from college and landed my...

Sean Lange (6/30/2014)

---

Andrew Kernodle (6/30/2014)

---

Ah, gotcha! That changes things up a good bit :-).

Access may well be a more workable solution, then, provided the DBAs aren't overwhelmed presently. ...

Ah, gotcha! That changes things up a good bit :-).

Access may well be a more workable solution, then, provided the DBAs aren't overwhelmed presently. Pass-through queries are literally...

Hrm. My previous employer used Access for its operations and later scaled up to SQL Server, with Access remaining as the front end. It worked, but there's some...

Aha! I was fumbling with trying to come up with some sort of aggregate to avoid a double-pass on the table, but I couldn't figure it out. I'll...

May well be a more efficient way to do this, but here's a shot!

select marker from TEMP_A

WHERE val = 'Y'

EXCEPT

SELECT marker FROM TEMP_A

WHERE val = 'N'

Lynn Pettis (6/24/2014)

---

Andrew Kernodle (6/24/2014)

---

I don't believe that table variables are set to be deprecated, though they do have different use cases than, say, a temp table.

Table variables don't have...

I don't believe that table variables are set to be deprecated, though they do have different use cases than, say, a temp table.

Table variables don't have optimization statistics on them,...

I can see something that may work on the sample data; please be sure to test this for correct results in your environment, however!

DECLARE @EmployeeMax int = (SELECT COUNT(EmployeeID) FROM...

That sort of syntax is denoting that a parameterized stored procedure plan was used to run the query; the (@_no_akaun nvarchar(4000)) bit indicates that the procedure was called with a...

Oh, quite so. Fortunately, the business realizes its current means of functionality are unsustainable; the unfortunate part is that they don't want to do anything about it, because it...

GilaMonster (6/17/2014)

---

That's the same as...

GilaMonster (6/17/2014)

---

Andrew Kernodle (6/17/2014)

---

Simple! No job I've ever held so far has allowed me...