If you have no concern with what tiem the entered_datetime field is just want to see for day then try this.

DATEADD(d,DATEDIFF(d,0,appt.entered_datetime),0) between DATEADD(d,DATEDIFF(d,0,@start_date),0)

                               and DATEADD(d,DATEDIFF(d,0,@end_date),0)

Try this

UPDATE MET SET abc = EQ.xyz

FROM

MET

INNER JOIN

EQ

ON

EQ.EQNO = MET.EQNO

WHERE MET.[DESCRIPTION] = 'AAA'

ORDER BY ISNULL(fld,'zzzzzzzz')

This only works thou if you know there will be no value over 'zzzzzzzz' such as 'zzzzzzzzz'.

To always be sure I get my nulls at the end I...

Either you can wrap in a function like so (especially if using SQL 2K)

CREATE FUNCTION dbo.Is_Uniqueidentifier (@valCheck VARCHAR(36))

RETURNS bit

AS

BEGIN

DECLARE @outVal AS bit

-- Return 1 for true

-- Return 0 for false

--...

There is no row number functionality in SQL Server (at least at this time). However you could try using a Subquery to order the data and produce the count of...

First off GETDATE() is inherently datetime as far as data type.

Try

select cast(getdate() as smalldatetime)

and you will get the same results of not having seconds in the output.

The reason is...

Indexdefrag creates the smallest Log footprint between the two from what I have seen. However looks like you may have a space issue altogether. If you have a VLDB and...

Which are you refering to? The aritcle or the above SP code? Is there something specific you question. As for "will not pick up the 'local' server if it is...

It's going to boil down to where it is executing from. For instance I do it on a Dev Ed on my machine here locally and I get the data...

Unfortunately currently the Import/Export Wizard does not expose the options to do what you are asking. However in SQL 2000 bcp does have a FIRE_TRIGGERS hint you can use. But...

Note: Until it is updated there is a correction to the code.

dim App, cntServ, cntGrps

Set App = CreateObject("SQLDMO.Application")

For cntGrps = 1 to App.ServerGroups.Count

    For cntServ = 1 To App.ServerGroups(cntGrps).RegisteredServers.Count

  MsgBox App.ServerGroups(cntGrps).Name...

Personally I think they should put the beta out for the public to download, or request since there are some many new features. The only people who will be ready...

Actually your comment is valid in that you could change the CONACT_NULL_YIELDS_NULL value OFF and it would have caused the entry to be 'tr' which would have still caused the error...

The comments on the answer should have pointed out that the left join is causing all rows to update to be more pointed in the reason. As is the comment...

No it itself does not. But you could download the 120-day trial of SQL which includes Enterprise Manager and Query Analyzer and use both to connect to the msde copy....