Viewing 15 posts - 1,051 through 1,065 (of 1,082 total)
HI Mark,
Please could you post your select statement so that we could have a look at it for you.
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 8, 2007 at 6:46 am
Thanks that is 100% perfect.
I should haev done more research before posting sorry
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 8, 2007 at 3:51 am
what value are you using for card number?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 6, 2007 at 8:24 am
Sorry about my previous post I didn't read everything you first wrote 🙂
this will work on SQL2005.
SELECT
Col1,Col2,Row_Number()...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 6, 2007 at 8:16 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 6, 2007 at 7:17 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 2, 2007 at 6:32 am
I'm confused as to why you are expecting more records if only one of the dates match?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 26, 2007 at 9:58 am
Sorry Joel,
I got very confused there for a second.
You didn't ask for anything to do with triggers my mistake
😉
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 26, 2007 at 9:34 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 26, 2007 at 9:32 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 26, 2007 at 9:13 am
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 to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 26, 2007 at 8:44 am
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]
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 26, 2007 at 8:26 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 26, 2007 at 8:22 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 24, 2007 at 8:04 am
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,...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 19, 2007 at 10:28 am
Viewing 15 posts - 1,051 through 1,065 (of 1,082 total)