Skip to content Skip to sidebar Skip to footer
Showing posts with the label Type Conversion

How To Display Number Value In Words

Q. Display the number value in Words and output should look like this SAL In_Words ---------… Read more How To Display Number Value In Words

Convert Hexadecimal To Int And Vice Versa

I will be creating a sequential Serial Number made from Hexadecimal values With this Format: XX-XX… Read more Convert Hexadecimal To Int And Vice Versa

Mssql Xml Parse To Decimal

I'm processing xml with this stored procedure select col.query('./AgreementId').val… Read more Mssql Xml Parse To Decimal

Ssis - Intermittent Error "conversion Failed Because The Data Value Overflowed The Specified Type."

I have an SSIS package which intermittently fails with a handful of errors, the two most informativ… Read more Ssis - Intermittent Error "conversion Failed Because The Data Value Overflowed The Specified Type."

Converting Varchar 3 To Int

When entering the very last join in my code below I get an error message that states 'Conversio… Read more Converting Varchar 3 To Int

Postgresql Cast Hexadecimal To Timestamp (when Migrating From Sql Server)

I have the following problem when parsing SQL Server insert queries to PostgresSQL. After making th… Read more Postgresql Cast Hexadecimal To Timestamp (when Migrating From Sql Server)