The Attendance System devices are a separate software. The data in there table is just like this. Some people do time-in and no time outs. I have to manage it...

Please help me steve

Steve,

I have given my user options in front end, according to options my query checks which flag is true and which flag is false, my generalized query for all...

I want latest statusId to be returned.

I think one way to do this is to store latest status id in the orders table and avoid any joins with customerstatus...

Following is the query:

Declare @FromDate varchar(15),@ToDate varchar(15)

set @FromDate = '17-Apr-2008'

set @ToDate = '18-Apr-2008'

select a.OrderID, a.UniqueID, a.CustomerId, a.LocationID, a.OutletID, a.PunchDate, a.ReceivedDate, a.DelieverdDate, b.CustName, c.LocationName, d.OutletName,

(select top 1 StatusID...

I want a cross tab basically, i can do it by Crystal Cross tab reports but problem is I have to perform not only addition but subtraction and discounts on...

well we will put values against these values, see above 2 tables are just the tables of where rows and cols are defined there is another table where we define...

when i searched i got following link]

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=89594&SiteID=1

It says that is sql server 2005

"direct updates to the system tables are not supported."

someone told me that i have to...

when i issue following commad

Update sysdatabases set status = 512 where name='MYDB'

I get following error:

Msg 259, Level 16, State 1, Line 1

Ad hoc updates to system catalogs are not...

Please tell me how ?

Thank you guys!

salarydate is datetime,

employee code is varchar

income/tax figures are float

ur approach still has problem ... see

92.406459085122478  is 1/11

77.358114112521619 is number 2/11

so the other same entry 77.358114112521619 should be marked as 3/11...

thanks guys

approach by Rookie has some problems i used his approach and following problem occured:

Prog A      32.600187121827403           7/11

Prog B       -416.6613067305484            11/11

Prog C        77.358114112521619            4/11

Prog D         77.358114112521619            4/11

Prog E         77.358114112521619            4/11

Prog...

Grasshopper that was exactly what i was looking for, although i have solved my problem on my own but i used more number of lines than your solution.

thumbs up buddy.