HI Mark,

Please could you post your select statement so that we could have a look at it for you.

Thanks

Chris

Thanks that is 100% perfect.

I should haev done more research before posting sorry

what value are you using for card number?

Sorry about my previous post I didn't read everything you first wrote 🙂

this will work on SQL2005.

SELECT

Col1,Col2,Row_Number()...

Are you basically looking to add an Identity Col?

if so try this

ALTER TABLE dbo.TestTable ADD

Col3 int NOT NULL IDENTITY (1, 1)

GO

Hi There,

When you are setting up your dataset and you execute it from teh datasets tab. How many rows do you get?

If you get the number you expect then I...

I'm confused as to why you are expecting more records if only one of the dates match?

Sorry Joel,

I got very confused there for a second.

You didn't ask for anything to do with triggers my mistake

😉

HI Joel,

This will give you all teh triggers

SELECT Text

FROM sysobjects o

INNER JOIN syscomments c

ON o.ID = c.ID

WHERE xType = 'tr'

I'll start looking into the others for you now as well.

Thanks

Chris

Which Query?

Could you confirm the data in the two tables for me please?

I created the two above tables and added my own data.

and the queries seemed fine.

Thanks

Chris

SELECT [D].[ID],[D].[Date],HRS_WKLY,SAL_WKLY

FROM DAily_Activity [D]

LEFT JOIN Sal_WKLY [W]

ON [D].[Date] = [W].[Sal_Eff_Date]

If you this one then you will get all the Dates from your Activities table even if there is no Slry...

TRy this:

SELECT [D].[ID],[D].[Date],HRS_WKLY,SAL_WKLY

FROM Sal_WKLY [W]

INNER JOIN DAily_Activity [D]

ON [D].[Date] = [W].[Sal_Eff_Date]

Hi Trystan,

Someone posted a similar question last week.

See if this post helps:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=383149#bm383204

thanks

Chris

Hi there,

Would it work if you jsut needed to know if the player was still there, or if they left during the season, I think this might take care of...

Hi Marianne,

I agree this site is very good for helping people as well as learning.

Seeing as though you are keen on learning,

try reading up about the following clause in SQL,...