Viewing 15 posts - 47,866 through 47,880 (of 59,064 total)
Jeff Moden (10/7/2008)
karthikeyan (10/6/2008)
if you have datetime column in your table, then select max(datetime column) from will give you the expected result.
No... if someone happens to do an...
October 7, 2008 at 6:41 am
I'll use a quote that I heard a long time ago... "The internet is a well paved on-ramp to a dirt road." If you put personal information out there,...
October 7, 2008 at 6:40 am
Ahmad Osama (10/7/2008)
Hi All,Here are few interview questions..
1) Is it possible to have a NULL value in a foreign key field?
Already been answered several times...
2) If I have 350 columns...
October 7, 2008 at 6:20 am
My preference is to store the JPG.s in a directory and store the file name in the server for such a requirement. The reason for this is that it...
1....
October 7, 2008 at 6:04 am
dr_csharp (10/6/2008)
GilaMonster (10/6/2008)
DECLARE @MaxID INTSELECT @MaxID = Max(ID) FROM Customer
which one is better :
i save @@Identity in a field when record insert in Table and i read saved id...
October 7, 2008 at 5:48 am
vidhyasudha (10/5/2008)
Hello,Can we pass array to t-sql procedure? If so how.
Cheers
As well as the link Vijaya posted, please check out the following, as well...
October 7, 2008 at 5:42 am
proudfoot.richard (10/7/2008)
I got round it...
October 7, 2008 at 5:40 am
Clint,
This is a "running balance" or "running total" problem and there are lots of methods to pull it off including some really slow triangular joins, cursors, and While loops. ...
October 7, 2008 at 5:30 am
Sure... the criteria to add to your query would be ...
WHERE yada-yada
AND Location NOT LIKE (SELECT '%'+Word+'%' dbo.FROM ExcludeTable)
October 7, 2008 at 5:23 am
zypsy (10/6/2008)
SELECT billdate,custcode,custname,
MAX(CASE WHEN Seq=1 THEN brand ELSE NULL END) AS brand,
MAX(CASE WHEN Seq=1 THEN item ELSE NULL...
October 7, 2008 at 5:16 am
Have the time? Heh, what did you do? Make a clone? 🙂
October 7, 2008 at 4:41 am
I saw the title of this one and immediately thought "Hmmm... I'll just bet Gail is at the heart of this announcement."
October 6, 2008 at 9:38 pm
Dang! I'm not sure how it happened, but I missed the whole gambit of 9/22 posts! Very well stated, folks. Well done.
And, you, Mr. Burrows, have never...
October 6, 2008 at 9:32 pm
clint_pow (10/6/2008)
Its really amazing how it goes, I really appreciated it at last I can incorporated it with some of my query. How I wish I have a knowledge of...
October 6, 2008 at 9:26 pm
Might not be a mistake on your part... seems to me that, way back when, what you say used to be the truth and they fixed it.
October 6, 2008 at 9:22 pm
Viewing 15 posts - 47,866 through 47,880 (of 59,064 total)