The data section is just for this example. You only need the calculation section to work with your actual data.

Here are a few ways...

select a, min(b) as b from [Table 1] group by a

select a, max(b) as b from [Table 1] group by a

; with x as (select *,...

Try replacing

select

Log#,

TextID,with...

select distinct Log#,

Here are some links which might help...

http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html

http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html

Bare with you?

Another technique which can be useful in some circumstances...

update #TEST set Descr = replace(replace(replace(Descr, ' ', '¬ '), ' ¬', ''), '¬', '') where Descr like '% %'

(Where ¬...

Hopefully this will get you started...

--data

declare @t table (JOB_ID int, JOB_NAME varchar(10), [?] int, SIZE int, run int, SHEETS int,

QTY int, job_status int, mc int, pages...

This looks like fun, so I'm chipping in...

declare @t table (id int identity(1, 1), a1 int, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int,...

Something like...

update movie

set price = case when movieName = 'fofo' then 12000*2 when movieName = 'lili' then 25000/2 end

where movieName in ('fofo', 'lili')

Peso (5/23/2008)

---

Why count every date from Tally table when every 7th will do?

set statistics io on

-- Ryan

select Date from (select dateadd(d, Number-1, '20080106') as Date from dbo.Tally) a

where datename(weekday, Date)...

select Date from (select dateadd(d, N-1, '20080106') as Date from dbo.Tally) a

where datename(weekday, Date) = 'Sunday' and Date <= '20100103'

See this article for info on how to create the Tally...

Another XML-style approach...

drop table #Results

; with a as (select RowNum, cast('<parm '+ replace(replace(Parameters,'=','="'),'&','" ')+ '"/>' as xml) as Xml from #SourceTable)

select RowNum,

Xml.value('(parm[1]/@Subject)[1]', 'varchar(255)') as Subject,

...

Glad to help, thanks for the feedback 🙂

Microsoft does... http://msdn.microsoft.com/en-us/library/ms175498.aspx

rbarryyoung (5/18/2008)

---

yeah, I can't figure out why though. I've got the right address in the IFcode, but somehow its coming out with this rogue pointer.

Here's what I put in:

[font="Times...