Where you have multiple rows that you need to either display or report on as one single, concatenated field you can use the Coalesce function to merge them.

You can either do this in a stored procedure or create a function so it can be used inline in Select statements.

Below is an example of a function that will merge multiple policy numbers into one string containing them separated by commas.

CREATE FUNCTION dbo.fn_MergePolicyNums
(@HGNum as int)
RETURNS varchar(100) AS

BEGIN

declare @PolNums varchar(100) /* Holds multiple MEC numbers */

SELECT @PolNums = COALESCE (@PolNums + ', ' + PolicyNum, PolicyNum, @PolNums) FROM tblPolicy WHERE HGNum = @HGNum

RETURN ISNULL(@PolNums, '')
END

 

I've been looking for a portable solution every since the company I work for stopped letting us use laptops forcing us to go into the office and just work from there so I've been bored on the train with nothing but my iPod for company.  I needed something to keep myself occupied and since I no longer could work on company projects I thought I'd like to develop the many project I've had on my mind for ages and hopefully actually finish some of them.

I finally took the plunge last week whilst I was off work and scoured Tottenham Court road for the best deal on an ASUS W5, got it in black as the white ones looked a bit grubby even in the shops and I'm just not that cool to have a white one.  I'd looked around at all sorts of things, the UMPC's that are just coming out, the Apple MacBook, but they were either too expensive, too limited or in the case of the Apple, were very tempting but I just have too much dependence on Microsoft.  I knew I could dual boot but I just don't think I'd every boot into OS X so didn't see the point.

The Asus is very nice, big enough to be able to type on and see the screen yet small and light enough to fit in my bag and not stand out as a mugging opportunity or do my back in!

I'm a big fan of hibernation, finding it the best bet when pulling into Liverpool Street to be able to quickly save what I'm doing, and get back to it when I need to without waiting for a full re-boot.  The trouble was, I was getting an occasional message about "Insufficent System Resources Exist to Complete the API" and hibernation not working, requiring a rushed shut down or standby to get me off the train.  A bit of googling later and I find it's a common bug identified by Microsoft for pc's with more than a gig of ram in them.  There is a hot fix patch available but you have to phone Microsoft to request it.  I did the dutifull thing and tried ringing, got a "only in office hours" message, so then I went the web route but my oem version of XP Pro wasn't offered support.. so finally I googled some more and found the file available on numerous sites (presumably by other people who couldn't see the sense in not having access to this file).  I'm not going to post the file here as I'm not sure about the legal implications but if you want it, the exact filename is WindowsXP-KB909095-x86-ENU.exe which I'm sure using your favourite search engine you'll find in no time.