adam (5/19/2008)

---

Thank you.

I don't know too much about variables.

set @zip = (select zipcode from DEMOG) does not work because there is more than one result.

How would I go about updating...

You can use the STUFF command

declare @zip varchar(10)

set @zip= '477131230'

select @zip,stuff(@zip,6,0,'-')

See if this helps - the convoluted xquery below gets the name of the previous element

Note that if you are using SQL Server 2005, you may find it easier to...

Carl Federl (5/13/2008)

---

There are 5 overlap conditions between a Club interval and and Address interval which means that they occur during the same interval. This is easiest shown...

Something like this?

select s.Person,

s.Club,

a.Address,

s.ClubFromDate,s.ClubToDate,

...

Try this

order by case when some_column_name='some particular value' then 0 else 1 end, some_column_name

Jeff Marcus (5/7/2008)

---

I am using the Tally table explanation from this article to parse out an incoming string that consists of whole records. By design, I know that the...

select object_name(@@procid)

Try this

with cte as (

select GroupColumnA,

GroupColumnB,

GroupColumnC,

DetailColumnA,

...

A couple of other possibilities

select c.contact_ref,

...

Are you running SQL Server 2005?

Try your query as this instead

select sum(case when new_buildingstatusname = 'abated' then 1 else 0 end) as abated,

sum(case when new_buildingstatusname = 'compliance'...

SELECT p.ProductID,

p.ProductDescription,

STUFF((SELECT ','+c.Colour AS "data()"

FROM Colour c

...

Something like this instead?

Diff = coalesce(abs(ea.lev1-b.firstline),ea.lev1,b.firstline,0)

Try this

SELECT s1.Filename,

s1.range_start,

MIN(t1.range_End) AS range_End

FROM MyTable s1

INNER JOIN MyTable t1 ON s1.Filename=t1.Filename

...