Recent content by Sammy145

Hi Guys, Is there a way to customize the ribbon to have the Paste Special Coloumn Widths option as a button on the toolbar rather than a couple of clicks . Cheers Sam

Figured it out using subquery to next next row.

Hi guys, Table structure Groupid value 1 0.91 2 1.2 3 0.2 4 1.6 I need to sumamrize the table. Add new coloumn-Summarygroupvalue2 Groupid value Summarygroupvalue2 1 0.91 0.91+1.2 2 1.2 1.2+0.2 3 0.2 0.2+ 1.6 4 1.6 1.6...

Thanks drlex & Rofeu for looking into this and coming up with a solution much appreciated.

Drlex Tested and your query produces what I need. I did mange to get the previous row by using this query below. I have amended it to your table drlex BUT wasn' able to work out how to get the next criteria's such as 3 races or 6 ps I can use multiple temp tables for this requirement. With...

could we use a lookup table that had Raceid AND SORT BY ASC Sam

Any HELP Please ????

Yes it's a tricky one Here what i would expect as coloumns dogID |Finish position|RaceID|WinnerLastrace|Winnerlast3|winlast6 1 | 1 3 No No No 1 | 1 4 Yes No No 1 1 5 Yes...

Hi mate, not for school for a job. Sam

What do u mean a class? I need to work on a query that does this TSQL All i want to return is for points 1 an 2 is YES and for point 3 NO

I need help in working out of a list of 100000 dog races, which dog has won there races what i need is 1. winner of Previous race (needed as coloumn (Yes/No) 2. winner of previous 3 races (needed as coloumn (Yes/No) 3. winner of previous 6 races (needed as coloumn (Yes/No) Finish position =...

sql 2005 i created a c# solution thanks

Hi what i want is query that will update all children to 'N' if the parent [ACTIVE] field is 'N', i want all children to be ACTIVE ='N' --The hierarchy can be 10 levels down --parent is 0 for top level CREATE TABLE [dbo].[Hierarchy]( [ID] [int] IDENTITY(1,1) NOT NULL, [ParentID] [int] NULL...

Hi I have 1 question Question1 : I have a gridview with textbox in the header and item template. What I need help with is how do I populate the items but placing numeric values in the header. so if I put 10 in the header i want all the item textboxes to have 10. Thanks for any help in advance

bath is a parent of bathsuba NULL -->BATH ---->bathsuba