Database

SET DATEFIRST 1; 
DECLARE @d DATETIME; SET @d = CONVERT(NVARCHAR(10), GETDATE(), 121); 
DECLARE @x INT; SET @x = DATEPART(dw, @d) ; 
WHILE @x > 1 
BEGIN 
  SET @d=@d-1 ; 
  SET @x=DATEPART(dw, @d) ; 
END ; 


SELECT 
    CONVERT( NVARCHAR, DATEADD(wk, -1, @d) , 101) AS FirstDayOfLastWeek  
  , CONVERT( NVARCHAR, DATEADD(dd, -1, @d) , 101) AS LastDayOfLastWeek 
; 

Select Cast(Cast(GetDate() as int) as datetime) As Today
	,Cast(Cast(DateAdd(dd, -7, 
		DateAdd(dd, - DatePart(dw, Getdate()) + 1,
		GetDate())) as int) as datetime) As LastWeekStart
	,Cast(Cast(DateAdd(dd, -1,
		DateAdd(dd, - DatePart(dw, Getdate()) + 1, 
		GetDate())) as int) as datetime) As LastWeekEnd

select
Convert(varchar,DateAdd(dd, -(Datepart(dw, <code>Getdate()</code>) +6), <code>GETDATE()</code>), 101) 
    As PreviousWeekStart
,Convert(varchar,DateAdd(dd, -Datepart(dw, <code>Getdate()</code>), <code>GETDATE()</code>),101) 
    As PreviousWeekEnd

Select Question
,Sum(Case When Response = 'Excellent' Then 1 Else 0 End) as Excellent
,Sum(Case When Response = 'Good' Then 1 else 0 End) as Good
,Sum(Case When Response = 'Average' Then 1 Else 0 End) as Average
,Sum(Case When Response = 'Poor' Then 1 Else 0 End) as Poor
From
(Select Code, Q1, Q2, Q3
From <code>#t</code>) p 
	Unpivot
	(Response For Question In
		(Q1, Q2, Q3)) as unpvt
Group By Question

DELETE FROM TABLE_1 WHERE ID IN (SELECT ID FROM TABLE_2)

DELETE FROM Table_1
FROM         Table_2 AS t2 INNER JOIN
                      Table_1 as t1 ON t1.ID = t2.ID

Create Proc usp_DeleteFromTables
@Id int
As

Delete From Table1
Where Id = @Id

Delete From Table2
Where Id = @Id

Exec usp_DeleteFromTables 2

IF @@ERROR <> 0 
  PRINT 'Insert into MyTable failed'

Raiserror('Message', 16, 1)