USE [VAE_ACCOUNTING] GO /****** Object: StoredProcedure [dbo].[up_KotaDetay] Script Date: 08/27/2009 17:15:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[up_KotaDetay] @USERNAME varchar(50), @BASLANGICTARIHI datetime, @BITISTARIHI datetime as begin select USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME from ACCOUNTING20081129 where username =@USERNAME and convert(varchar(8),TIME_STAMP,112) between @BASLANGICTARIHI and @BITISTARIHI order by TIME_STAMP end
