I have my difficulties with the last book http://www.sqlservercentral.com/columnists/fkalis/reviewofreviewofsqlserver2000administratorscompani.asp

Well, although BOL is a given, it is seldomly used as much as it should be. It is definitely the first...

Sorry, wasn't aware that you've already replied while I was reading and typing.

Not to be combative, but you might want to read about the basics of stored procedures and sql injection BEFORE it hits you.

More than one way to skin that cat:

declare @time varchar(10);

set @time= '09:00:00'

SELECT DATEADD(d,DATEDIFF(d,0,getdate()),0)+CAST(@time AS DATETIME)

SELECT CONVERT(DATETIME,CONVERT(CHAR(8),GETDATE(),112))+CAST(@time AS DATETIME)

SELECT CONVERT(CHAR(8),GETDATE(),112)+CAST(@time AS DATETIME)

SELECT CAST(CAST(GETDATE() AS VARCHAR(12)) AS DATETIME)+CAST(@time AS DATETIME)

SELECT CAST(FLOOR(CAST(GETDATE()...

Just for the records. Did you try the statement you posted as topic subject?

select getdate()-1

------------------------------------------------------

2004-12-13 10:00:34.750

(1 row(s) affected)

If I see this right, you can't use this alias, but rather need to repeat your formulas.

Hmpf, too quick...

Wouldn't this do the job?

If( select count(*) from authors)>0

 print 'Heureka'

else

 print 'damn it'

No, none built-in that I'm aware of. Based on your example, what checking should this do?

Hm, I would rather use one single filegroup for all tables and indexes and spread this over as much disks as possible. That way you are more likely to get...

Kenneth and Razvan, do you mind me putting your solutions and their equivalents for use with the German versions along with credit to you , of course, on my site?

...but one question remains to be answered.

What has "Carpal tunnel" to do with 4,000 posts?

Hehe, I enjoyed this discussion. Now, if I were to develop this from the start, I wouldn't use VB6 anymore. Not sure, if I would use VB.Net. I think I would...

When you compare what is wanted, and what your nice solution produces, are you sure this is correct?

With yours I get:

1           1

2           2

3           1

3           2

4           3

5           1

5           3

6           2

6           3

While...

Typically for this app, I have a form with about 5 or 6 comboboxes, which are dependant on each other. In the Click() event, the value is determined and used...

Dale, what a nice suprise!!!

You've updated your profile pic once again, since I last saw it. I like that.