Luis Cazares (3/14/2014)

---

Just to keep it safer, here's a modification to Sean's option.

DECLARE @str varchar(100) = 'the foreign institute of comics'

select @str = REPLACE(' ' + @str + ' ',...

abhas (3/14/2014)

---

Thanks twin,

All changes are aviliable in a table itself and we can idenitfy that changes by using EffectivestartDate column.

By using this column we can find out latest...

navie (3/14/2014)

---

My query is based on one table and one column. I need to provide development team report to see which columns need to address in their application. I am...

Seems to me that overpayments is not its own table. I would have a payments table. Then you can easily determine overpayments by calculating the balance.

In other words, you would...

Here is one way.

select @str = REPLACE(@str, Noisy, '')

from #tblNoise

select replace(ltrim(rtrim(@str)), ' ', ' ') as Result

rajemessage 14195 (3/14/2014)

---

Few part is algorithm like loop.

and i want to roll back only if error comes any where in side outer loop,

and after error handeling i want continue with...

rajemessage 14195 (3/14/2014)

---

Hi,

REPLACE function will replace all occurrence of any expression.

is there any thing which can replace only first occurrence ,

and is there any thing which...

ChrisM@Work (3/14/2014)

---

Grant Fritchey (3/14/2014)

---

Ed Wagner (3/14/2014)

---

Grant Fritchey (3/14/2014)

---

Yeah, that one is killing me. Vague weirdness, badly edited execution...

Mitesh Oswal (3/13/2014)

---

DECLARE @tbl TABLE

(

ID INT IDENTITY(1,1),

Char1 NVARCHAR(100)

)

INSERT INTO @tbl

select 'ABC x.yz'

UNION

select 'A.BC X.*YZ'

UNION

select 'A.BC *X.YZ'

DECLARE @tblNumber TABLE

(

Number INT

)

INSERT INTO @tblNumber

SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY S.Object_id )

from sys.objects...

That looks better but you still have RBAR in there. You have a while loop that is still running but going from 88 minutes to 4 is a vast improvement....

jcrawf02 (3/13/2014)

---

The Dixie Flatline (3/13/2014)

---

I looked but I couldn't find even one envelope, much less three. My boss called me in and told me I was...

Thank you so much for posting ddl and sample data. This makes it very easy to work on your issue.

What you need here is a crosstab. I made some assumptions...

Glad that helps.

Yes...

briancampbellmcad (3/13/2014)

---

Is this close to the correct syntax for a stored procedure for deleting all the data from a particular table... or is there a better way?

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

You are quite welcome although...