Sir Slicendice (1/31/2008)

---

No amount of testing and adding hints can ever make up for using functionality that is explicitly unsupported. What happened to defensive programming? Are we really...

That's where I was thinking you were going. You really don't want to use dynamic SQL for that in my opinion.

I'm also not sure why so many think that...

Are you trying to create blank copies of existing tables (that have rows) or ar you trying to find those with NO rows among a total of 400?

Now that you don't have any ability to touch most of the stuff which would allow you to prevent their access, hmmm....

It's a real challenge to be specific, since you're...

Well - while the bases seem pretty well covered, so just remember this - costs aren't always what they're cracked up to be. They represent just one component for...

That kind of syntax is going to force a scan of the entire table. So it's going to be a rather intense search, expecially to complete a full table...

Ah - took a second to visualize what you're looking at.

If you change the format to ###,##0 it won't suppress ALL of the digits if something has a value of...

Can you give an example of one of your counts?

The Count(*) in T-SQL always returns a value, even if 0, so i am curious how you're coming up with your...

With hierarchies like this - I'd advocate using some kind of "expansion table" which permanently stores the downlines (current and past if need be). Assuming that downline table doesn't...

If you look at the overloaded versions of SQLParameter, the longest one allows you to specify nullability of the parameter.

looks something like

...

Dim p As New System.Data.SqlClient.SqlParameter("joe", Data.SqlDbType.Char, 30, Data.ParameterDirection.Input,...

GilaMonster (1/31/2008)

---

Good point.

For anyone curious - Read uncommitted isolation means that SQL can do...

You could use the INFORMATION_SCHEMA.Columns view to get to the column names, and then conjure up some dynamic SQL to do what you're looking to do.

But still - if you're...

In addition to Gila's suggestions, since you're in 2005 - you might care to read up on the RANKING functions available. Books online have some good examples.

Good luck on...

persnickety is a kind word to describe Lawson....:) But still - you may find it doesn't need that much maintenance.

Actually - I thought QWIRKY was the layout of your...

Philippe -

While I would recommend you start a separate thread on the specifics of your process, I would imagine that this technique might be useable in your scenario. ...