Viewing 8 posts - 1 through 8 (of 8 total)
Thanks Kingston Dhasian
Problem solved.
im a stupid.....:hehe:
November 11, 2010 at 2:37 am
Thanks John
I want to get only one Row per Hotel, a row that has the minimum Price.
I am already using group by but is not working properly.
plz view the attached...
November 11, 2010 at 2:21 am
Thanks ...:-)
August 30, 2010 at 10:35 pm
Thanks Jason
So what should i do??
im confused.....!:unsure:
August 28, 2010 at 12:12 am
How much time it will take to scam the table..
it is still very slow....
June 21, 2010 at 4:23 am
execution plan attached....
Here is the new Stored procedure after changes you have suggested
=====================================================
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_testing]
(
@City varchar(50)=null,
@State varchar(50)=null,
@Country varchar(50)=null,
@JobTitle varchar(100)=null,
@CompanyName varchar(100)=null,
@username Varchar(50)=null,
@Keyword Varchar(50)=null,
@ContractType...
June 21, 2010 at 3:54 am
Just created a new full text index on "Title" and replaced like '%' with Contains keyword..
But now its taking even longer to execute...
June 21, 2010 at 3:14 am
Thank you..
What is the better alternative of Like statement???
I will remove the Or statments , as in the Dave Ballantyne article..
June 21, 2010 at 2:29 am
Viewing 8 posts - 1 through 8 (of 8 total)