Please open the ReadMe.htm file, and run the setup.exe in the commmand line parameter.... It will work fine....

Thanks,

Ganesh

Logically,without an ORDER BY clause, SQL Server is free to return the rows in any order, so any value of [col1] is correct. Recall that logically tables are unordered sets...

Hi Lenin,

You can do this with a ActiveX Component provided by Microsoft. But you need to have SQL Server 2000 Resource Kit.

Please follow the link. You will get everything you...

Could you please send your procedure ?

Thanks,

Ganesh

In addition to that, when you do a cascade delete on the parent table will lead to ambiguity.

thanks,

Ganesh

I think it is not possible and it will lead to poor design. The fact is, you shouldn't try to give two different meanings for a single column.

If this is what...

Follow this link.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01l1.asp

Thanks,

Ganesh

Hi Mj,

Very Good Morning. I would change the query like this. I hope it would improve the performance to a certain extent as you are saying all the columns are...

I think you are doing the insert using a raw sql. Instead do the insert inside a stored procedure and return the scope identity.

I hope this solves your problem

Thanks,

Ganesh

Step 1:

Insert the master record in the table bayan.dbo.jobs.

Step 2:

Insert the detail record in the child table.

This would solve your problem.

Thanks,

Ganesh

Script from Umachandar Jayachandran Site...

DECLARE @ServerName varchar( 128 ), @sqlserver int, @RetCode int,

        @Instances int, @Count int, @NumInstances int, @Instance varchar(

128 )

EXEC @RetCode = sp_OACreate 'SQLDMO.SQLServer2',

SELECT COUNT(*) FROM MyTable

WHERE ( Record1 is Not Null and Record2 is Not Null and Record3 is Not Null)

    AND ( LEN(LTRIM(RTRIM(Record1)))  > 0   and LEN(LTRIM(RTRIM(Record2)))  >...

SELECT COUNT(*) FROM MyTable

WHERE ( Record1 is Not Null and Record2 is Not Null and Record3 is Not Null)

    AND ( LTRIM(RTRIM(Record1))  =  ''  and LTRIM(RTRIM(Record2))  =  ''  and LTRIM(RTRIM(Record1)) ...

Try setting this option, DBCC traceon(257)

I have seen this in Google.

Thanks,

Ganesh

Select CategoryID, dbo.getNoOfItems(CategoryID) AS NoOfItems where ParentID = @ParentID and dbo.getNoOfItems(CategoryID)  > 5

I hope this would work.

Cheers,

Ganesh