If you expose it directly - it would likely be attacked continuously.

A few recommendations:

1. drop "classic ASP". it's unfortunately got a fair amount of weaknesses, making it...

opc.three (3/8/2012)

---

Matt Miller (#4) (3/8/2012)

---

Eugene Elutin (3/8/2012)

---

OTF (3/8/2012)

---

Eugene Elutin (3/7/2012)

---

It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i...

Eugene Elutin (3/8/2012)

---

OTF (3/8/2012)

---

Eugene Elutin (3/7/2012)

---

It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would not allow to...

Question would be: why are you looking to change the output column?

You have what looks to be a well-defined structure to bring in, which from your description seems to be...

SQLKnowItAll (3/7/2012)

---

Since you know that the view will change definition and want it to pick up the changes, I would stick with the select * and add a refresh to...

As to the original topic: be careful with the use of DATEDIFF. From your use case, using the DAY unit should be safe. You would start seeing...

Try it this way:

SELECT ItemId FROM Item WHERE ItemTypeId=1

INTERSECT

SELECT ItemId FROM Item WHERE ItemTypeId=3

William Plourde (3/5/2012)

---

We also have one history table for each base table that we require versioned data on. Our base table(s) generally only have a few Ids with all or...

John Mitchell-245523 (2/29/2012)

---

Matt Miller (#4) (2/29/2012)

---

The "no effect" is focusing on how much is logged. You're going to log all changes in full and bulk-logged, so it will not...

John Mitchell-245523 (2/29/2012)

---

If it's all one transaction, batching it will have no effect. The...

djustice 20821 (2/24/2012)

---

Well, you called it Matt. I did import these tables twice. I imported these 3 last week and then when I imported the rest yesterday, I...

sturner (2/24/2012)

---

That is not a proper join clause, though it may work (somehow) for Access.

try this:

SELECT (your select list)

FROM AR_CUST_MAST a

INNER JOIN SO_PAST_INV_HEAD c ON a.CUSTOMER_NUM = c.CUSTOMER_NUM

AND c.SHIP_REF_DATE...

Try adding the VALUE column to your index as an included value. As of now, if it uses the nonclustered index at all, if still has to make a...

By chance - did you run your import several times?

I'd check each table to make sure you know what is really in there.

Also - you might care to check in...

For simplicity of purpose - on your foreach question, I'd frankly create a foreach loop specific to each file type (since each file type will tend to have a slightly...