Thanks

silly me

DECLARE @test-2 VARCHAR(8) '**** Change ****

Thanks

Has 2019 had a few 'service packs' which make the code bugged out and stable?

Never like to be the first.

When I tried to up date 2008 r2 to 2014/2016 a...

That's my point, I don't have that menu item?

see attached item

Thanks... and perfect...:cool:

Thanks

Will work with the above!

Thanks...

IF OBJECT_ID('tempdb..#priceData') IS NOT NULL DROP TABLE #priceData;

create table #priceData(

[ID] [int] NULL,

[Symbol] [varchar](50) NULL,

[quote_date] [datetime] NULL,

[close_price] [decimal](18, 2) NULL

);

INSERT INTO #priceData (ID, symbol, quote_date, close_price) VALUES (8,'AAPL','20091026', 555.75)

INSERT INTO #priceData...

Sorry YYYYWW not YYYYMM

thanks for reponses

Thanks for your interest in my problem.

But that does not produce a sequential YYYYMM sequence!

Any other idea

Thanks will learn more on this OUTER APPLY

Thanks Lutz, will play with that !

Livingston SQL ; Dont understand your last post!

my go..

DECLARE @CurrentDate DATETIME

SET @CurrentDate = GETUTCDATE()

IF OBJECT_ID('tempdb..#tempData') IS NOT NULL DROP TABLE #tempData;

CREATE TABLE #tempData(

Code INT,

Subs_End DATETIME

)

INSERT INTO #tempData VALUES (102,'2012-02-12 00:00:00.000')

INSERT INTO...

Sir, I am an old fart working on a private project...just needed a little help !

Thanks 🙂

Thanks, but that stuff hurts my head...:w00t:

Any one else wishing help out much appreciated...