Disclaimer: I'm not an expert, but this worked for me... I didn't create mad dynamic SQL, but...

("Ingredient" is just some table I had in a database... nothing special.)  But  I...

You can do this with text functions like CHARINDEX, LEFT, RIGHT.

What have you tried?

Google-fu not working? See this page...

use tempdb;
go
DECLARE @MyMachine NVARCHAR(128);
SELECT @MyMachine = CAST(SERVERPROPERTY('MachineName') AS NVARCHAR(128))
PRINT @MyMachine + ' is a piece of junk';

LOL. That's exactly how I feel about touchscreen radio controls. Are those things designed to kill me? I thought the whole idea was to be able to use the radio...

T-SQL is pretty big (there are lots of functions etc). One way to learn it is to break it up into chunks. So you get a database and start asking...

That's the way education is though. when I was in undergrad, one of my professors said something like "You thought I was here to teach you. That's where you're mistaken:...

It's okay to be new. But please post what you tried in order to solve the problem. one thing it does is it forces you to recreate the problem for...

I'd submit a tested query, but I don't have any data to test it on... so, all I can offer is a vague generality.

If you use CROSS APPLY, you can...

I'm not saying that Joe isn't insanely smart. Not at all. He absolutely is. He's just ... (What's the right word??!!) .. inflexible?  Kinda like an Aspie with Attitude?  Perhaps...

Wow. Just wow.

I've heard of "biting the hand that feeds me" but of all the hands to bite, that's perhaps the worst one.

Don't you got no home training??

I didn't have a problem with it. If you want condescending, you have to read some Joe Celko posts.

maybe I'm too tired or too lazy to figure out what you wrote, but why not just use a window and order the rows in the window by date descending,...

• This reply was modified 2 years, 7 months ago by pietlinden.

So create a temporary table and insert the records there, and then create the cursor based on that?

(I guess ideally you'd create the temporary objects inside your stored procedure, and...

If the index is created, you should be able to find it in the sys.indexes table

sys.indexes (Transact-SQL) - SQL Server | Microsoft Learn

Can you use the upsizing wizard?

Move Access data to a SQL Server database by using the Upsizing Wizard - Microsoft Support