Category "sql-server"

SQL Switch/Case in 'where' clause with and

I currently have this query DECLARE @user uniqueidentifier , @day_to_find int , @date DATETIME = getdate() SELECT @user = CAST(Value AS uniqueidentifier) F

The version of the report server database is either in a format that is not valid, or it cannot be read

I had an SQL Server 2012 database instance installed on server A. I then installed SSRS 2016 only (not the the complete SQL Server 2016) on server B but point

Inserting data into SQL Server Db An Invalid direction was specified

I am using SQL Server DB (mssql), And trying to execute Insert Query through PHP. public function registerCustomer($custId, $custData) { $sqlString = "INS

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "xxxx"

In our SQL Server 2017 we have a linked server to a Microsoft Access file/database. There is a bunch of users who all log into SQL Server using Windows authenti

write a query to this..?

Students and Grades. Students contains three columns ID, Name and Marks, Grades-(grade,min_mark,max_mark) Ketty gives Eve a task to generate a report containin

Alphabetic ranking a list with set of 'WITH TIES - ORDER BY (multiple fields)

A regular usage of "WITH TIES" & the result of the query : Demand: The best of 10 movies as Oscar Wins SELECT TOP 10 WITH TIES F.FilmName AS TITLE,

SSIS - Set SQL query result to variable for Excel connection string

I want to set connection string using SQL Query result from my table. I need to import excel file from certain folder every month but i need to import only late

Converting VARCHAR with divide operand to INT

I have a VARCHAR which will return the value something like this '40/4'. Is there a way to convert this VARCHAR to an INT? I tried casting but it is not working

How do I define a variable based on a Case statement or If statement in the middle of SELECT statement?

I am defining the prefix of an address and then trying to remove it from the address. How can I define a variable using an if statement or case statement in the

SELECT returns NULL if run from application

I have an INSERT trigger on a view created with VIEW_METADATA. There's the following snippet: if @has_folder is null set @has_folder=(select REPLACE(REPLAC

How can we use group by keyword on PIVOT table having dynamic column joined with another table or alternative query of Pivot

I have 2 tables named tblDemo and tblSubDemo; tblDemo havve 2 columns _id and _name. tblSubDemo have 3columns, ID,Name, Demo_ID(it is the primary key of tblDemo

Failed to connect to docker hosted MSSQL

I have a problem followng [this tutorial](https://hub.docker.com/r/microsoft/mssql-server-linux/ ) where I try to connect to my docker hosted MSSQL via sqlcmd.

node-mssql Transaction insert - Returning the inserted id..?

I'm using node-mssql 3.2.0 and I need to INSERT INTO a table and return the id of the inserted record. I can successfully use sql.Transaction() to insert data,

SQL group by in Subquery

I'm trying to get monthly production using group by after converting the unix column into regular timestamp. Can you please tell how to use group by here in the

Visual studio keeps on popping Save as dialog box whenever I try to create or change existing table in Microsoft SQLClient

I have been trying to get rid of this problem but seems like there's no solution to this, my visual studio keeps on popping save as dialog box whenever I try to

A required file could not be downloaded while installing SQL Server 2019 Developer

While Installing SQL Server 2019 Developer Edition, I am getting error - A required file could not be downloaded. This could mean the version of the installer i

ADO Parameterized Queries with Subqueries Error

I have a legacy classic ASP application running with SQL Server 2012 (also tested with 2016) that I am trying to switch over to using parameterized queries. All

Joining two tables and getting values

I have two config tables. The structure is as below: Table 1: Client_Config id, name, value, type, description Table 2: App_Config name, value, type, descript

Debezium only reports change events at startup

I am using Debezium Spring Boot starter with its supplier: org.springframework.boot:spring-boot-starter-parent:2.4.10 org.springframework.cloud.fn:cdc-debezium-

How to create partitioning dynamically in SSAS tabular model, without using the SSIS package?

I would like to create the dynamic partition in one of my SSAS tabular model. To do so I found one approach with SSIS package which involves the "Analysis Servi

Other Categories