Nevyn (7/18/2014)

---

The date variable is fairly easy to work around I think. Instead of casting to that type, you cast to a string, substring off the time, cast back to...

I believe 2012 improved row sampling for determining if a file was going to fail metadata, but I'm not positive on that.

Is this a CSV? If so, does your...

I have a similar requirement for a 3rd party app I need to interface with. The most effective way I know of to do this is to append the...

davidsalazar01 (7/18/2014)

---

You guys are all right, this is madness I've created here. I'm trying to avoid blocking since there are rows that will be inserting in table frequently. ...

delete ServiceLog

where ServiceLogID = @ServiceLogID

That's a single row removal, not a range. The question is why they chose this technique. It's typically a poor method unless you've...

Glad to...

From a general perspective, and I know purists will disagree simply because of the memory grants (which will affect OTHER queries), no, it shouldn't cause you issues directly. Not...

I'd... be careful of considering that resolved. Even anonymous logins can get access with that security setting. However, you've confirmed, decisively, that it's security.

Now you just need to...

thomashohner (7/18/2014)

---

This is for a report nothing else. They are just trying to create a result set with this temp table. There are a few UPDATEs to the temp table...

Excellent! I'm glad you found a thorough post to help walk you through the process.

That's because that article doesn't discuss how to change the schema/metadata for the source, only how to locate the target properly.

You can't dynamically change metadata (ie, column info)...

It... could be.

What's the rest of the query doing? I've done things like that before to allow the import to occur no matter what prior to validations.

Please set these up as usable (ie: runnable) temp table inserts, and explain how you expect 1/5's value to go to 1/6's date. Your explanation doesn't describe the entire...

Andy, I agree with your opinion thoroughly. I also 'grew up' with access... though I did mine in 95/97. So perhaps it's just familiarity.

Access is an excellent tool when...

This is relatively simple and a good use of triggers....