Search results for query: *

Hey, thanks John, I'll give that a try on Monday morning when I have to face this horrid problem again! I did notice you mentioned Access in your first post - did you get this working in SQL Server as well? Cheers, Mike

Anyone know if there's anything like in SQL Server 2005?

Thanks John, but as I pointed out in on eof my other posts the actual query I need to do this form is more complicated and uses a group-by which means I can't use ItemId as it's not in an aggregate. I've finally resigned myself to doing this whole exercise in C# with a recordset of the correct...

Damn, what a shame none of those exist in SQL Server!

Well, I did have another idea - instead of getting all the ItemID's that make up the group, I thought of assigning a single GUID (or ID column) to each row in each group, then later I can use my grouped data along with the unique GUID to identify the individual ShoppingCartItems I need. For...

Hi all, Given the query below... select Sum(Price), Max(PurchaseCurrency) from ShoppingCartItems where PurchaseCurrency is not null group by PurchaseCurrency ...how could I also get a text field containing all the ItemIDs (the ID column of ShoppingCartItems) for the grouped rows? I'd like to...

Thanks for that - we ended up writing a Flash MP£ player that does the fade for us but I might just check out your links and code etc and see what I can come up with. Cheers, Mike

Hi, I'm trying to write (or find) an application library which I can call from .Net web pages to take an uploaded MP3, extract the first 40 seconds from it and (most importantly) fade the volume out over the final 10 seconds. It's for a music site I'm working on where artists upload there own...