Viewing 15 posts - 1,006 through 1,020 (of 1,082 total)
HI There,
I found this in BOL:
This setting is used only in the interpretation of character strings as they are converted to date values. It does not affect the display of...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 14, 2007 at 2:50 am
HI There,
Could you send me the data in your table?
I'm think that some of your Date_On_List, fields are not in the format you descibed.
Here is the code I used:
---------------------------------------------- :w00t:
Try to learn something about everything and everything about something. - Thomas Henry Huxley
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 14, 2007 at 2:46 am
Hi there,
This looks messy so I will try and find a better way to do it.
SELECT
CONVERT(DATETIME,(RIGHT('23/07/2007' ---------------------------------------------- :w00t:
Try to learn something about everything and everything about something. - Thomas Henry Huxley
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 14, 2007 at 2:35 am
Have you tried using
TOP
or
PERENT
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 14, 2007 at 12:44 am
Hi,
Sorry please ignore my first explination as I didn't see your order by clause!
I am also now asking myself why your way isn't the correct way to do it.
I have...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 13, 2007 at 4:55 am
Hi Edmund,
Sorry that explination was incorrect please ignore my last post!
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 13, 2007 at 4:49 am
🙂
Lets say for example the data in our tables was stored in an order on disk that was not what we expected it to .
for example the 1st records was...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 13, 2007 at 4:43 am
HI Edmund,
Your method does not guarantee that you will get the status with the maxdate.
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 13, 2007 at 4:32 am
Hi There,
What I mean is that I can actually run a select on the view.
I think if you want to see it under the Database you need to grant the...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 13, 2007 at 12:16 am
Hi there,
As far as I remember case statements are the only way in SQL2000
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 12, 2007 at 8:33 am
There a re few ways to do this.
SELECT
CONVERT(VARCHAR(13),GETDATE(),11)
---------------------------------------------- :w00t:
Try to learn something about everything and everything about something. - Thomas Henry Huxley
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 12, 2007 at 5:47 am
HI Scott,
Is what I used to recreate what you are trying to do.
You'll see where you need to Add any other Coloumns such as [Item D] etc
CREATE TABLE SubQuery
---------------------------------------------- :w00t:
Try to learn something about everything and everything about something. - Thomas Henry Huxley
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 12, 2007 at 5:42 am
Are you using SQL 2005?
If so try using a pivot
If you not sure how to do that give me a shout.
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 12, 2007 at 5:16 am
Hi there,
You shouldn't need to grant perms to the table.
Here is the code I ran and it worked 100%
CREATE
TABLE Courses
(ID...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 12, 2007 at 4:50 am
Hi there,
What format do you want?
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 12, 2007 at 4:44 am
Viewing 15 posts - 1,006 through 1,020 (of 1,082 total)