Latest Activity

code

Converting the text data type into an integer data type

Hi there, I'm trying to convert a field of data type 'text' to 'integer' in denodo. The below is my sample operation. select column1, column2, column3 from bv_sample order by cast(field1 as integer) ; I get the below error: "Error converting data t...

#Denodo #denodotestingtool #testingtool #denodo #SQL #VQL

code

Special character

I want to stripe-off special character when i query the column. is there a special funtion to do this. e.g. i have characters like ~ @ in the data. so if have value@like, i want to select valuelike. if i have panda~, i want to select panda.

#SQL #VQL

code

error in SQL

I am not getting desired results from below query group_concat(distinct product_type) e.g. if i have product_type cat, dog, cat Need to get cat,dog

#VQL

code

executing output of VQL

I need to execute output of a query, what is the best approach. e.g. select x into var from <table>, which returns VQL statement/s, then i need to run these VQL statements through a command. e.g. execute @var

#Query #Connection #SQLSERVER #VQL