Viewing 6 posts - 1 through 6 (of 6 total)
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...
February 3, 2016 at 5:16 pm
team W L Ov Un favW favL _1to3 _1to31 _3hto7 _3hto71 _7hto10 _7hto101 _7hto102 _7hto103 _10h _10h1 PtsFor PtsVs
atl 5 5 4 6 5 5 2 2 0 1 2 2 2 2 1 0 103 97
bos 3 6 8 1 3 4 1 3 1 0 1 1 1 1 0 0 107 105
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...
February 2, 2016 at 12:16 am
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]...
February 1, 2016 at 10:09 pm
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...
February 1, 2016 at 9:52 pm
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...
June 27, 2015 at 11:16 am
Thanks, that rocks :-D:-D
June 16, 2015 at 2:36 pm
Viewing 6 posts - 1 through 6 (of 6 total)