if you can give me the CREATE TABLe statement for your table ([cust_Forms] ? maybe)

I'll play with making a trigger; this is kind of interesting.

this part doesn't make sense:

I'm assuming...

sounds like you only have the SQLExpress version and not Developer or full versions like Standard or Enterprise.

In that case, you can make a linked server, and then do a...

the import wizard will easily help you connect to an excel spreadsheet or any other data source, and automatically create a table with the same column names the excel spreadsheet...

can you provide a bit more information?

a trigger should do any work that is directly related to the data that is being inserted, Updated. or Deleted. it would fire one...

identity property is one of those items that needs to be done at table creation. to add it later, you can use the GUI to add it...it makes a temp...

yes...the IDENTITY property auto-increments the enxt value for your int column...technically it doesn't have to be your primary key, but it is very common for them to be the same;

here's...

not as easily;

xml is supposed to be self describing...so an xml element can contain the name, the data type, and the value; it can contain much more information than those...

Steve Jones - Editor (5/2/2009)

---

Lowell,

There isn't a better way right now. I periodically spend 10-20 minute killing off threads from my subscriptions.

I'm not clear, are you trying to find a...

not an easy way...unless your "Table1" has columns named the same as "Table2"

you can maybe find something quickly with this sql:

you can ignore a lot of you 181 columns that...

definitely a built in function, especially considering both encrypt() and decrypt() show up with syntax highlighting.

I googled a bit and I guess you are right that they are undocumented/unsupported.

Thanks Florian, but it's the "select the topic" that is killing me

that navigation provides the paged navigation list of all 2500 + subscriptions I've subscribed to...in the case of, say...

Steve I'm having a similar...

it's integer division that is killing you

@integer / 100, if it is less than one, is zero. SQL server shortcuts the math and says int / int is an...

doh i missed he said he did that already;

only advice i have left is one post i read said that rather than update statistics, they dropped and recreated the statistics,...

this is a common issue after upgrading;

you've got to update statistics and rebuild indexes after upgrading or restoring a database that came from a previous version in order to...