Jeff, your solution is working perfikly for me, thank you once again for the excellent help and advice. And thank you to Seph and Chris too!

Steve

Chris Morris (11/17/2008)

---

Jeff Moden (11/14/2008)

---

Try the following...

SELECT COUNT(*) FROM Master.dbo.SysColumns

If it doesn't work, there are one of two problems... either you don't have the privs to read from the master...

Msg 208, Level 16, State 1, Line 2

Invalid object name 'Master.dbo.SysColumns'.

I think my master database is screwed 🙁

We did have some problems a few weeks back with a maintenance routine...

And the collation is Latin1_General_BIN

Oh and the code

--=============================================================================

-- Setup

--=============================================================================

USE tempdb --DB that everyone has where we can cause no harm

...

Version: 8.00.760

I got exactly the same error which is why I tried the other page which was originally given in the first reply.

Hi Jeff, thank you for suggestion, as always I am grateful for your help and the help of others, I will endeavour to make it easier to get help in...

The key thing here for me is making sure the data is correct in the first place. Creating this function has brought to my attention all the variations and errors,...

Chris Morris (11/14/2008)

---

Seth's is almost identical identical apart from the datatype of the return value. He did...

I prefer Chris's solution, it returns the decimal just like I needed 😀

Hi Seth,

Thank for a possible solution.

The data is in our sales system, its not something that can be changed. I am using the function in a view, this view is...

A quick solution that I have just figured out is this

SELECT item AS DuplicateItem

FROM (SELECT DISTINCT item, description FROM #Import) AS dImport

GROUP BY item

HAVING COUNT(item) > 1

IF @@ROWCOUNT < 1

BEGIN...Is...

After reading about MS Deploy the other day, for deploying IIS and its content to production servers, I thought its about time the same existed for SQL Server, and now...

Sorry for the lack of detail, it was the end of a long frustrated week where I...

Dooza (6/18/2008)

---

I spoke too soon, it doesn't work perfectly, each row is repeated for each price range, so I am getting 6 times as many rows as I expected when...