If the last suggession is right then yucan use:

ALTER DATABASE [MyDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

... Some actions ...

ALTER DATABASE [MyDatabase] SET MULTI_USER

GETDATE() is not allowed insede UDF.

And it's good. It force you to make your code better.

This function is more universal: it will return exprerience on any given date.

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

create function dbo.get_xperience

(@empno...

DROP INDEX ...

DROP INDEX ...

DROP INDEX ...

(Except clustered index)

INSERT INTO ...

CREATE INDEX ...

CREATE INDEX ...

CREATE INDEX ...

Suppose you have the table called TableA and the type of check-in date is char:

(almost like your example, just some dates are changed)

TableA

pid RoomNo ...

Try it.

Reading of this topic

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

will probably help you.

I believe Best was talking about EM.

What's a point of collecting huge amount of data on some server where you cannot get any use of it?

If you mean to work out the data in another place...

Read about syscolumns in BOL.

Your answer in there.

What's a point?

If B.OCCUSEQNO is a number then CAST(B.OCCUSEQNO AS VARCHAR(9)) will return absolutely the same string as CAST(B.OCCUSEQNO AS VARCHAR(1009))

Left join table tblAttach to itself on A1.PoleID = A2.PoleID and A1.AtHeight < A2.AtHeight

Try use APP_NAME() inside the code executed by Job.

It will return string like this:

SQLAgent - TSQL JobStep (Job 0x{Job_ID} : Step {N})

Let me know if you need further explanations.

Are there empty strings somewhere in those numeric columns?

Empty string cannot be converted to int. You must use NULLIF(COL_STR, '') to make it NULL.

Check data in the file. There must...

> e.g. select * from "master"."DBO"."Sysobjects" will work in any SQL Server

It will not work on SQL Server 2005.

I was replying not on your post.

It was a reply in 7-bit ACSII restriction approach.

See the quote I put in my post.

If you consider this you probably don't need any...

What about reports?

What about "FOR XML" statements?

Can you dictate the names used there?

I guess you cannot. Even if you are CEO in your company.

Because those reports go to other companies...