You mean an XP?

Well, actually our developers who code app to work with the data from one of our bank partners is bound by the bank to use VB5 and...

Yes, I also thought of this, but IIRC you need to be on SQL 2k to have it available, right?

OK, I'll try

It is this what you are looking for?

SELECT h.ItemNo, l.MaxOH - SUM(ISNULL(p.PQty,0)) AS QtyReq, 'Rush - 4...

or

SELECT SERVERPROPERTY ('productversion')

SELECT SERVERPROPERTY ('productlevel')

SELECT SERVERPROPERTY ('edition')

Hmph,...it seems that my laptop is too fast compared to your computer

As for the CreateDate of a row, simply put a DEFAULT of GETDATE() on the column.

As for the LastChangeDate I guess you will have to write triggers

I know! I'm a silent follower of the SQL2k mailing list

Formatting works somehow, but isn't that user-friendly.

Let's hope for the best!

Strike!

SELECT

settings

FROM

thisStupidWebThing

WHERE

easeOfUse IS NOT NULL

That's really sad, I really appreciate following your mails.

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

DECLARE @i INT

DECLARE @vNIL INT

DECLARE @szString VARCHAR(255)

SET @i=35

SET @szString=''

WHILE (@i>0)

 BEGIN

 SET @vNIL=@i % 16

 SET @i=@i /16

 IF @vNIL>9

  SET @szString=char(55+@vNIL)+@szString

 ELSE

  SET @szString=char(48+@vNIL)+@szString

 END

SELECT @szString

GO

SET QUOTED_IDENTIFIER OFF

GO

SET...

I agree that a trigger won't work.

The idea to schedule a job is good, but I wouldn't run this every morning.

What happens when someone gets 18 on a saturday...

sorry, replace print.... by select @a, @GradesCount

declare @a int

declare @GradesCount int

SELECT TOP 1 @a = StudentID, @GradeCount = Count(*) FROM Results GROUP BY StudentID ORDER BY Count(*) DESC

print @a + '  -  ' + @GradesCount

should work

would

SELECT TOP 1 StudentID, Count(*) AS No_of_Grades FROM Results GROUP BY StudentID ORDER BY No_of_Grades DESC

help

Please avoid double postings. See Allen Cui's answer here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=95240

This might serve as a starting point

SELECT

 a.id AS Tableid, a.Name AS TableName, b.name AS colName, b.colid AS colId,

 d.name AS constraintname, d.xtype AS constrainttype , e.name

FROM

 ((((sysobjects a INNER JOIN syscolumns b...