Hello Jacob

I found the problem. Actuall we are using { in CAST syntax. It wont work with { , if you use < in place of {. It is working,...

Jacob

Thanks for pointing in spelling mistake, it was typo in post. I tried your syntax, but it is not returning any result. However If I run following query, it is...

Jacob

Any advise on my last post?

Hello Jacob

I tested on sample table as I mentioned thier structure it is working fine, but on actual table is it returning nothing. Here is actual table structure and data

CREATE...

Hello All

Thanks for reply and valuable feedback. I realize using sql is bit difficult becuase may be in future there might be more code. Is it not better I should...

Hello

Thanks for the response. Actually this database is very old 5-6 year old, client doesnt want to change the data structure, so I have no option, I have to...

Table1

"ash","kan","75 100"

"ash1","kan1","75 202"

"avi","nig","100 202"

Table2

"75","This record doesnot have privilege"

"100","Calculation Mistake"

"202","Category is Missing"

Hello Gardian

Here is structure

table 1

Fname VC (50)

Lname VC (50)

ERROR_CODE VC(100)

Table 2

Err_Cd VC (5)

Err_MSG (100)

Please advise

Could please tell me how do I the pass the databasename in store procedure?

If it not agianst your ethics, could you send me the code?

Sonashish