SQL

Sending Datetime or Datetime2 values via linked server in SQL Server - rounded to millisecond

Answered kamil_kosno 433 views 3 comments 0 points Most recent by SruthiA October 25General Discussion
Query with 2 NOT LIKE conditions returns 0 results

Answered ✓ angelompcunha 2.6K views 16 comments 0 points Most recent by VValdar October 9General Discussion
Pivot from columns to rows?

Answered yardenpel 552 views 2 comments 0 points Most recent by VValdar September 22General Discussion
'interpolate previous value' expression order does not matter?

Answered ✓ ftobin 530 views 2 comments 0 points Most recent by ftobin September 22General Discussion
Is there any linter for vsql scripts?

Answered vhermecz 2.2K views 4 comments 0 points Most recent by vhermecz June 21General Discussion
Why this procedure does not insert data into the table, although it is performed successfully, I can

Answered Anelya 838 views 1 comment 0 points Most recent by Bryan_H May 4General Discussion
Hi! How to solve this error

Answered ✓ Anelya 1.5K views 1 comment 0 points Most recent by SruthiA May 3General Discussion
How can we uniquely identify each record in Vertica database in absence of primary key?

Answered chowdarypradeep 4.2K views 4 comments 0 points Most recent by marcothesane February 6General Discussion
How to load data type fixed width support thai language

Answered ✓ xinx 1.6K views 2 comments 0 points Most recent by mosheg December 2022General Discussion
least/greatest with 'in' fails

Answered ✓ ftobin 5.1K views 4 comments 0 points Most recent by SruthiA September 2022General Discussion
Create a new table from another Table without data and new primary key

Answered ✓ Jay_B 3K views 2 comments 0 points Most recent by Jay_B April 2022General Discussion
Finding similar roles assigned

Answered shekhar8249 2.8K views 2 comments 0 points Most recent by DaveT February 2022General Discussion
Combining multiple S3EXPORT calls into a single call

Answered ✓ neo_i_am_the_one 5.1K views 4 comments 0 points Most recent by neo_i_am_the_one December 2021General Discussion
Last day of last completed quarter

Answered ✓ pratheek238 5.1K views 4 comments 0 points Most recent by pratheek238 November 2021General Discussion
Does Vertica CASE statement (syntax form 2) recognize NULL values?

Answered Pieter_Sheth-Vo 2.1K views 1 comment 0 points Most recent by Jim_Knicely September 2021General Discussion
Is there a corresponding antlr4 file to implement Vertica SQL parsing？

Question erphia 2.8K views 2 comments 0 points Most recent by erphia August 2021General Discussion
Remove empty and null values from table

Answered szymon_k 2.7K views 1 comment 0 points Most recent by SruthiA July 2021General Discussion
How to alter table to have uuid?

Answered iddpanganiban 3K views 2 comments 0 points Most recent by iddpanganiban July 2021General Discussion
Bug in WHERE clause?

Answered ✓ peter_krammer 6.4K views 5 comments 0 points Most recent by marcothesane May 2021Product Feedback
REGR_SLOPE PRECISION

SruthiA 680 views 0 comments 1 point Started by SruthiA April 2021 Tips from the Team
Server closed the connection unexpectedly while loading data from CSV using Alteryx Designer

Answered Satya 11.8K views 9 comments 1 point Most recent by Satya September 2020General Discussion
Need to Find the Occurrence of an Alphabet in a String

Answered ✓ JayantaB 12.5K views 6 comments 0 points Most recent by JayantaB August 2020General Discussion
Delete specific word using regexp_replace

Answered shashank_p 13.7K views 10 comments 0 points Most recent by shashank_p June 2020General Discussion
How do I create an alias for a built-in function?

Answered bloopie 5.7K views 4 comments 0 points Most recent by LenoyJ June 2020General Discussion
DATE values insertion into Vertica table through python

Answered tnr 2.6K views 1 comment 1 point Most recent by Bryan_H June 2020General Discussion
populating null rows in table column based on matching IDs via join or otherwise

Answered mpc83 2.2K views 1 comment 0 points Most recent by mosheg May 2020General Discussion
How do I handle the password in vsql command in crontab?

Answered Prairiedog 4.9K views 3 comments 0 points Most recent by ChuckB March 2020General Discussion
customer function vertica

Answered wlister 2.1K views 1 comment 0 points Most recent by marcothesane March 2020General Discussion
execute immediate select vertica

Answered roybaranes 5.7K views 4 comments 0 points Most recent by mosheg February 2020General Discussion