jacob sebastian (5/30/2008)

---

You can find the total number of rows by using 'COUNT(*) OVER(PARTITION BY '')'. I think some one has already mentioned this earlier in this thread.

You can...

You've given us just about nothing to work with. You going to have to be more specific.

looks suspiciously like something you should be leaving to your presentation layer to...

With the amount of info you have right here - it's just about impossible to give you anything mucvh to work with. You need to review the execution plan...

Sounds to me like you're angling towards using some kind of table-wise UNION setup to get your reports. That's certainly something that can be done vai T-SQL.

Depending on what...

Also - perhaps try setting NOCOUNT on in your stored proc. Messages being returned might be getting misinterpreted too.

Ted Pin (5/30/2008)

---

That is a really good point. The...

In 2005, there are two things that come to mind (well - two different method to get to the same place):

- there's a default trace running, which keeps track...

I understand - I guess I've been focusing...

Michael (5/30/2008)

---

Thanks for all of the feedback. I realize I should have provided a bit more detail. After I posted, I learned, by reading the help files that;

-...

Jeff Moden (5/30/2008)

---

Look at the code, guys... column was previously defined as NOT NULL.

Dunno if it'll work because no one provided the code for the rest of the...

Create a passthrough query in Access... Connect it to your DB.

Just type in as the query:

Exec MyStoredProcedureName @Myparameter='MyString'

Save query - run it.....

How about making sure the name is unique?

Just create the table, then look up its object_ID(). Doing that will return the #Temp table you created, even if...

There should be, although how much might be debatable. Ultimately - I think the "sweet spot" is the version you didn't include:

CREATE NONCLUSTERED INDEX IX_OrderDetailDateProdSold ON dbo.OrderDetail

( OrderDate ASC,...

You could always add the constraint with NOCHECK and then enable the constraint. That will prevent any FUTURE nulls from getting in.

Have you check if there were nulls in column B? I know you had a constraint on it, but if it was disabled or if the constraint was added...