Heya !!! It's working again!

Blame it on the language barrier. I thought, your question wasn't meant seriously. I guess I got confused by this "Riddle me this batman..." phrase.

That's unfair!

select

 getdate()

 , datediff(ss,cast('7/4/2004' as datetime), getdate())%60

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

2004-12-28 16:00:59.590                                59

(1 row(s) affected)

Now add 1 and get 0 => No time difference between both date. q.e.d.

...btw, I suspect nobody ultimately knows now when the next version will be out.

See, if this will get you started:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx

Ouch, getting lazy...

No, it's just to let you score your 300 posts

Yes,I know! Your fellow swedish MVP's Erland and Tibor told me that it's getting dark around 15:00 during winter. They thought I'm crazy to even consider moving to Sweden.

but what if this is for some kind of duration measurement? Might sound strange, but who knows. And in that case resetting the minutes to 0 is really smart, since...

That's right, but why would you bother to extract the seconds out of a DATETIME and add 1 if if all you really want is to add 1 second to the...

Basically the same as Kenneth, but this time using only integer operations

WHERE

>= DATEADD(d,DATEDIFF(d,1,getdate()),0)

AND

<DATEADD(d,DATEDIFF(d,0,getdate()),0)

Probably this will help a bit:

http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sharepoint.portalserver&cat=en_US_83e04c41-7fdb-48f6-b800-63cf29f18bc0&lang=en&cr=US

No, you can't use dynamic sql within a UDF. You need to try to workaround this.

Since all sourcecode can be found in syscomments you might want to try to query this table. Have you searched the script section here already? It's likely that someone else...

Try to avoid this dynamic SQL if you can. To answer your question, try:

USE PUBS

GO

DECLARE @stmt nvarchar(4000)

DECLARE @rowcount bigint

DECLARE @table nvarchar(255)

SET @table = 'authors'

SELECT @stmt = 'SELECT @count = COUNT(*)...

From my own experience, it helps having a sticky topic with general guidelines or a link to them, such as:

• Search BOL before you post. BOL can be downloaded for free...