This documentation site is for previous versions.

Visit our new documentation site for current releases.

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Deleting the records from the FACT table in Microsoft SQL Server databases

Updated on April 5, 2022

Perform this procedure to delete records from the FACT table in a Microsoft SQL Server database.

Execute the following script:

DELETE FROM <SOURCE_DATABASE>.<SOURCE_SCHEMA>.PR_DATA_IH_FACT WHERE PXOUTCOMETIME < CONVERT(data_type(length),expression,style);

For example:

Example

DELETE FROM <SOURCE_DATABASE>.<SOURCE_SCHEMA>.PR_DATA_IH_FACT WHERE PXOUTCOMETIME < CONVERT(DATETIME,'30-06-15 10:34:09 PM',5);

, where:

data_type

is DATETIME

expression

is the date value in quotes

style

is 5 (Italian format)

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.