you can also try using RANK() function 🙂

http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm

check this link out, this says the process of setting up the mail on SQL server

🙂

Hi

I am not sure about the limit, one way you can do is to loop through the table that have the mail id...

Hi Syed

How huge are we talking here, in the case you have mentioned,how about using a left outer join...

Are you restoring on the same server or on...

Hi Judy

Are this separate jobs, or its on a job that runs after the first once have completed

hmm why dont you try to take out the distinct values from your subquery result, something like

select distinct (x.a) from

( select a from #temp1

Union all

Select a from #temp2)x

Hope...

try

DELETE FROM Member

WHERE Email in ( 'email@email.com' , 'email2@email.com')

sorry i cant get your post, are you trying to say that you need to display top 10 records from your table and then the 11th record must follow the...

Increasing RAM alone does not boost performance for your systems, There are various factors...

Hi charles

What exactly are you trying to do with the SQL, if you want a query that starts...

I agree on that Dave, Every one learns something new every day, and as...

hi

i assume its a one off task, check the SPID from SP_WHO2 or from activity monitor and use Kill to kill...

Thanks Tom, i am looking for the first one B7==, As you said you can do this on C#, but i am just wondering if there are any other ways...

Ha ha ha :w00t: