Hi,

Check out the BOL on expanding hierarchies. There is a procedure for expanding trees.  

Another way is to store information about the level in the hierarchy in the table and...

Hi,

Text, ntext and image columns cannot be referenced in the inserted or deleted tables when using a (normal) AFTER trigger. However they are allowed in a INSTEAD OF trigger, which...

Maybe not a direct answer to your question but I've used this construction

SELECT field1,field2,field3

FROM

(SELECT field1, field2, field3, 1 as mask FROM Table1

UNION ALL

SELECT field1, field2,...

Hi

Try to remove the # before inserted and deleted tables.

/Fredrik

Hi,

Have a look at this KB:

http://support.microsoft.com/default.aspx?scid=kb;en-us;323586

/fredrik

It should not work (depending on what your data look like;-) since 123 in DataPaqMFG will be matched against 00123 and 02123 in products.

/Fredrik

Hi,

Is the column len fixed in table a?

If so then you could construct the join like this:

SELECT *

FROM TableA a

LEFT JOIN TableB b ON a.col...

Hi I see three alternatives depending on your requirements on speed/data-integrity.

Alternative 1.

If you are using MSSQL2K then you could create a user defined function to strip leading zeroes. (See BOL...

I think I found the problem.

The database was set to grow with 2 GB. The server is brand new and the disks are empty. Also the disks are (surprisingly)...

Hi,

Yes, I have checked all settings (that I know of) and they are the same (I will doublecheck them, especially the timeout on the connection).

Databaseproperties, serverproperties, connectionproperties, MDAC-version, servicepacks...

Hi again.

I don't think this problem has is an edition issue but I still would like to know if there is a page out there that shows the differences between...

If it is columnnames you want then check Query Analyzer for SQL2K.

Right-click on a table (or stored proc) in objectbrowser. This brings up a menu from where you can...

You could create a COM-object which logs in as dbo and then truncates the table. Then call the COM from a stored procedure (see sp_OACreate, sp_OAMethod...).

This way you can keep...