September 26, 2011 at 7:16 am
Use SSIS and Excel 2007+.
Now please answer the 'TOP' question. I'll spell it out.
Assume you have 10 companies
Company1, Company2, ..., Company10
The first time you run
SELECT TOP 3 Company from Company
you might get Company1, Company2, Company3 returned.
The second time, you might get
Company5, Company6, Company10
That is what is puzzling everyone.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 26, 2011 at 7:22 am
Thank u for ur reply
For SELECT TOP 3 issue...i am not concern to pick specific 3 companies...any 3 may be from these 10 companies...i mean may be company 1,2,3 or 4,5,6...as all these companies are paid.....i resolved this issue by my query i mentioned earlier.....
For Excel issue please let me check your sugestions
October 1, 2011 at 11:31 pm
@SSCrazy
Hi,
the below procedure works for me for less amount of data....when i increased the number of data from 100000....now this do not give me result...the server is executing for more than 7 minutes and do not return anything...due to which my application return server timeout error.....can you please give me a replaceable code for this SP,which works like this
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetBDResults]
@scat INT,
@loc nvarchar(100)
AS
BEGIN
SELECT top 100 ID, COMPANY,
ADDRESS, Area, POSTALCODE, PROVINCE, PHONE1,
FAX, EMAIL, WEBSITE , city, lat, lon
FROM vwSearchResult
WHERE scatID = @SCAT AND city like '%'+@loc+'%' AND ID IN (
SELECT TOP 3 ID
FROM vwSearchResult
WHERE scatID = @SCAT AND city like '%'+@loc+'%' AND FLAG = 1 )
OR
ID IN (SELECT TOP 100 ID
FROM vwSearchResult
WHERE scatID = @SCAT AND city like '%'+@loc+'%' AND FLAG = 0 )
END
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply