I'm curious about your setup for...

I'm curious about your setup for your keyboard. ...

... if working knowledge of SQL Server and programming skills in T-SQL were gasoline, they (most people... there were just a few exceptions) wouldn't have enough to run a...

I worked for a decade for one company that made finger pointing an art form.  This was my first real career job at the time, so I thought this was...

It's fascinating to read through and see how different people/companies deal with this kind of issue.  As a supervisor, I have a corporate credit card for discretionary expenses but members...

I think context and audience matter when you are talking about innovation.  Sure, I don't think a customer or end-user cares about any fancy new changes made to the back...

You're welcome.

One final tip before I forget is you should alias your table names.  This will make it much easier to tell which columns belong to which tables.  It will...

Try something like this but be mindful that you can still get multiple prices if the most recent date has more than one row per item.

SELECT
x.IMA_ItemID,
x.IMA_Price,
x.PRD_UnitSalesPrice,
x.PRM_StartDate

FROM
(
SELECT
IMA_ItemID,
IMA_Price,
PRD_UnitSalesPrice,
PRM_StartDate,
RANK() OVER...

Thanks for the clarification.  Are you essentially looking for the most recent price of an item?  I'm just wondering because you seem to have different sales prices for the same...

• This reply was modified 1 year, 6 months ago by  Y.B..
• This reply was modified 1 year, 6 months ago by  Y.B..

I wondered about something similar ratbak but since there wasn't any additional information I just stated the obvious issue.  Did they want all 'Active' items amongst those that shared the...

Instead of quoting the column names - I would recommend changing the names to something else.  For example:

plan_name instead of [Plan]

total_count instead of [Count]

total_amount_dollars instead of [Amount ($)]

Makes...

You have two WHERE statements which is an issue.

You could do something like this unless you need it as a view.

DECLARE @somedate DATE
SET @somedate = (SELECT MAX(PRM_StartDate)...

• This reply was modified 1 year, 6 months ago by  Y.B..

Amen

In the old days my hearing aids had an on off switch.  These days...

Another of my less popular viewpoints that I used in meetings and design sessions late in my career was:  'Do we really NEED to do this sh!t?".  This has...

I think it really comes down to the actual intent going forward.  If this is truly a query that will be run a couple of times then you have several...