I don't know what to do? is it a real task or it is fake?

did anybody see something like this? Is it possible that a virus has created this job?

Dear Dev,

As you said it is Windows XP service, not sqlserver2005 job running on windows server 2008.

I'm shocked!

I have Changed my query to avoid cross apply because of the efficiency and I want my query to be like this:

select ... from #The Huge Query#

left join (select top...

This is the Original function body:

DECLARE @POIid int

set @POIid= (select top 1 DMSPurposeOfIssueTbl.POIDescription

from DMSRequestDocListTbl

inner join DMSRequestTbl on DMSRequestDocListTbl.RequestCode = DMSRequestTbl.RequestCode

and RequestTypeID in ( 8,9) and DocRevID =...

Dear Sean Lange,

Just another Issue is bothering me...

How can I implement top 1 in my joins?

In my function I have a select like this:

set @retval =(select top 1 col1 from...

Dear Sean Lange

Thanks for reply, If there is no other way, I will use joins... thanks alot...:(

Dear Dev, Grant Fritchey and ChrisM@Work ,

Thanks for reply,

I've read some articles about cross apply, every body said that cross apply is less efficient.

I need something to work like...

Dear Dev,

Thanks a lot, I've seen the link you sent , I know how to select data from that function, I don't know how to use it like a...

Thanks Dev For Fast Reply, It is Great , but how can I use it in My select Query?

It should be a part of that...

@gilamonster, thanks for fast reply. As you said, I'm reading some articles about this, and I wanted to know what experts like you prefer.

That almost sounds like 'I'm...

@gilamonster: could you please describe more?

As I see , This is not only my problem:D

Any Ideas?

If you think UserID is better please tell me.

I prefer userID because it takes only 8 byte and also because of data validation. but some people say...

@Gianluca Sartori

Do you have Mr.Codd enlightening paper.

If yes please send it to me or give me a link.

@steveB. :

Thanks dude for reply ,but actually it was not about comparing nvarchar and varchar,

What I mean was to compare datetime VS string fields.

Dear mates,

First of all , thanks for reply,

I will tell some thing more to you just right now;)