Oops i meant i can not modify them !!!

Oops i meant i can not modify them !!!!

HI,

I do not have any access to those tables at all. I can modify them.

I think it is not happening all the time. But sometimes i get this.

Is...

Hi Again,

i have made changes and deployed it to live server ad now i received a error like...

'A column insert or update conflicts with a rule...

Hi, Thanks again.

I have used sql substring function.. and it worked 🙂

Cool.. I never found that.. Thank You so much ..

Could you please help how to get First part of the (or 15 char length) from the @EducationCodeDesc paramenter in...

what could be the TargetServerURL given as?

WOW.. its a good solution.. I just tried the first one for now it worked.. but if you actually dont recommend that then i will get back to second way.

Anyway...

Hi ,

Thanks alot for your good explanation..:)

I am actually using Krono's database(we bought the site and databbse from krono's).. so everything is already developed. I am not...

User does not enter every value for searching a record. When user enters any value , it may be all at once or only one value still the result should...

Hi its executing fine after i added else for return value (0). Thank you for that.

But my problem is.. it is not giving any result when i execute that from...

The follwong is the error message i get when execute it by passing '1111111111' as phone number and rest of them as nulls

But it was ok when i checked syantax

DECLARE@return_value...