quote:

---

...

I would say that it all depends on the data you have. Personally I'm still using temp tables for a lot of...

Set up a SQL Profiler trace tracking stored procedure statement completion. The trace can be run for a time period and stored to file or a table...more in BOL.

...

Yep, my mistake. Looks liek ON CASCADE DELETE is the only elegant option. My apologies.

Why do you need the EmpName in your first procedure? It's already in table theEmp. It's just redundant data at this point...

--

The procedure doesn't quite make sense...You are...

Make sure the server authentication is not Windows Only. Right click on the SQL Server in Enterprise Manager, select Properties. On the Security tab, check that Authentication is...

Agree. Don't use NCHAR or NVARCHAR unless you are absolutely positive that you require a wide character set. Many folks often are misguided into thinking that characters that...

CREATE PROC dbo.GetBasedOnDateRange

  @Start SMALLDATETIME

, @End   SMALLDATETIME

AS

BEGIN

--

SELECT FieldList, SUM(YourValueField)

FROM TableList

WHERE YourDateField BETWEEN @Start AND @End

GROUP BY FieldList

--

END

GO

Hope this gets you started...

Write a trigger which deletes all rows which match on the pid. The corresponding deletes will recursively trigger more deletes, etc...

CREATE TRIGGER dbo.MyTable_OnDelete

ON MyTable

FOR DELETE

AS

DELETE...

Big topic, but to get you started...

Basically, the tools you will need are a few variables to store the values you want to return in you error handler, a lookup...

But you have a WHERE rownum < 2 in your Oracle statement and no such similar filter in your SQL statement. Either put a JOIN to a MAX(som_time_stamp) derived...

quote:

---

I came up with the SQL statement like this but not returning exactly what is expected:

---