Viewing 15 posts - 4,846 through 4,860 (of 5,393 total)
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,...
-- Gianluca Sartori
September 14, 2009 at 2:24 am
Matt Whitfield (9/13/2009)
To cut a long story short...
-- Gianluca Sartori
September 14, 2009 at 1:58 am
dma (9/11/2009)
-- Gianluca Sartori
September 14, 2009 at 1:35 am
Alex (9/13/2009)
Except for Firebird, which is free, and "broadly capable" enough for many applications
You must be joking, right?
I wouldn't compare Firebird to SQL Server, way too many differences between them.
I'm...
-- Gianluca Sartori
September 14, 2009 at 1:26 am
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...
-- Gianluca Sartori
September 11, 2009 at 7:50 am
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/
-- Gianluca Sartori
September 11, 2009 at 7:35 am
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...
-- Gianluca Sartori
September 11, 2009 at 7:11 am
Did you try EXISTS?
Select distinct name
from myTable
where NOT EXISTS (
select 1
from myAnotherTable
where productCode = 'SomeProduct'
...
-- Gianluca Sartori
September 11, 2009 at 6:59 am
Paul White (9/11/2009)
Though I must say that I agree with Ian Scarlet, Silverfox, and teletubby.
Who's Teletubby?????
Did I miss something?
-- Gianluca Sartori
September 11, 2009 at 6:52 am
GSquared (9/11/2009)
In all seriousness, what it adds is more weight to the answer given.
That's what I was trying to say, with the almost same words...
... if it still is allowed...
-- Gianluca Sartori
September 11, 2009 at 6:47 am
Silverfox (9/11/2009)
-- Gianluca Sartori
September 11, 2009 at 6:43 am
How many bottles of beer on the wall?
-- Gianluca Sartori
September 11, 2009 at 6:09 am
ta.bu.shi.da.yu (9/11/2009)
Ian Scarlett (9/11/2009)
Paul and Silverfox are correct.
I agree with Ian in that Paul is correct to agree with my agreement with Silverfox. Honestly! Why do people keep reiterating over...
-- Gianluca Sartori
September 11, 2009 at 6:08 am
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.
-- Gianluca Sartori
September 11, 2009 at 4:29 am
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
-- Gianluca Sartori
September 11, 2009 at 2:57 am
Viewing 15 posts - 4,846 through 4,860 (of 5,393 total)