Hi,

maybe it is a problem with line

SET @s_insert = @s_insert + '''' + RTRIM(SUBSTRING(@hotel_amenities_id_list,1,@pos-1)) + '',''

If the statement is not built...

Hi,

you can solve this problem by using dynamic SQL.

In the first step analyse all existing values and add them to a result string including comas and quotation marks like ...

Is the dev environment reflecting the prod environment?

Meens, do you testing on dev with the same number of records?

The min server memory and max server memory configuration options establish upper and lower limits to the amount of memory used by the buffer pool of the Microsoft SQL Server...

Maybe this is an ODBC error. Try to use OLE DB

Why are you performing a reindex operation each 3 hours?

Maybe it is enough to run the operation over night.

Nervertheless DBCC DBREINDEX performs a DROP and a CREATE Index operation and...

First create a linked server entry with Provider "Microsoft OLE DB Simple Provider" pointed to the Foxpro table and than use this linked server to open a rowset.

If you need an order without using SELECT * FROM XML... without an ORDER BY clause than you can add a primarykey to your table like Id INT IDENTITY and...

I think the issue is located in the definition of table XML....

Please post the definition of the table.

Other point, for such an easy task you do not need a cursor.

Hi,

do not exactly what output you need. The statement below returns all columns from table TotalColumn order by CapturedDate from new to old. If the statement covers not your needs...

Hi,

try this statement. I joint both tables on the dates.

SELECT startdate, enddate, SUM(productionVolume) AS Volume

FROM @reportPeriods

INNER JOIN @productionData ON startdate <= productionDate AND enddate >= productionDate

GROUP BY startdate, enddate

Regards,

Thomas

The table looks like follows:

CREATE TABLE #tmpImport (

Competitor_Name varchar(13),

OPIS_CITY_NO varchar(3),

branded_code varchar(1),

product_indicator varchar(1),

product_type varchar(1),

opis_product_grade varchar(3),

octane_no varchar(3),

RVP_GROUP_CODE varchar(3),

price decimal(17, 5),

GROSS_price decimal(17, 5),

price_change_amt decimal(17, 5),

i_prc_date varchar(8),

i_prc_local_char_col1 varchar(10),

i_prc_local_num_col2 decimal(17, 5),

cps_code varchar(10),

pro_code varchar(20)

)

No indexes, no...

Yes, in general I agree but in this special case the insert of 6 records needs about 16 seconds for a table without any index.

The execution plan for the insert...

I do not know if deleting or disabling of the index results in a higher performance because of the way you are filling the table. The most time consuming is...

How do you populate the table?