Without something that makes easy for me or others to readily start working on a solution you are not likely going to find much help. I was asking for a...

Remember we can't see over your shoulder and have no intimate knowledge of your project. Please help us help you by providing ddl, sample data (insert statements), desired output (based...

Not sure what you mean by not working but I suspect it is not producing the desired results? The replace statement is probably not doing what you think/expect.

Select Col1, Replace(Col2,'...

Yes following the lines of your previous discussion it is preferable to have each module of code do one and only one thing. If you have combined them you have...

Hi and welcome to SSC. It is pretty hard to provide anything resembling a real answer to your question based on what you have posted. Take a look at the...

I agree the problem is in the cursor...in fact i would suggest that the problem is using a cursor in the first place. If you can post some sample data...

I would be willing to bet that you don't need a **cough**cursor**cursor** to do an update. You will benefit in huge performance gains by converting to a set based solution....

select column1 + column2 from table

Hi and welcome to SSC!. Reports can frequently be some of the most complicated queries. Sounds like you are new to sql? I don't know that diving straight into SSRS...

yes

Rich Yarger (6/14/2011)

---

OK - what if I need to make certain that there isn't just 1 space, but say 2 or 3 or 10 spaces? How would I incorporate...

nullif([your column here], '''')

bopeavy (6/14/2011)

---

vmssanthosh

---

hi

our manager is giving a new idea of having only one procedure for insert update and deleting all the master tables.

he wants to specify the table name and the...

+1000

Like I said you already posted this question and you got an answer. In fact, I gave you pretty much the same answer.