1. Goto DB

2. Right click database folder and choose Restore Database

3. Tick "From device" under Specify the source and location of backup sets to restore.

4. Click add on the pop...

There are diffrent approaches in sql to do this. Triggers, output clause or the the parameter value can be determined if it will save to your deleted messages tables.

If you...

If the problem is avoiding duplicate data insertion in your table, it will be a diffrent story. You need to check first the data if exists in client table before...

Hope this code will work and if it satisfied with the ff requirements.

1. You want to select distinct resultset.

2. must have primary keys and foreign keys to join the three...

here is a good link http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

Once you get the first day of the week add no of days to that with the dateadd function to get the last...

UPDATE #TEST_TABLE

SET COLS = SUBSTRING(COLS,3,LEN(COLS)-2)

WHERE LEFT(COLS,2) = 'NA'

sorry for the confusion. What i mean is even if they are on different SP, as long as they are within the session. It is possible to access the temporary...

create temporary tables using dynamic query base on the resultset. Temporary tables are accessible in another SP and from that SP, you can join the two tables.

Have you encountered any issues during the installation? try to uninstall and install the application

Nothing except the ID(primary key) of the data.

I think I would need to pass the username and use the output clause. Would you think that make sense?. I'll try...

I think I did not stated clearly my post and I'm sorry for that.

The issue is... A user logon into a machine using domain account ("domain_account"). Then the user logon...