3/3/2010 3:30:08 PM
v1.4524 - Access violation at address 00DAD30E in module 'axVDM.ocx'. Read of address 00000044
Continue or restart VDM - This error was queued for analysis, we apologize.
select [GUID] from WebSites where [ID]=488
select [GUID] from WebSites where [ID]=488

2/26/2010 6:50:42 PM
v1.4524 - Access violation at address 00E2F32E in module 'axVDM.ocx'. Read of address 00000000
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 Sum(Total*dbo.inPeriod(Date_Locked,1,0)) as [V_00],Sum(Total*dbo.inPeriod(Date_Locked
select top 101 Sum(Total*dbo.inPeriod(Date_Locked,1,0)) as [V_00],Sum(Total*dbo.inPeriod(Date_Locked,2,0)) as [V_01],Sum(Total*dbo.inPeriod(Date_Locked,3,0)) as [V_02],Sum(Total*dbo.inPeriod(Date_Locked,4,0)) as [V_03],Sum(Total*dbo.inPeriod(Date_Locked,5,0)) as [V_04],Sum(Total*dbo.inPeriod(Date_Locked,6,0)) as [V_05],Sum(Total*dbo.inPeriod(Date_Locked,7,0)) as [V_06],Sum(Total*dbo.inPeriod(Date_Locked,8,0)) as [V_07],Sum(Total*dbo.inPeriod(Date_Locked,9,0)) as [V_08],Sum(Total*dbo.inPeriod(Date_Locked,10,0)) as [V_09],Sum(Total*dbo.inPeriod(Date_Locked,11,0)) as [V_10],Sum(Total*dbo.inPeriod(Date_Locked,12,0)) as [V_11],Sum(Total*dbo.inPeriod(Date_Locked,0,0)) as [V_12],Sum(Total*dbo.inPeriod(Date_Locked,-12,0)) as [V_13],Sum(Total*dbo.inPeriod(Date_Locked,1,-1)) as [V_14],Sum(Total*dbo.inPeriod(Date_Locked,2,-1)) as [V_15],Sum(Total*dbo.inPeriod(Date_Locked,3,-1)) as [V_16],Sum(Total*dbo.inPeriod(Date_Locked,4,-1)) as [V_17],Sum(Total*dbo.inPeriod(Date_Locked,5,-1)) as [V_18],Sum(Total*dbo.inPeriod(Date_Locked,6,-1)) as [V_19],Sum(Total*dbo.inPeriod(Date_Locked,7,-1)) as [V_20],Sum(Total*dbo.inPeriod(Date_Locked,8,-1)) as [V_21],Sum(Total*dbo.inPeriod(Date_Locked,9,-1)) as [V_22],Sum(Total*dbo.inPeriod(Date_Locked,10,-1)) as [V_23],Sum(Total*dbo.inPeriod(Date_Locked,11,-1)) as [V_24],Sum(Total*dbo.inPeriod(Date_Locked,12,-1)) as [V_25],Sum(Total*dbo.inPeriod(Date_Locked,0,-1)) as [V_26],Sum(Total*dbo.inPeriod(Date_Locked,-12,-1)) as [V_27],Sum(Total*dbo.inPeriod(Date_Locked,1,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,1,-1)),0)*100-100 as [V_28],Sum(Total*dbo.inPeriod(Date_Locked,2,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,2,-1)),0)*100-100 as [V_29],Sum(Total*dbo.inPeriod(Date_Locked,3,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,3,-1)),0)*100-100 as [V_30],Sum(Total*dbo.inPeriod(Date_Locked,4,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,4,-1)),0)*100-100 as [V_31],Sum(Total*dbo.inPeriod(Date_Locked,5,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,5,-1)),0)*100-100 as [V_32],Sum(Total*dbo.inPeriod(Date_Locked,6,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,6,-1)),0)*100-100 as [V_33],Sum(Total*dbo.inPeriod(Date_Locked,7,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,7,-1)),0)*100-100 as [V_34],Sum(Total*dbo.inPeriod(Date_Locked,8,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,8,-1)),0)*100-100 as [V_35],Sum(Total*dbo.inPeriod(Date_Locked,9,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,9,-1)),0)*100-100 as [V_36],Sum(Total*dbo.inPeriod(Date_Locked,10,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,10,-1)),0)*100-100 as [V_37],Sum(Total*dbo.inPeriod(Date_Locked,11,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,11,-1)),0)*100-100 as [V_38],Sum(Total*dbo.inPeriod(Date_Locked,12,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,12,-1)),0)*100-100 as [V_39],Sum(Total*dbo.inPeriod(Date_Locked,0,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,0,-1)),0)*100-100 as [V_40],Sum(Total*dbo.inPeriod(Date_Locked,-12,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,-12,-1)),0)*100-100 as [V_41],Sum(Quantity*dbo.inPeriod(Date_Locked,1,0)) as [V_50],Sum(Quantity*dbo.inPeriod(Date_Locked,2,0)) as [V_51],Sum(Quantity*dbo.inPeriod(Date_Locked,3,0)) as [V_52],Sum(Quantity*dbo.inPeriod(Date_Locked,4,0)) as [V_53],Sum(Quantity*dbo.inPeriod(Date_Locked,5,0)) as [V_54],Sum(Quantity*dbo.inPeriod(Date_Locked,6,0)) as [V_55],Sum(Quantity*dbo.inPeriod(Date_Locked,7,0)) as [V_56],Sum(Quantity*dbo.inPeriod(Date_Locked,8,0)) as [V_57],Sum(Quantity*dbo.inPeriod(Date_Locked,9,0)) as [V_58],Sum(Quantity*dbo.inPeriod(Date_Locked,10,0)) as [V_59],Sum(Quantity*dbo.inPeriod(Date_Locked,11,0)) as [V_60],Sum(Quantity*dbo.inPeriod(Date_Locked,12,0)) as [V_61],Sum(Quantity*dbo.inPeriod(Date_Locked,0,0)) as [V_62],Sum(Quantity*dbo.inPeriod(Date_Locked,-12,0)) as [V_63],Sum(Quantity*dbo.inPeriod(Date_Locked,1,-1)) as [V_64],Sum(Quantity*dbo.inPeriod(Date_Locked,2,-1)) as [V_65],Sum(Quantity*dbo.inPeriod(Date_Locked,3,-1)) as [V_66],Sum(Quantity*dbo.inPeriod(Date_Locked,4,-1)) as [V_67],Sum(Quantity*dbo.inPeriod(Date_Locked,5,-1)) as [V_68],Sum(Quantity*dbo.inPeriod(Date_Locked,6,-1)) as [V_69],Sum(Quantity*dbo.inPeriod(Date_Locked,7,-1)) as [V_70],Sum(Quantity*dbo.inPeriod(Date_Locked,8,-1)) as [V_71],Sum(Quantity*dbo.inPeriod(Date_Locked,9,-1)) as [V_72],Sum(Quantity*dbo.inPeriod(Date_Locked,10,-1)) as [V_73],Sum(Quantity*dbo.inPeriod(Date_Locked,11,-1)) as [V_74],Sum(Quantity*dbo.inPeriod(Date_Locked,12,-1)) as [V_75],Sum(Quantity*dbo.inPeriod(Date_Locked,0,-1)) as [V_76],Sum(Quantity*dbo.inPeriod(Date_Locked,-12,-1)) as [V_77],Sum(Quantity*dbo.inPeriod(Date_Locked,1,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,1,-1)),0)*100-100 as [V_78],Sum(Quantity*dbo.inPeriod(Date_Locked,2,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,2,-1)),0)*100-100 as [V_79],Sum(Quantity*dbo.inPeriod(Date_Locked,3,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,3,-1)),0)*100-100 as [V_80],Sum(Quantity*dbo.inPeriod(Date_Locked,4,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,4,-1)),0)*100-100 as [V_81],Sum(Quantity*dbo.inPeriod(Date_Locked,5,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,5,-1)),0)*100-100 as [V_82],Sum(Quantity*dbo.inPeriod(Date_Locked,6,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,6,-1)),0)*100-100 as [V_83],Sum(Quantity*dbo.inPeriod(Date_Locked,7,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,7,-1)),0)*100-100 as [V_84],Sum(Quantity*dbo.inPeriod(Date_Locked,8,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,8,-1)),0)*100-100 as [V_85],Sum(Quantity*dbo.inPeriod(Date_Locked,9,0)) /NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,9,-1)),0)*100-100 as [V_86],Sum(Quantity*dbo.inPeriod(Date_Locked,10,0))/NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,10,-1)),0)*100-100 as [V_87],Sum(Quantity*dbo.inPeriod(Date_Locked,11,0))/NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,11,-1)),0)*100-100 as [V_88],Sum(Quantity*dbo.inPeriod(Date_Locked,12,0))/NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,12,-1)),0)*100-100 as [V_89],Sum(Quantity*dbo.inPeriod(Date_Locked,0,0))/NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,0,-1)),0)*100-100 as [V_90],Sum(Quantity*dbo.inPeriod(Date_Locked,-12,0))/NullIF(Sum(Quantity*dbo.inPeriod(Date_Locked,-12,-1)),0)*100-100 as [V_91] from OrderItems where (([Resource_ID]=1981)) AND ([Type] IN ('Sale','Manufacturing') AND Year(Date_Locked)>=Year(GetDate())-1)

2/26/2010 6:48:06 PM
v1.4524 - Access violation at address 00E2F32E in module 'axVDM.ocx'. Read of address 00000000
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 Sum(Total*dbo.inPeriod(Date_Locked,1,0)) as [V_00],Sum(Total*dbo.inPeriod(Date_Locked
select top 101 Sum(Total*dbo.inPeriod(Date_Locked,1,0)) as [V_00],Sum(Total*dbo.inPeriod(Date_Locked,2,0)) as [V_01],Sum(Total*dbo.inPeriod(Date_Locked,3,0)) as [V_02],Sum(Total*dbo.inPeriod(Date_Locked,4,0)) as [V_03],Sum(Total*dbo.inPeriod(Date_Locked,5,0)) as [V_04],Sum(Total*dbo.inPeriod(Date_Locked,6,0)) as [V_05],Sum(Total*dbo.inPeriod(Date_Locked,7,0)) as [V_06],Sum(Total*dbo.inPeriod(Date_Locked,8,0)) as [V_07],Sum(Total*dbo.inPeriod(Date_Locked,9,0)) as [V_08],Sum(Total*dbo.inPeriod(Date_Locked,10,0)) as [V_09],Sum(Total*dbo.inPeriod(Date_Locked,11,0)) as [V_10],Sum(Total*dbo.inPeriod(Date_Locked,12,0)) as [V_11],Sum(Total*dbo.inPeriod(Date_Locked,0,0)) as [V_12],Sum(Total*dbo.inPeriod(Date_Locked,-12,0)) as [V_13],Sum(Total*dbo.inPeriod(Date_Locked,1,-1)) as [V_14],Sum(Total*dbo.inPeriod(Date_Locked,2,-1)) as [V_15],Sum(Total*dbo.inPeriod(Date_Locked,3,-1)) as [V_16],Sum(Total*dbo.inPeriod(Date_Locked,4,-1)) as [V_17],Sum(Total*dbo.inPeriod(Date_Locked,5,-1)) as [V_18],Sum(Total*dbo.inPeriod(Date_Locked,6,-1)) as [V_19],Sum(Total*dbo.inPeriod(Date_Locked,7,-1)) as [V_20],Sum(Total*dbo.inPeriod(Date_Locked,8,-1)) as [V_21],Sum(Total*dbo.inPeriod(Date_Locked,9,-1)) as [V_22],Sum(Total*dbo.inPeriod(Date_Locked,10,-1)) as [V_23],Sum(Total*dbo.inPeriod(Date_Locked,11,-1)) as [V_24],Sum(Total*dbo.inPeriod(Date_Locked,12,-1)) as [V_25],Sum(Total*dbo.inPeriod(Date_Locked,0,-1)) as [V_26],Sum(Total*dbo.inPeriod(Date_Locked,-12,-1)) as [V_27],Sum(Total*dbo.inPeriod(Date_Locked,1,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,1,-1)),0)*100-100 as [V_28],Sum(Total*dbo.inPeriod(Date_Locked,2,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,2,-1)),0)*100-100 as [V_29],Sum(Total*dbo.inPeriod(Date_Locked,3,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,3,-1)),0)*100-100 as [V_30],Sum(Total*dbo.inPeriod(Date_Locked,4,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,4,-1)),0)*100-100 as [V_31],Sum(Total*dbo.inPeriod(Date_Locked,5,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,5,-1)),0)*100-100 as [V_32],Sum(Total*dbo.inPeriod(Date_Locked,6,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,6,-1)),0)*100-100 as [V_33],Sum(Total*dbo.inPeriod(Date_Locked,7,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,7,-1)),0)*100-100 as [V_34],Sum(Total*dbo.inPeriod(Date_Locked,8,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,8,-1)),0)*100-100 as [V_35],Sum(Total*dbo.inPeriod(Date_Locked,9,0)) /NullIF(Sum(Total*dbo.inPeriod(Date_Locked,9,-1)),0)*100-100 as [V_36],Sum(Total*dbo.inPeriod(Date_Locked,10,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,10,-1)),0)*100-100 as [V_37],Sum(Total*dbo.inPeriod(Date_Locked,11,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,11,-1)),0)*100-100 as [V_38],Sum(Total*dbo.inPeriod(Date_Locked,12,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,12,-1)),0)*100-100 as [V_39],Sum(Total*dbo.inPeriod(Date_Locked,0,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,0,-1)),0)*100-100 as [V_40],Sum(Total*dbo.inPeriod(Date_Locked,-12,0))/NullIF(Sum(Total*dbo.inPeriod(Date_Locked,-12,-1)),0)*100-100 as [V_41],Sum