Coffee? I was projecting an image of a well-hopped bitter on my desk but sadly it remained exactly that - an image!...

Hi Phil

This should do the trick, because it supplies the value of ProductCategory:

INSERT INTO [Training].[dbo].[ProductProductCategories]

([Product], ProductCategory)

SELECT p.Product, 5 AS...

You're welcome Lorna. Incidentally, both statements produce the same result...

ISNULL(DateAmended,...

Hi Phil

When performing an UPDATE ... FROM or an INSERT ... FROM, it will save you heaps of time to check the SELECT separately:

SELECT

...

You're welcome Steve, thanks...

Hi Lorna

something like this should do the trick:

-- If the row has been amended, then the amended date will not be null; use the amend date.

-- If the row has...

Karthik

From BOL:

In the following table, the column on the left represents the style value for money or smallmoney conversion to character data.

Value Output

0 (default) No commas every three digits...

carlos.tapadinhas (11/18/2008)

---

Hello to all,

I have a big problem and i cant resolve, i have one sp that insert on a table, but sometimes inserts two rows with the same results...

Aw Jeff you should know me better than that!

This...

WHERE t.N BETWEEN CHARINDEX('(',@String) +1

...

You had it on the nose though! I'd still like to see the data, reckon there's something...

eflynn (11/17/2008)

---

Nearly worked! I got rid of the column, but now it gives me the error:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'VOID'.

hmm..

PS: Thanks...

Hi Chris, don't mean to tread on your toes but the group by requires the whole expression used to generate the new column, rather than the name of the new...

Some sample data from the table "timberstands" would be very handy too!

Hello

The syntax for UPDATE is

UPDATE tablename SET columnname

You have a columnname in place of a tablename:

db1.dbo.Users.WebLoginID

This will probably work, though it's untested:

UPDATE u SET WebLoginID = "VOID"

FROM db1.dbo.Users u...

Liam, you need to join the states table twice:

SELECT m.member, h.HomeState, m.WorkState

FROM master m

LEFT JOIN States h ON h.[ID] = m.HomeState

LEFT JOIN States w ON w.[ID] = m.WorkState

Cheers

ChrisM