Nice query. Certainly the best approach for the mentioned scenario. Removing the Split function and any hidden R-BAR associated with it. Thanks for posting.

b.value column is coming from the string split function .

select t.*,p.bld_document

into #k

from

(

select a.*, Convert(int,b.value) [DocID] from #t a

cross apply

(select Value from dbo.split_delimited_string(a.blp_documentattach,',')) b

) t

join #m p

on t.docID = p.bld_documentid

replace '*'...

Here is the solution for your problem:

You can use any csv splitter function available and replace the one I have used in the code.

create table #t

(

blp_proposalno bigint,

blp_documentattach varchar(max),

blp_fund int,

blp_branch varchar(5)

)

create...

dbajunior (8/8/2013)

---

Description: This procedure will allow you to find any string in any DB Object with its name or part of its name.

It will also allow you to find the...

Didn't actually get your question, could you please elaborate?

Usually what I do is create...

Even the article focuses discussion around ORDER BY clause. I am not saying that if I have never encountered any issues with it then it is perfect. I want to...

The discussion is going pretty well and the different approaches mentioned are good. One thing I would like to point out here that all the solutions revolve around the same...

Easiest way

DECLARE @listStr VARCHAR(MAX)

SELECT @listStr = COALESCE(@listStr+',' ,'') + Name

FROM Production.Product

GROUP BY Name

SELECT @listStr

🙂

@MarbryHardin

Thanks for the reply....

I am using the search mechanism only, I have a large number of db objects with dynamic sql queries so you can understand how...

Thanks for such a quick reply. I have already tried this method. It is effective when I have to go through small pool of db objects with dynamic queries.

In my...