1. Try looking into Bitwise operator.

2. Create a function or a procedure which has the jave code and make a call to that function/ procedure in all other procedure.

3. How...

I am sure it can be done by modifying the table. If we have a table, logic and calculation can be part of the table or avoid any calculation or...

Here is the logic but if you want me to write the script let...

This can be done without a loop.

You are right, but if you look at the result set it give you the same recordset. Second row should be b@test.com

It will return the same result set

0657F7ED-58CA-4A3D-8393-B9A3DD315319A@test.com0657F7ED-58CA-4A3D-8393-B9A3DD315319

I think it is because of [1]

XML>

Institution Id="0657F7ED-58CA-4A3D-8393-B9A3DD315319">

Users>

User>

Email>A@test.com

...

Lars,

It is very difficult to write an article to address all level of reader.

Amit

Please posted your method of job scheduling. I may learn something new.

Guys

The rating of this article is not a justification towards the Author. Rating should be based on the article and not for ERWin.

Did you resolve this error? What was the solution ?

The above solution is not working for me

Jeff

If we over do anything. It will create a problem but in general I do not think View have that bad of performance that we should avoid.

Amit

I agree with you steve. If you retrive all the columns from base tables whether you are using SP or Views there will be impact on performance, It is nothing...

Steve

You are right, I wanted to do the change without using the variable.

but at present I am having difficulty explain the developer with this simple join. I will freak him out with...

Is there any know issue or someone having a problem of running SQL 2000 and SQL 2005 together (may be a different machine)