WHat I need is...

alter Procedure [dbo].[getlist]

as

begin

select distinct

O.empid,

Case O.empid when...

For the same store proc how can I display 'Yes' for column O.empid , if the following query has any rows

SELECT

ih.

when i use suser_sname() am getting the application user name which is a role for application, i need the end users name who performs the delete/update?

so when am trying to keep track of changes on the tables, I want to know

deleted row, when updated, who updated. from these 3 I can find the 1st 2...

so do i need to create nearly 100 identical tables to audit them.

empid is a PK in parent table and FK in child table.

Ok..I think I ahve to use CASCADE option on delete

pls check the update in my store proc

I dont have any type of dedicated networks as of now, can FTP work for this job. and how about VPN?

still am geting error at ' + '

Any Help

There is no difference.

When I exec my SP it expects those output parameters, y?

Thanks a lot..Finally I got it done.

yeah i did even that..but same problem again.

not getting any syntax error but cudnt process the flow

getting error

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near '+'.