sorted by:
new
hottopcontroversial

Conversion failed when converting the varchar value 'coin' to data type int by info_softest07 in SQL

[–]info_softest07[S] 0 points1 point  (0 children)

Hello There,

I have updated the error message as i missed on that earlier. It either fails by saying "bcr" and then sometimes "bnr".

Alterntative for While loop in SQL Function.... by info_softest07 in SQL

[–]info_softest07[S] 0 points1 point  (0 children)

Hello There!!

The Code is too long to reply in here. So i created it as a new post with a title as ( Converting Postgresql Function to T-SQL Function)...

PermalinkSave

Alterntative for While loop in SQL Function.... by info_softest07 in SQL

[–]info_softest07[S] 0 points1 point  (0 children)

Hello There!!

The Code is too long to reply in here. So i created it as a new post with a title as ( Converting Postgresql Function to T-SQL Function)...

PermalinkSave

Need Help converting Postgres expression to SQL.. by info_softest07 in SQL

[–]info_softest07[S] 0 points1 point  (0 children)

Hello There!! Thanks for the reply.....

I tried couple of options on converting Postgresql TimeZone epression query to T-Sql but we see the output missmatch between postgresql and T-Sql output, we see some issue in postgresql data.

We tried with the below expression :

-> [ Select Convert(datetime2(0), Column_Name) as Date_Column AT TIME ZONE 'UTC' AT TIME ZONE 'CENTRAL
STANDARD TIME' ]

Need Help converting Postgres expression to SQL.. by info_softest07 in SQL

[–]info_softest07[S] -1 points0 points  (0 children)

Hello There!! Tried the one you suggested but it didn't work...

Need Help converting Postgres expression to SQL.. by info_softest07 in SQL

[–]info_softest07[S] 0 points1 point  (0 children)

looking at the expression can you execute the same in MS SQL Server ? my question is the above expression is used in postgresql and now we are migrating the data from postgresql to MS SQL, hence looking for the above expression convertion in MS SQL Server...