Or "Bollocks" as we like to call it in th eUK. ...

GSquared (4/8/2009)

---

andrew gothard (4/8/2009)

---

Manie Verster (4/8/2009)

---

DBA's have the assumption that all developers are bad for a database or bad SQL programmers. Well, I am a develepor cum DBA but before...

GSquared (4/8/2009)

---

Robert Frasca (4/8/2009)

---

GSquared (4/8/2009)

---

On the "temp tables are bad" thing, the coding requirements for the place I work state that table variables should be used instead of temp tables,...

Manie Verster (4/8/2009)

---

DBA's have the assumption that all developers are bad for a database or bad SQL programmers. Well, I am a develepor cum DBA but before I had to...

bob.willsie (4/3/2009)

---

I think its important to have a good foundational understanding of programming and when/why to use an SQL query instead of writing code.

I learned SQL by looking at the...

Even with DataDude (VS Database Pro) there's no real integration with VSS as with .NET languages. What you could do is use VS with the db powertools to generate...

Ah - repotying errvices or BI would have been better forums.

When you transfer the data into a recordset object - do a rowcount on that and if it exceeds your...

@@ROWCOUNT?

20 lines of test data - and 5 tables? Is this a school project?

If so - please research this yourself. If not - please post details as requested...

Jeff Moden (10/3/2008)

---

Andrew Gothard (10/3/2008)

---

You just described the code at my new job... 😛 except instead of...

Jeff Moden (10/2/2008)

---

Andrew Gothard (10/2/2008)

---

J (10/2/2008)

---

"'dbo.selectthisandthat"

For my taste, I find this harder to read (mid-50 eyesight and all), it requires more attention to figure out the meaning of the name....

Have you tried running profiler? If you do and post the results this may give us more to go on

What defines whether or not the file is invalid?

THat rings a bell - 64 bit O/S as well?

Are you running a process loading a table based upon a view on the same table? If so, make sure that the bulkload option's set off.

It'd be worth using...