Yes, you are correct on GUI side and I think I have a way to handle it. The Query you provided is spot on.

I have broken the query out so...

• This reply was modified 3 years, 2 months ago by  netguykb.

I hear ya but I still need to query the DB to know how many slots are available for each time session. The problem with the above code assumes there...

• This reply was modified 3 years, 2 months ago by  netguykb.

@anthony.green This is exactly what needs to be done. THANK YOU!!

Yes I should have inserted code rather than used the Blockquote.

I use some other forums and they do...

• This reply was modified 4 years, 2 months ago by  netguykb.

Ok, First things first - My question is not clear or maybe somewhat clear. Second Forgot about holidays there is no business need for adjusting for them, "TRUST ME" I...

I think I may have figured an easy way to do this. Since the interface controls the availability of the tool then a case statement can be created to drive...

The schema would be based on the resulting data found in the <METAR></METAR> Tag. Sky_Condition gets a little tricky as the results could be one record or many records, so...

• This reply was modified 4 years, 5 months ago by  netguykb.
• This reply was modified 4 years, 5 months ago by  netguykb.

Looks like I figured it out again. OK, Sorry folks Look like I need to spend more time on my own rather than quick to ask a question here. Don't...

Sorry figured it out. I guess I needed to perform the substring in the JOIN clause DUH.

SELECT DISTINCT A.[Organization Name], 
SUBSTRING(A.[Composite Med Procedure ID],4,5) [Unique CPT],
B.DESCRIPTION

FROM dbo.CCN_837...

That'll do it. I have seen so many examples of doing this but with multiple rows and rolling up rows into still other rows. Blah Blah. THANK YOU !!!!

Thank you I have asked for help and have an answer that I thought I would post:

---------------
-- SQL Method --
----------------
SELECT D.competency_name
  ,D.competency_id

Great work - you were correct in your logic. NOW My next step is to update those records that = No. For those that = no then we would take...

Hey guys thanks again for your help, I definitely have some cob-webs in the old SQL world. Last time I did the stuff I was using DTS. LOL

So If the following is ran:

SELECT *
--SET B.Archive = 'Y'
FROM (
  SELECT *,
   ROW_NUMBER() OVER(PARTITION BY ProductDesc ORDER BY BatchID...