well entire books have been written on indexing and improving performance;

i think you'll need to read up via a google search first, and come back with specific questions.

hbtkp (4/11/2012)

this is select statement in my sp,

i need to supply one parameter @name

this contains 2 item suppose pen and pencil,

and it gives me that 2 item ,

now in table...

i read your post twice, and I cannot visualize it;

is this your what your data would look like?

CREATE TABLE [dbo].[MYTABLE] (

VARCHAR(10) ...

sheesh Sean; now that YOU did...

my example is close by using FORXML, but i don't get the "ending/last" airport.

and my code example:

;WITH flight_tran_table (flight_tran_id , [(Other Tran Data)])

AS

(

SELECT 1234, '(Other Tran Data)'

),

flight_sectors_table(tran_id,sector_id,dept,arrive)

AS

(

SELECT 1234,1,'MAN','LHR' UNION ALL

SELECT...

i've linked...

whhjops! posted to the wrong thread!

Cadavre I always love your performance tests.

I have no idea how many...

i've used soem javascript stuff to make a DIV appear based on mouseover; it should be easy to add to the report.

obviously a DIV is not limited to any specific...

you said if you remove the exp() it works.

what value is returned by sum(log(CASE WHEN field = 0.0 THEN 1 WHEN field IS NULL THEN 1 WHEN field= -100 THEN...

SELECT CONVERT(VARCHAR,@date,112) + '' + REPLACE(CONVERT(VARCHAR,@date,108),':','')

i keep a handy proc sp_dates in my master database so i can get a list of common datetime formats for myself:

i just run sp_dates...

=echo=

i'm just Jack and Sean's Parrot today!

paste the CREATE TRIGGER definition here, and the CREATE TABLE definitions for the two tables in question;

with that, we should be able to show you exactly what the issue is.

also,...

that was my point.

I thought you said you said sourceid exists on SQL Server., and assumed you were doing the work from SQL server, with linked servers to Oracle.

What confused...

since there is no WHERE statement, there's not really much to tune, right? that'll be a full table scan regardless of the indexing, I'm thinking.

returning 4.9 million rows will take...