For such value, u need a Cut OFF date, from onwards, you can calculate the miiseconds till the required date, for example,

FirstDate = getdate() - 1

Seconddate = getdate()

Now, you can...

In Management Studio help menu, there is a direct link to9 the tutorials...

Short Cut: Ctrl+Alt+F5

Atif Sheikh

Job is the best solution...

make a Sp for you delete command. Make sure that the sp do not accepts parameters and no output parameter is used.

Associate this sp with a...

To be on the safe side, do takle care of the '(' and ')' when using mathematical expression.

Its not the case in your scenario, but COULD lead you to...

SET ANSI_NULLS Specifies SQL-92 compliant behavior of the Equals (=) and Not Equal to (<>) comparison operators when used with null values.

Can change the results if the column(s) used in...

Check for Browser Service running on both SQL Servers...

Also, the Remote connection are allowed on both servers.

Atif Sheikh

How about this code...

Declare @a varchar(10)

Set @a = '100+101+12'

while @a <> ''

begin

if charIndex('+',@a) > 0

begin

Select SubString(@a,0,charIndex('+',@a))

Set @a = SubString(@a,charIndex('+',@a)+1,Len(@a))

end

else

begin

Select @a

Set @a = ''

end

end

use Your Field name against @a variable

Atif...

What about the separator between the values...?

Go with the followinf case statement...

Select * from Customer_Repo

Order By

Case When @OrderColumn='CustomerName' Then CustomerName End,

Case...

Nicely Explained... the question needed such an explanation as all the options would have worked for the scenario but with some limitations and issues.

But I am still confused about DROPCLEANBUFFERS...

I think the best strategy is to create Clustered Index on a column(s) that gives you a unique value per row.

You should go for indexes on the columns that...

I think I accessed this post by SSC homepage....

I really didnt see the post started in 2005...

Atif Sheikh

http://msdn.microsoft.com/en-us/sqlserver/default.aspx

BOOKS ONLINE,

http://www.simple-talk.com/

Go to Google, type SQL Server and you will get alot...

ATIF SHEIKH

Oooops....

For your son, soft toys will be the best choice (for me atleast).

BUT, first two birthdays of your son / daughter(s) are dedicated to your wife and 3+ children (my...