SQL PROVIDER QUERIES

exec sp_executesql N'SELECT * FROM [PI_Core_SEOSearchTextAdHoc]
WHERE [JobTypeId]= @jobTypeId AND [JobSubTypeId] = @jobSubTypeId AND
 [StateId] = @stateId AND [CityId] = @cityId '
 ,N'@jobTypeId int,@jobSubTypeId int,@stateId int,@cityId int'

 ,@jobTypeId=-1,@jobSubTypeId=-1,@stateId=63,@cityId=-1