That (without the GO's) or ensure the stored procedure is created with those options set appropriately.

Why don't you just delete this part from the second query, it is always true:

and (avg_cost <> 0 OR avg_cost = 0)

and (in_stock <> 0 OR in_stock = 0)...

For S and G's change my query to use '20091001'.

Duplicate post. Please post replies here.

What does this return:

SELECT

i.CreatedDate,

i.EffectiveDate

FROM

Inventory AS i

WHERE

i.InventoryReasonCode = 173

AND i.EffectiveDate...

VG-619426 (10/7/2009)

---

Insert in done through a stored procedure. Stored procedure does use this view, it just references the table.

But, the table is referenced in a view, which has a indexed...

I'd start by searching the MSDN and Technet sites for Cluster Configuration.

Okay, sorry but an empty string ('') is not the same as NULL.

I know that tables inside an ACCESS database can be accessed using linked servers. At a previous employer we attempted to execute inside an ACCESS database but failed as...

How is the insert being accomplished, actual T-SQL command or inside a stored procedure?

I thought so, and just verified it myself as well.

Roy Ernest (10/7/2009)

---

Yes, true... The final decision is theirs. I am not going to force my kids to change their minds... I am just hoping that they wont come with...

What are you trying to accomplish?

You know, if it paid well enough, I'd considering working in the UK for a few years. Been 28 years since I left, and I would love to come...

Looking at BOL for SQL Server 2000, I...