Comments by RTK The Limited Edition (Top 17 by date)

Please give me at least one solution without cursor. because i can't understand Mika's solution.

Actually I want to show profile details according their name,class,roll,sec...
searching should made may be either individually use a particular field or more than one field. If you help for one field I'll do another. Please give an example for that above sample query. I don't like cursor. If you can please avoid it.

Then please give the solution query for this

Is it possible without use CURSOR ?

If I use instead of trigger then after insert into statement it's never contain any data.

I can't solve this problem. please help with example

Just think client want this

Thank you for the solution. Another problem is arise that is :

if I Add new column at employee table which contains default value like
create table employee(empid [varchar](10),empname [varchar](50),salary [decimal](18, 2),status [varchar] (100)(default ''))

create table employeeHistory(EffectDate [datetime],empid [varchar](10),empname [varchar](50),salary [decimal](18, 2),status [varchar] (100)(default ''))

create trigger UpdateEmployee on employee
after update AS
begin
declare @empid as [varchar](10)
declare @empname as [varchar](50)
declare @salary as [decimal](18, 2)
declare @status as [varchar](100)

select @empid =d.empid from deleted d
select @empname =d.empname from deleted d
select @salary =d.salary from deleted d


if update(status)
select @status=i.statusfrom deleted i
else
begin
select @status=i.status from deleted i
update [employee]
set status='' where empid=@empid
end

Insert into employeeHistory([EffectDate],[empid],[empname],[salary],[status])
SELECT getdate(), empid, empname, salary,status
FROM deleted
end



Example: emp001 xxxx 10000.00 paid
emp002 yyyy 12000.00 paid
emp003 zzzz 10000.00 paid
emp004 aaaa 15000.00 paid
emp005 bbbb 12000.00 paid
emp006 cccc 12000.00 paid
emp007 pppp 10000.00 paid

update employee set salary =11000.00 where salary =10000.00
after update first updated row set its default value but rest rows don't set it in employee table. Please give me a solution at your earliest.

create table employee(empid [varchar](10),empname [varchar](50),salary [decimal](18, 2))

create table employeeHistory(EffectDate [datetime],empid [varchar](10),empname [varchar](50),salary [decimal](18, 2))

create trigger UpdateEmployee on employee
after update AS
begin
declare @empid as [varchar](10)
declare @empname as [varchar](50)
declare @salary as [decimal](18, 2)

select @empid =d.empid from deleted d
select @empname =d.empname from deleted d
select @salary =d.salary from deleted d

Insert into employeeHistory([EffectDate],[empid],[empname],[salary]) values
(getdate(),@empid, @empname,@salary)
end

Now I explain it, I have 2 table employee and employeeHistory as well as a trigger on update of employee table. The employeeHistory table contains the updated record (i.e. when we update employee table then updated data will store in employee table and the deleted data will store in employeeHistory table. If I update single row then it's returns currect output. when I update multiple row at a time then it's fired only one that is 1st row. Actually it's update employee table but trigger is not work properly. that is trigger fired only for 1st row.

update employee set salary =11000.00 where salary =10000.00

Example: emp001 xxxx 10000.00
emp002 yyyy 12000.00
emp003 zzzz 10000.00
emp004 aaaa 15000.00
emp005 bbbb 12000.00
emp006 cccc 12000.00
emp007 pppp 10000.00



Now suggest me what is the how to solve it.

create table Student
(srNo int IDENTITY(1,1) not null,
RollNo int not null default as srNo-- This column will contains as default if user doesn't provide any. Here I need 'srNo' as default for 'RollNo' column.
StudentName varchar(50) not null)

Can you give a query(i.e. example) to build it

1. Print out should be either fit in page or center of page where page size=height=5.5 inch and width=9
2.or if I set the page at compile time as landscape the output should give in portrait mode.