suryabeniwal
Last Activity: Jul 12 '10, 06:17 AM
Joined: Nov 27 '08
Location: Chandigarh
-
first count no of rows in grid then find checkbook id use loop and if condition ... all the best or u can send me your code i will do this task my email:suryabeni wal@gmail.com -
Hi friend these are main benefits that I see on stored procedures are:
* Abstraction
* Security
*Performance
Stored Procedures add an extra layer of abstraction in to the design of a software system. This means that, so long as the interface on the stored procedure stays the same, then the underlying table structure can change with no noticable consequence to the application that is using the database.
...Leave a comment:
-
hi freinds i need your help -
Hello Everybody There I Am New In This Feild . & I Want Ur Support . Your Support Will Be Very Useful To Me -
try this ...........
SELECT Employee.ID, Employee.study, MAX(monthly.wei ght) AS wt1
FROM Employee LEFT OUTER JOIN
(SELECT ID, weight
FROM Weight
WHERE Weight.[Date] > '11/1/08') monthly ON Employee.ID = monthly.ID
WHERE (Employee.Locat ion = 'Room 7')
GROUP BY Employee.ID, Employee.study
ORDER BY Employee.studyLeave a comment:
No activity results to display
Leave a comment: