Viewing 15 posts - 1,291 through 1,305 (of 3,544 total)
Just once I wish these folks would prove that they can break it without breaking the rules for its proper usage before they bad mouth this very old method.
Here! Here!...
Far away is close at hand in the images of elsewhere.
Anon.
October 9, 2009 at 1:58 am
...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:
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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])
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
August 25, 2009 at 6:10 am
drew.allen (8/24/2009)
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
August 24, 2009 at 5:47 am
How about this
(@i & 0xFFFFFFF7) ^ (@b * 8)
Far away is close at hand in the images of elsewhere.
Anon.
August 20, 2009 at 2:28 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...
Far away is close at hand in the images of elsewhere.
Anon.
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.
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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)...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
August 6, 2009 at 1:55 am
Viewing 15 posts - 1,291 through 1,305 (of 3,544 total)