Viewing 15 posts - 1,291 through 1,305 (of 3,543 total)
...However, Barry, Grant, and Jack were actually talking about the Overall Leader Board...
And I can't believe I'm 16th 😀
Mind you that will probably won't last :crying:
October 7, 2009 at 2:24 am
Jeff Moden (9/3/2009)
.enots ot nrut t'nod I os rorrim a hguorht siht ta gnikool yllautca m'I ...denrawerof neeb d'I 😉
:crazy:
iday eenbay orewarnedfay... imay actuallyay ookinglay atay isthay oughthray a irrormay...
September 4, 2009 at 1:32 am
Lynn Pettis (8/27/2009)
... is just as you say; someone else comes along and just provides an answer, which defeats what we are trying to accomplish.
:ermm: must be why I am...
August 28, 2009 at 2:02 am
Or set [date] to the first of the month desired and use
SET DATEFIRST 1
SELECT DATEADD(day,7+7-DATEPART(dw,[date]),[date])
August 25, 2009 at 6:55 am
If it is a one off then
make sure no one is able to update the table
Add an identity column
ALTER TABLE Test ADD TempID int IDENTITY(1,1)
Repeat the following update until...
August 25, 2009 at 6:10 am
drew.allen (8/24/2009)
August 24, 2009 at 11:03 am
If what you posted is interpreted as 'result should show the 2 rows which contains the digit 2' then
Select * from table where ','+col+',' LIKE '%,2,%'
and
Select COUNT(*) from table...
August 24, 2009 at 5:47 am
GilaMonster (8/13/2009)
Can anyone help this poor chap create some ' recommmendations'?http://www.sqlservercentral.com/Forums/Topic769924-146-1.aspx
How about recommmending the recommmendation's recommmendation is to recommmend the recommmendation of supplying recommmendations for us to recommmend the recommmendation's...
August 13, 2009 at 2:13 am
Kit G (8/11/2009)
But it is one of my favorite Heinlein books.
I like Starman Jones. I read it over and over again.
August 12, 2009 at 5:00 am
GilaMonster (8/6/2009)
Not a case-sensitive problem. Usernames are identical. How on earth that happened, I don't know...
Not username but nickname. Nicknames can be anything including the same as someone else.
Profile states...
August 7, 2009 at 2:20 am
Heh... ok, David. Do you want BBQ or Smoked
Oh definitely BBQ, messier 😛
I am intrigued as to why as well 😀
I only tried a solution because I need the practice...
August 7, 2009 at 2:00 am
Not wanting to incure Jeff's wrath (let alone pork chop) but I wanted to get his opinion on my solution 😀
SELECT
CAST(MAX(CASE WHEN (RowNo-1)%3=0 THEN Empno ELSE NULL END) as varchar)...
August 6, 2009 at 10:25 am
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
WOW! Jeff :w00t:
What tablets you on...
August 6, 2009 at 1:55 am
. (7/30/2009)
Currently I'm more of a mathematical concept than a name.
Whether the point be there
Or whether the point be not.
We'll point the point,
Whatever the point,
We'll point it,
Like it or not!
July 31, 2009 at 1:54 am
Viewing 15 posts - 1,291 through 1,305 (of 3,543 total)