There is a table which has entries coming to it every day. I need to check which all entries came on Monday.
Create a table with a column to store date on which the entry was added. Use a date related data type like DATE, DATETIME OR SMALLDATETIME for this column.
Using this column you can then find the exact date on which the entry was added and thereby the Weekday.Then every consecutive day till Sunday i need to know which all "new entries came/entries got deleted" to this table and start the process all over over again from monday.
You can use the date column create above to find the new columns added.
If you want to find the deleted entries, you can create a trigger on DELETE action which will store the deleted data in another table.Then i need to import these things.
Where? If you need to import to some other table in SQL Server, you can write and INSERT statement for the new table and SELECT from the old table.
I hope this helps..
How to post data/code on a forum to get the best help - Jeff Modenhttp://www.sqlservercentral.com/articles/Best+Practices/61537/