Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  help me..sos...

Author  Topic  argate7 Starting Member 7 Posts Posted - 2009-10-13 : 18:38:48 hi, i have 2 tables..Customers,Payments Every customer must pay 50 euros every month. I want to make a form to show me who customer paid and who not. How can i achieve that? Is there any stored procedure that i have to do? I want actually to see for month January of year 2009 who paid and who not. I mean that for every customer it must be a record of a payment, but i don't want to insert this record, i want to be done by the sql server every 1st of a month. I heard that i can use sql job, but i have the free sql server 2005 express edition and in this edition this service is not supported. Can someone help me?