---------------------------[Begin Beowulf Error Message]---------------------------------
FIXME! Error Executing Beowulf Tag: FIXME: Exception raised executing SQL call The Exception Encountered was [INTERSOLV][ODBC SQL Server driver][SQL Server]game_event_stats not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
-----------------------
Tag Location:
startRow: 1059 startCol: 3
endRow: 1064 endCol: 55
-------------
-----------------------------[End Beowulf Error Message]---------------------------------
---------------------------[Begin Beowulf Error Message]---------------------------------
FIXME! Error Executing Beowulf Tag: The Offending SQL was:
select t.abbreviation,
case when ges.period=1 then '1st Qtr '
when ges.period=2 then '2nd Qtr '
when ges.period=3 then '3rd Qtr '
when ges.period=4 then '4th Qtr '
when ges.period=5 then '1st OT '
when ges.period=6 then '2nd OT '
when ges.period=7 then '3rd OT '
when ges.period=8 then '4th OT '
else '' end ||
rtrim(convert(char,convert(int,ge.pc_time/600))) || ':' || right( replicate('0', 2) + convert(varchar, rtrim(convert(char,convert(int,ge.pc_time-(convert(int,pc_time/600)*600))/10))), 2)
as timeFoul,
isnull(p.nickname, p.First_Name) + ' '+ p.Last_Name as full_name
from game_Event ge,game_event_stats ges, game g, vw_web_team_season t, person p
where ge.game_Id = '2040700303' and
ge.event_msg_type = 6 and ges.stat_type_id = 18 and ges.team_id <> null and
ge.game_Id = ges.game_Id and ge.event_num = ges.event_num
and g.game_Id = ge.Game_id
and p.Person_id = ges.Person_id
and substring(g.Season,2,4) = t.season
and ges.team_id = t.team_id
order by ges.game_id,ges.team_id,timeFoul
-----------------------
Tag Location:
startRow: 1059 startCol: 3
endRow: 1064 endCol: 55
-------------
-----------------------------[End Beowulf Error Message]---------------------------------
---------------------------[Begin Beowulf Error Message]---------------------------------
FIXME! Error Executing Beowulf Tag: BW_LOOP can't find the dataset named TechnicalFouls
-----------------------
Tag Location:
startRow: 1103 startCol: 3
endRow: 1115 endCol: 13
-------------
-----------------------------[End Beowulf Error Message]---------------------------------
---------------------------[Begin Beowulf Error Message]---------------------------------
FIXME! Error Executing Beowulf Tag: FIXME: Exception raised executing SQL call The Exception Encountered was [INTERSOLV][ODBC SQL Server driver][SQL Server]game_event_stats not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
-----------------------
Tag Location:
startRow: 1113 startCol: 3
endRow: 1118 endCol: 55
-------------
-----------------------------[End Beowulf Error Message]---------------------------------
---------------------------[Begin Beowulf Error Message]---------------------------------
FIXME! Error Executing Beowulf Tag: The Offending SQL was:
select t.abbreviation,
case when ges.period=1 then '1st Qtr '
when ges.period=2 then '2nd Qtr '
when ges.period=3 then '3rd Qtr '
when ges.period=4 then '4th Qtr '
when ges.period=5 then '1st OT '
when ges.period=6 then '2nd OT '
when ges.period=7 then '3rd OT '
when ges.period=8 then '4th OT '
else '' end ||
rtrim(convert(char,convert(int,ge.pc_time/600))) || ':' || right( replicate('0', 2) + convert(varchar, rtrim(convert(char,convert(int,ge.pc_time-(convert(int,pc_time/600)*600))/10))), 2)
as timeFoul,
isnull(p.nickname, p.First_Name) + ' '+ p.Last_Name as full_name
from game_Event ge,game_event_stats ges, game g, vw_web_team_season t, person p
where ge.game_Id = '2040700303' and
ge.event_msg_type = 6 and ges.stat_type_id = 18 and ges.team_id <> null and
ge.game_Id = ges.game_Id and ge.event_num = ges.event_num
and g.game_Id = ge.Game_id
and p.Person_id = ges.Person_id
and substring(g.Season,2,4) = t.season
and ges.team_id = t.team_id
order by ges.game_id,ges.team_id,timeFoul
-----------------------
Tag Location:
startRow: 1113 startCol: 3
endRow: 1118 endCol: 55
-------------
-----------------------------[End Beowulf Error Message]---------------------------------
