Hi,

I want to concatinate a BillDate separated by comma ALLOc_REF and Entity group wise.

FOR Eg.

Table structure:

ENTITY ALLOC_REF BILLDATE

AB04/01/2010

AB04/02/2010

BB05/01/2010

O/P:

A B 04/01/2010,04/02/2010

B B 05/01/2010

I have using 3 No. table in this stored procedure.

Mpart

Stock

storage location

but mpart and stock table more important .

//Paramenter Value

exec SP_StockReport @fromdate='04/01/2009',@todate='03/31/2010',@divcode='DV003',@loccode='Am003',@clicode='neel',@fiyear='2009',@where1='

and stock.docdate Between ''04/01/2009'' And ''03/31/2010'' And...

I have sending My Stored Procedure Plz give a proper solution how to solve this problem..

create PROCEDURE [dbo].[SP_StockReport]

(

@fromdate varchar(10),

@todate varchar(10),

@divcode varchar(5),

@loccode varchar(5),

@clicode varchar(5),

@fiyear varchar(4),

@where1 varchar(200),

@datediff varchar(10),

@userid varchar(200)

)

AS

BEGIN

-- SET...

How to use trigger ? i want to store User Interface User

Suppose I Want Maintain All Trans. Information In My DataBase .For Eg. A User Insert a Record In a Table I Want To Store Which user insert a record...

what is audit locking? how to handle in sqlserver 2005?

i want to store ip address in a table when user login and also store form id

how to send paramenter in my trigger

Soory Sir,

Actualy i m developing one web application When user login in my web application i do anything i want to sotre in a table for eg, he insert...

i m seding you complete sp . i m using a cursor but execution is very slow then plz send me another option to fetch the record.

ALTER PROCEDURE [dbo].[SP_GLAcoountWise]

(

@fromdate...

i m not using tempory table . i am fetch the data and posted another table. using cursor that time some calcution doing in stored procedure and insert into another...

THANKS.............!:):)

how?