Can you tell me why do you want to use trigger...

Hi Lowell

thank you for your confirmation on my approach 🙂

Hi

This is very intresting question, but kind of list in somany replies...could any please tell me the solution/algorithm.

Hi

I had the similar requirement, where in i disabled the Unique Index on the column and loaded everything and deleted the duplicate records and enabled index.

Please let me know gurus...

johnsql (4/5/2009)

I have an original table "MyTable" with nodes like followings

MyTable's data

NodeID ParentNodeID ...

There is one intresting article on VARBINARY vs FILESTREAM datatypes.

http://coolthingoftheday.blogspot.com/2009/01/sql-server-varbinary-vs-filestream-code.html

gr8..thanks for posting the solution..it will surely help others..

Hi

You may want to check out the below links:

To Migrate Access Data into SQL Server:

http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx

To Migrate ASP code to ASP.NET:

http://msdn.microsoft.com/en-us/asp.net/aa336623.aspx

Hi

Simple tip about WHERE Condition, If you have "n" tables in FROM Clause then you need to have minimum n-1 where conditions to avoid any cross joins.

What is the use of this database??? are you using this database to query new...

Hi

Could you please give us with sample input data and out put data which you are expecting. Your requirement is bit confusing.

Hi Joseph,

I am not sure if i had any words which felt like insulting. If that is the case then i am sorry but this was not my intention. I...

Hi Flo

If you use QuoteName(@Variable,""), then you can avoid SQL Injection.

FYI: http://msdn.microsoft.com/en-us/library/ms161953.aspx

Hi

Check out the below link. You dont have to use Split. Its just that you need to use CONVERT function.

http://www.sqljunkies.ddj.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

HI david,

Did you tried to use COALESCE function which i had provided yesterday????