Here's a quote from BOL: "Built-in nondeterministic functions are not allowed in the body of user-defined functions." Getdate() is, of course, non-deterministic, as it "may return different values when...

Your update query does not contain a WHERE clause. So what you are saying is

"If there are any records returned by the SELECT ... query, execute the following update...

Popular question! Check out this link:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=145515

Excuse my English ignorance, but is 12 the country code for Mexico? If so, wouldn't you want to store these numbers as + 12 ... ? If so,...

declare @str varchar(20)

set @str = 'a b c d'

select @str as orig_string, replace(@str, ' ', '') as no_spaces

Regards

Phil

No. Each table can (by definition) have only one clustered index - and whether that is on the table's primary key field or on some other field is down...

The maximum worksheet size in Excel is 65,536 rows by 256 columns, so it sounds like you have hit that limit. However, you can of course have multiple worksheets...

I've had this and did not find a straightforward solution, so in the end I worked round it. But, as an alternative to having a dynamic filename, you might...

If 'first' = 'min' and 'last' = 'max', then this will do it:

select min(name) as 'first', max(name) as 'last'

from

where mark = 20

Regards

Phil

OK, assume that table 'tbl' contains two fields, 'utc' and 'date'.  utc is populated, but date is empty.  Here is a query that will populate date from utc:

update tbl

set date...

I think we were both referring to the ASC(AS(X,3) bit, which does not contain a trailing 'C'. I actually think you might have meant A$, rather than AS. ...

Hi John, your message is a bit terse. Please provide sample data and how you would like it to be sorted.

Cheers

Phil

So you want

200, 300, ...

as your resultset? If so, what does table 1 do?

Cheers

Phil

It's easier than you think - you're already on the right track. Try this:

declare @utcdate as float, @cvdate as datetime

set dateformat mdy

set @utcdate = 38279.813344907401

set @cvdate = @utcdate

select @utcdate...

Missed that. I have no idea what the as() function does. Any ideas, anyone?

Phil