CREATEPROCEDURE[dbo].[Proc_WeiDuTongJi]@codeVARCHAR(9)ASBEGINdeclare@weidu1int,@weidu2int,@weidu3int,@weidu4int,@weidu5intselect@weidu1=0,@weidu2=0,@weidu3=0,@weidu4=0,@weidu5=0--维度1select@weidu1=count(0)from[Table1](nolock)where[code]=@code--维度2select@weidu2=count(0)from[Table2](nolock)where[code]=@code--维度3select@weidu3=count(0)from[Table3](nolock)where[code]=@code--维度4select@weidu4=count(0)from[Table4](nolock)where[code]=@code--维度5select@weidu5=count(0)from[Table5](nolock)where[code]=@codeselect@weidu1as'weidu1',@weidu2as'weidu2',@weidu3as'weidu3',@weidu4as'weidu4',@weidu5as'weidu5'END
GO