There's a way to call a Stored Procedure from a Function, but it's not very clean.

You can create a Linked Server pointing to the sql server itself and call it,...

Matt Whitfield (9/13/2009)

---

Hello all - I've been informed this is the place to post up a request for some really experienced SQL Server users... 🙂

To cut a long story short...

dma (9/11/2009)

---

And the stories on employer thinks you are attractive to recruiters because you attend courses...wow..really I would not work for anyone like that, and am genuinely sorry that some...

You must be joking, right?

I wouldn't compare Firebird to SQL Server, way too many differences between them.

I'm...

I had to do the exact same thing you're doing and I had no chance other than storing to the DB.

One way to avoid this would be linking an image...

There's an italian parody of teletubbies, called turbotubbies.

It's a shame you don't speak Italian, they really are funny.

http://www.giardiniblog.com/2009/03/12/turbotubbies-colorado-cafe/

That's what I suggested: read the article I linked.

It explains how to create an image using the barcode font. Once you have the picture, you can save it to...

Did you try EXISTS?

Select distinct name

from myTable

where NOT EXISTS (

select 1

from myAnotherTable

where productCode = 'SomeProduct'

...

Who's Teletubby?????

Did I miss something?

That's what I was trying to say, with the almost same words...

... if it still is allowed...

Silverfox (9/11/2009)

---

Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says exactly the same as...

How many bottles of beer on the wall?

ta.bu.shi.da.yu (9/11/2009)

---

I agree with Ian in that Paul is correct to agree with my agreement with Silverfox. Honestly! Why do people keep reiterating over...

Ian, I don't have words enough to thank you for this trick.

I would really be interested in knowing where you got this from.

You question is not very clear to me, but I think this should do the trick:

SELECT MIN(id), Product, COUNT(*)

FROM MyTable

GROUP BY Product