Thanks Andras,

At the moment it looks we are going to stick with MSSQL 2000, but will change in short time.Anyway thanks for your quick reply. I should say-koszi szepen:)

Ben

Hi Ramesh,

Your point is good, I know it will work as I tried before, but I wanted somehow and sctictly to go through the File table:the reason I wanted to...

The Transaction object was clear for me to use, just was not sure how about the set of paramters for the same SQLCommand object.

Thanks Jack

Ben

Hi Jack,

Yes exactly, so I want to insert the provided current address details and if there is also the previous addresses fields (those have the same number of fields as...

Helo Andras,

If I am not wrong I should say, koszi a tippet

The whole story is about an open source application which was populating...

Thanks,

My situation is a bit complicated,as I had a mysql database structure and needed to copy it into MSSQL to get work with a java key manager, but seems that...

Cool,

Thank you guys for all your suggestions, will try and will be back with the result.

Cheers

Ben

Crispin,

thanks for your suggestion, I have tried to do it , but got an error which seems to say nothing to me:

I executed this script:

exec master.dbo.xp_cmdshell 'osql -E -iC:\usr\endentities.sql'

and got...

Just found an article on comparing MySQL->MSSQL data types, stating that enum types don't exist in MSSQL,however there is the possibility to use the CHECK function, like the following:

CREATE TABLE...

ooops Sql Junkie

You are right, just missed the right forum.I usually use SQL 2005, but have to use now SQL 2k and just...

Yep I see

Just I did read it is not the same as the QA, as it is only an estimation and there is...

Noel,

what the button is called, because there are couple of buttons similar but not the same as in SQL 2000,like:

Display Estimated Execution Plan

Analyze Query in Database Engine Tuning Advisor

Design Query...

As I see almost noone had a chance to take a look..

Played a bit with discussion forums msdn etc. and got it in a couple of minutes.

There is a CURSOR...

goyers,

One thing I still did not get, is what the Hier_level does stand for?

I would say that should be a hierarchical level of departments or levels with different granted permissions.

But...

Would not be just easier to sit on the dataset we were shown and sayK,first step we do before any processing is NORMALIZATION...?

There would...