Tried on my machine too. Looks like ms forbids you to do this as it could become some kind of infinte loop or something like that. Maybe someone...

Here's another thaught: the in clause will kill the performance because the whole list will be scanned untill a match is found. Since

where 1 in (3,1,2)

is the same...

I also thaught of something similar but I didn't pursue it because I wanted a set based approach. This temp table solution would however be much faster than the...

try running this... it works for me :

CREATE FUNCTION [dbo].[ufn_WeekdaysBetween]

(@StartDate datetime, @EndDate Datetime)

RETURNS int

AS

BEGIN

DECLARE @Day1 int

DECLARE @Day2 int

SET @Day1 = Datepart(dw, @StartDate)

SET @Day2 = Datepart(dw, @EndDate)

DECLARE @dSunday...

Sorry but we don't see anything here.. can you just post the code and err message?

IF EXISTS(SELECT User_ID FROM dbo.User_Information

WHERE First_Name = @FirstName AND Last_Name = @LastName AND Email_1 = @Email)

begin

Select col1, col2... from YourTable

return 1

end

else

begin

return 0

end

This wouldn't be any faster than PW's solution. The advantage that PW's solution has is that an index can be used on the date because no modification has to...

Select C.company, E.fname, E.lname, ISNULL(e.Phone, C.phone) as Phone

from tblCompany C inner join tbkEmployees E on C.id = E.companyidfk

You just need to apply this technique to the insert/update statement you will...

Here's somthing to play with (I wouldn't recommend it on a 8 M lines table though).

SELECT O.XType

--, count(*) AS TotalHits_Found

, O.name

, (SELECT CEILING(COUNT(*) * 0.9) FROM dbo.SysObjects O4 WHERE...

One way to accomplish this would be to do a backup of A and restore to B.

This solution has already been posted, also if you only want the date portion you're still better off using dates than strings as they will compare must faster than varchars.

Have you actually run this statement??

select CAST(dateadd (d, 0, datediff(d, 0, getdate())) AS SMALLDATETIME)

I think that my version (well Frank Kalis' version) is prettier and actually will run much faster on larger datasets... it's just a matter of understanding what's actually happening under...

Select * from dbo.MyTable where

dateadd (d, 0, datediff(d, 0, MyDateField))

=

CAST(dateadd (d, 0, datediff(d, 0, getdate())) AS SMALLDATETIME)

NP.. R U normalizing your tables or just doing the select?