Normally I figure out my DateTime issues in VBA and SQL by trial and error, but in this case I have hit a wall. I am not even sure I can do what I want. I have a temporary table with fields F1, F2, etc. Field F7 contains a date as a string n the format dd/MM/yyyy. Now, I want
System.Data.SqlClient.SqlException occured in System.Data.dll (incorrect syntax)
I can’t work out what the problem is here, since the additional information comes back as: Incorrect Syntax near ‘(‘. I think I need fresh eyes on this I can’t see the error. Here is my code, im …
Covert a duplicate Row value into column using pivot table
Here is my stored procedure query to fetch data in first table. I have following Data in a temp table. I want Name 1, Name 2, Name 3 as column and their value against the respective item.Data in table is dynamic.There can be any number of Items and any number of Name. For every Name and Item their is a
how to serialize an object into and save it to mysql database? [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 5 years ago. Improve this question i want to store a list of timestamps in android sqlite database. like : Answer Yes – s…
How to perform a search with conditional where parameters using Sequelize
Usually whenever I write a search query for SQL, I do something similar to this: Basically this simulates a conditional WHERE clause. We only want to compare @searchParam to the column if @searchParam was provided. Is there a way to replicate this using Sequelize? EDIT: Here is my best attempt which fails: UP…
Can I convert my query to use select .. like .. or?
Can the query in the code below be converted to Select / Like / Or ? Answer Yes:
Incorrect syntax near format in BULK INSERT?
I’m trying to figure out why the BULK INSERT command I’m using isn’t recognizing the FORMAT and FIELDQUOTE options used in the command. For some reason, I’m getting the error: Msg 102, Level 15, State 1, Line 6 Incorrect syntax near ‘FORMAT’. Addition: FORMAT shows up in pi…
PostgreSQL Partial Indexes and UPSERT
After googling a lot my question is described below: Attempting to insert values: Results in: Altho this works(per spec): PostgreSQL documentation stands that it should work PostgreSQL v9.5 My aim is to find way to create unique index on this table on multiple nullable columns and update old rows with new one…
Connecting to the Tabular Instance of an Azure-hosted SQL Server Analysis Services Server
I have set up an Azure Virtual Machine with a SQL Server 2016 Standard Edition image. I have installed an instance of Analysis Services Tabular on the machine and configured endpoints such that I can access it from my local machine. I have deployed SQL Server, SSAS Multidimensional, and SSAS Tabular databases…
How to use custom VBA function in WHERE IN condition
I am trying to use a custom VBA function to populate the list for the WHERE IN function of an access SQL query however I can’t seem to get it working. A simplified version of the query is shown below The code for the getList() function is I have tried playing around with the quotes like missing the lead…