home
1 hour ago

SQL Dates Selection

I Have a OPL_Dates Table with Start Date and End Dates as Below: dbo.OPL_Dates ID Start_date...
I am trying to create a new job to run a SSIS package automatically. I succeed to execute run the...
I'm trying a really novice MS Access form (linked to) with a SQL Server in the backend. So I have...
I am trying to find values from two tables using Exists or Not Exists either option will be...
Problem I can not insert Data to a sql table with a foreign key to a IdentityColumn, in ef core...
3 hours ago

UNPIVOT Table Columns

I want to get my table data in rows instead of columns. Dynamically read the column names...
I keep getting the same values returned when running my query, I am trying to find pairs of store...
I'm developing an app which stores various records on people. These records require an Image. I am...
I have 2 tables. Table1 +----+------+ | Id | Name | +----+------+ | | ...
This question already has an answer here: Multiple Id's in In...
I have a procedure that returns 2 datasets. I need to exec the procedure once and insert both...
I have products with pricings and sometimes a company has a more specific price for a product. I...
What's the easiest way to get the SSMS stored procedure editor to recognize a view update? I have a...
I am trying to use python to insert values into a table. TableName = "Table_Test1" This is the...
I have .MDF and .LDF files created by SQL Server. I'm trying to attach them to my SQL operations...
I need to compare two columns, and am hitting issues when comparing NULL against an empty string....
SqlCommand cmd = new SqlCommand ( "select MRF_No, Po_No, ...
I have this input table +--------+---------+---------+-------+-----------+ | TaskId | member1 |...
Family Table Child_parent Table I want output as follows by the SQL queries Child_id ...
I am having trouble with creating a setup file for my project in VS2017. I developed a Windows...
I'm kinda new to this but I have to create some kind of loggers hat logs all who/what/when/where a...
I am currently working on a program for my business that I need for uploading products to the...
I have a table with following details Project name,Manager details,Employee details,Project...
How to update all days in date column in table to special date? I want change only day, no month,...
I have to make some manipulation in SQL. I need to combine ColA and ColB in ColC - alternate text...
I have the following SQL query SELECT productVariants.productKey FROM ...
SQL Server Management Studio v17 The screenshot above shows the data I am using for cursor. I...
I have created a Template table in SQL Server 2014 and want to create a procedure for adding...
I use SQL Server to create a table and insert data for it, but why does an open id not 1 but...
My Data Factory V2 pipeline imports CSV files from an Azure blob. Is there any way in Data Factory...