You can use this query, which will result in the headers of the columns... But I'm not aware of a possibility to get the SQL datatypes of the columns.

Hope that...

Thanks Silverfox,

From what I can see, I really have to go to the entity I gave the permissions from to see the access.

There is no way to see that for...

Sorry I couldn't post earlier,

You can add the ISNULL builtin function to pass a empty string to the quotename function when the value is null.

Here's how:

QuoteName(ISNULL(CompanyID,''),'''')

That behavior happens...

Well, looking more closely at your code, I can say the error you are getting comes from your IF Statement, and because you are referencing fields that are not in...

Well, the first thing I saw was the multi cross join you have between the deleted, inserted, and your table, in your select, in the trigger. Next is you can't...

Guys, this works perfectly, we've tested this, and this is just what I needed.

I got a question though, I'm not really strong security wise, maybe that's why.

I'm looking from some...

Sorry I could not answer faster, I was in a meeting.

Nice guys, thanks a lot, this looks like exactly what I need, I will look into this.

Thanks again,

In the update statement, you need to use the Alias that was created by Jack for the table name,

Where it's written

Update Orders

From Orders O

join Orders O2....

It should read...

Well, it's a start, but you have not prepared the tables using Create table TableA, and most importantly, INSERT INTO Table

select bla bla bla

union all

select bla bla bla

union all ....

And...

This is not an easy one, but it's doable. Do you have anything you have come up with, what are you working on right now?

Can you provide some testing data,...

I did a quick test, and created a 20 GB database, took about 4-5 minutes, and ran completely. I'm on a developper machine, not too quick.

Few things:

1. Sp_who2 returned...

Heh.. Yes! Index fragmentation and out of date are the MAIN performance problems for a system, just after really poor design of tables and/or poorly written queries.

You can find the...

My pleasure Matt,

Have a nice day!

Well, you have no order by clause.. all you do is number your rows in the case statement, and you don't add the order by seq asc, at the bottom...

matt6749 (10/16/2009)

---

The code below is a sample paging code with two ORDER BY statements. I'm confused - which ORDER BY takes precedence??

;WITH cols

AS

(

SELECT table_name, column_name,

...