http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1217061,00.html

Why don’t you use SQL Server profiler to identify the deadlock first? Then analyze the deadlock graph and you can see what the causes are. For more details refer below...

In SQL Server there is no common place to put your common functions. Put whatever objects in the same database that is using those objects.

If you put any object...

In SQL Server 2005, you have a tool called, “SQL Server Configuration Manager”. You go there and click on SQL Server 2005 Services in left pane. Then it will display...

This is how you do it SSMS. (SQL Server Management Studio)

1.Expand the security folder of the respecting server

2.Right click on the user and get properties

3.Select Server Roles from the left...

You can use below query to get what you want. Remember you need to declare 6 date variables for this query.

Two date variables to filter weekly data

Two date varibales to...

A view is a virtusal table in SQL Server. A views are updateble. But there are several conditions applied.

1. View must be derived from one base table.

2. Coulmns of...

Can you explain a bit, how you are getting Actual fugures? I mean WeekActual, MonthActual, YearActual

You can use the following query to update status field with 'matched'.

Table tab1 contains the sample data you have given.

update dbo.tab1 set [status]='matched'

from

(select cardno,sum(debitamt) as dra,sum(creditamt) cra,...