Thanks for the reply Markus!

Though now I can see which web server is initiating this login, I stopped that web server and now I can see same activity from other...

The same stuff happened to us as well, though I was able to close the SQL Injection but I think hacker is still trying to execute SQL Injection via some...

Have a look on http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/[/url]

Try this

DECLARE @Limit DATETIME

SET @Limit = '2007-11-02 14:00:00'

SELECT

a, b, c

FROM

tbl1 LEFT OUTER JOIN tbl2 LEFT OUTER JOIN tbl3, LEFT OUTER JOIN tbl4

WHERE

tbl1.TimeStamp >...

I'm not sure about the performance, but you can achieve order in view by using CTE

create view vLogin

as

with cte as

(

select *

,rowid=row_number() over(order by loginid asc)

from login.dbo.login

)

select*

fromcte

This is allowed and works...

I understand what you mean, but as you also know it's not possible to change DB design very often.

9096 NOT IN

9865 NOT EXISTS

8954 OUTER JOIN WITH NULL DETECT

9816 EXCEPT in SQL 2005

Just in case,

SELECT RowNum

FROM dbo.JBMTest

EXCEPT

SELECT RowNUM

from dbo.JBMTest2

And I...

very funny!!!

I was about to add when asking my question that please don't advise using LEFT OUTER JOIN as I found this sometimes taking same time as NOT IN but EXCEPT....

If this is the only solution then I would say, do what Chirag has suggested, though I'm not a big fan of dynamic sql. Try using sp_executesql to run dynamic...

I think you can do this in SQL 2005 using cross join or cross apply and pass field value to function, but at the same I think your function should...

I agree with all of you about IN is bad and NOT IN is worse. I've got alternative for IN i.e. using INNER JOIN or EXISTS but what is the...

Just 19 parameters, one of developer at our place has used 127 parameters in one SP to update data and once spent 4 hours just to identify with which parameter...

If I understand correctly then unfortunately your guess is not right, SQL server doesn't add any parameters on its own.

Thanks Peter, that's what exactly I was after. And I wasn't really interested in using loop.

Thank you very much!