Try this:

CREATE PROCEDURE YourProcName

(

--DECLARE

@dtstart_time DATETIME ,

@dtend_time DATETIME

)

AS

BEGIN

SET NOCOUNT ON;

DECLARE @parts TABLE

(

...

Sorry, I don't have a crystal ball. Without more information there really is nothing we can do except shoot in the dark...

Check out this article and see if it helps: http://www.sqlservercentral.com/articles/T-SQL/63351/.

deprived

PSB (4/15/2015)

---

Hi,

I am trying to drop users from a specific database and getting the error below . Please help.

TITLE: Microsoft SQL Server Management Studio

------------------------------

Drop failed for User 'User1'. (Microsoft.SqlServer.Smo)

For...

SQL Server 2008 R2 SE and SQL Server 2012 DE.

I ran the code twice with no errors. Sorry I can't be of any help.

No problem with borrowing the hippo. You'll need to check with Jeff...

Grant Fritchey (4/10/2015)

---

Lynn Pettis (4/10/2015)

---

RonKyle (4/10/2015)

---

assuming the table is not a heap (which it shouldn't be, right?), why would it (at least...

PET PEEVE!

Semicolons (;) are not BEGININATORS they are TERMINATORS and belong at the end of SQL statements.

yusufm 48726 (4/10/2015)

---

I am trying to create a report that only shows the date and the total on that date.

I am not sure how to change the format so it...

Here is another way to write our query but it results is basically the same execution plan. Depending on how much data you have you may want to consider...

yusufm 48726 (4/10/2015)

---

Thanks but I have already got a query ready and finding it hard to work it through.

SELECT TransactionDate, AccountNumber, ProductName, ProductGroup, Qty

,CountryCode, Price,...

RonKyle (4/10/2015)

---

assuming the table is not a heap (which it shouldn't be, right?), why would it (at least as a general rule)...

Grant Fritchey (4/10/2015)

---

RonKyle (4/10/2015)

---

Interesting. I haven't personally made much use of include indexes since they do make the indexes bigger and I'm not convinced the performance gains are significant....