Thanks for help, all who applied. I shifted gears on this portion of the app a little bit, if I need to ask more questions (with pertinent info DDL, insert...

teamWLOvUnfavWfavL_1to3_1to31_3hto7_3hto71_7hto10_7hto101_7hto102_7hto103_10h_10h1PtsForPtsVs

atl554655220122221010397

bos3681341310111100107105

here's an NBA example (excuse the formatting) , but here I would also like to include a WINSlast5games column that calculates how many wins a team has in last 5...

CREATE TABLE [dbo].[teamLogs](

[logid] [int] IDENTITY(1,1) NOT NULL,

[gmweek] [varchar](50) NULL,

[gmdate] [datetime2](7) NULL,

[team] [char](10) NOT NULL,

[opp] [char](10) NULL,

[home] [bit] NULL,

[line] [numeric](18, 1) NULL,

[pts] [int] NULL,

[opppts] [int] NULL,

[diffy] [numeric](18, 2) NULL,

[ATS] [int] NULL,

[SU]...

Thanks for help, but the cte would need to just evaluate a teams wins in the past 5 games, and the entire query/stored procedure would need to include the teams...

That's the mystery right now. Using Scope_identity has its merits, but i believe i need to do something to grab the last entered key id (tid) then increment it +1...

Thanks, that rocks :-D:-D