:blush:

Adding to what Paul already said:

your nonclustered index is unlikely to be used since it has the same leading column as your clustered index.

Please explain what you think the indexes...

If you need to figure out where you have different results in your two tables then just use the great sample code Paul provided, join it to your invoice header...

I'm not sure if I'm missing the point but to me it seems more like the question is:

Why is the DROP TABLE statement not recognized?

As far as I know you...

Why do you have MAY 2nd in your list instead of May 1st?

What data format is your dt column?

Please help us help you.

Please see BOL (BooksOnline, the SQL Server help system usually installed toegther with SQL Server) section "CONVERT".

Like I wrote before:

UPDATE targetTable

Set Col=value

FROM SourceTable

INNER JOIN TargetTable ON JoinCondition.

You don't need to go for each bottle separately... 😉

So, forget about using a cursor for this task. It's not...

scott.atkins (3/12/2010)

---

Hi Lowell,

Regarding what i have just wrote, im trying to piece together a Cursor that allows me to retrieve information from one Table and update another table below you...

Elliott W (3/12/2010)

---

Also, I would really have to think about allowing users to run SSIS packages as themselves in a production environment. I'd have to see a heck of...

One option would be to set up a staging table you could use for your bulk load task and add a stored proc to insert those data into the final...

You're welcome! 😀

Going back to the picture you used:

Sometimes it's faster to just cut the tree rather than just barking up... 😉

I guess the answer is "it depends".

But there's one thing I wouldn't do: using sp_send_dbmail directly within a trigger, since the mail sending process would become part of the insert...

Don't think about a specific user. Do it set based:

INSERT INTO [db].[dbo].[ProfileUsers]

([PROFILE],

...

I'd rather use an inline table-valued function (ITVF)...

CREATE FUNCTION [dbo].[GetMonths](@StartDate DATETIME, @EndDate DATETIME)

RETURNS TABLE

AS

RETURN

(

SELECT DATEADD(mm,number,@StartDate) AS MonthValue

FROM master.dbo.spt_values

WHERE TYPE ='P'

AND number<=DATEDIFF(mm,@StartDate,@EndDate)

);

It's not really a good design to hardcode all those or conditions. Create a separate table holding those values and join...