Database

SELECT table_1.PropID, FullStreetAddress, City, State, Zipcode, Remarks, Date, table_2.URL
FROM table_1 LEFT JOIN table_2 ON table_1.PropID=table_2.PropID
WHERE table_1.PropID IN
(SELECT PropID
FROM table_1
WHERE <your selection criteria>
LIMIT 60)

Uma Shankar Patel wrote:

select @DataID=MAX(taskid) from tblTaskAssign;
insert into tblJobs (taskid,taskname,completiondate) values (@DataID,@taskname,@completiondate)

DECLARE @DataID int
set @DataID = (select isnull(max(taskid),0) from tblTaskAssign)

   insert into tblJobs (taskid,taskname,completiondate) values (@DataID ,@taskname,@completiondate)

DECLARE @N NUMERIC     -- No precision or dcale
SET @N = 12.345

PRINT @N

DECLARE @N2 NUMERIC(5,3)
SET @N2 = 12.345

PRINT @N2

DECLARE @N3 NUMERIC(4,3)
SET @N3 = 12.345

PRINT @N3

CREATE FUNCTION dbo.LesserOf
(
  @Op1 NUMERIC(18,7)
,
  @Op2 NUMERIC(18,7)
)
RETURNS NUMERIC(18,7)
AS
BEGIN
  DECLARE @result NUMERIC(18,7)
 
  IF ( @Op1 < @Op2 )
    SET @result = @Op1
  ELSE
    SET @result = @Op2
 
  RETURN @result
END

Select  LocationID
       ,Sum(Case when MeetingID = 1 then Numvisitors else 0) as TotalNumVisitors1
       ,Sum(Case when MeetingID = 2 then Numvisitors else 0) as TotalNumVisitors2
From    Visitors
Group By LocationID

Select  LocationID, Groups.GroupSize
       ,Sum(Case when MeetingID = 1 then (Group)*GroupSize + Numvisitors else 0) as TotalNumVisitors1
       ,Sum(Case when MeetingID = 2 then (Group)*GroupSize +  Numvisitors else 0) as TotalNumVisitors2
From    Visitors
join Groups on Visitors.SomeID = Groups.SomeID
Group By LocationID, GroupSize 

Select  LocationID
       ,MeetingID
       ,Sum(Numvisitors) as TotalNumVisitors
From    Visitors
where   MeetingID IN (1,2)
Group By LocationID,MeetingID

print getdate()
execute yoursp
print getdate()