I am really sorry.

I couldn't provide data, its having more data and also i couldn't get it for specific data for sample.

please give me some idea how this can be...

I am sorry for not given clear input.

In #variableta table, txt_bh_assessment1,txt_bh_assessment2,txt_bh_assessment3,txt_bh_assessment4 fields data will be availble in #testing1, #testing2,#testing3 tables.

We need to find code-id for txt_bh_assessment1,txt_bh_assessment2,txt_bh_assessment3,txt_bh_assessment4 fields.

suppose, txt_bh_assessment1 value...

description1, description2, descritpion3, description4 fields values will any #testing tables.. and final output should in sigle row.

Its works Thanks a lot.

if only need select statement, am using update statement using mark2 and mark3 fields.

IF EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'student'...

Hi,

Subqueries is taking more time.. so We want to increase the performance, is there anyway we can increase the performance avoiding subqueries..?

Please help me on this

Regards,

tony

Thanks for your comments.

If am going with While loop option, client is rejecting because they need good performance query.

How can i set this query like set based solution please let...

yes, it works.. thanks a lot

This tool for search the results in DB and give the output to front end.

There are lot of functionality!

1.Search(10 seperate search functionality) - can be done through 10 to...

But still if i get the solution for this,it will be very thankful for you.

I am using following code to find the string

else if @kbm_function = 'search_all' AND ISNULL(@SearchStr, '')...

We are developing one tool(Backend : SQL server), that tool should be search the string from entire database.

But i have some codes,which takes min 30 to 45mins.

Even i tried with...

this script is calling Field also, Without Field, the string need to search entire database(in all fields).

Please help on this

Can you give the script how to search

The reason is, Suppose i want to search a string 'Family' in entire database. so that i could get the output which are tables(Fields) are having the value of 'Family'

Yes, Its column value. (any string from entire Database)

No still doesnt work, its happening based on seq_no only.

PFA