Transact-SQL

3 answers

IN SSIS How to change SQL Authentication to Windows Authentication

HI I was trying to deploy the packages in to server it is erroring out with the below error . TITLE: SQL Server Integration Services The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account…

asked

Dinesh Shetty 1

answered

Krishna Shah 5

2 answers

Azure SQL Database Stored Procedure long execution time issue

In my Azure SQL Database I have Stored Procedure sp_subledger (Attached the code : sp_subledger.txt) The Stored Procedure is completing within 1 min when Tenant = 1 is provided but when Tenant = 2 is provided it is running for more than 2 hours. for…

asked

Arundhati Sen 151

commented

Saurabh Sharma 23,791 Microsoft Employee

4 answers

Joing two tables in SQL with Different Primary Keys

Hi, I'm trying to join two tables, they are both string datatype but the only difference is the first table having an extension number either '001', '002', or '003', etc. I was thinking to use LIKE % but I'm not sure how. I have like thousands of…

asked

Sherlan Emmanuel Burgonia 86

edited an answer

Sherlan Emmanuel Burgonia 86

2 answers

How to handle blank space in table

Hi Expert, How to enter blank space and default date in timestamp column create table tabletest1 (col1 char(23), col2 int,col3 decimal(3,3),col4 timestamp) expected values

asked

Shambhu Rai 1,411

commented

Shambhu Rai 1,411

1 answer

Updating running balance in SQL

How can I update the Balance in a SQL table based on the BillAmount , EmployeeId and Id fields? I want to update the balance of every record to be less by the BillAmount of that record when compared to the immediate previous record for the same…

asked

Michael M.M. D'Angelo 176

commented

Erland Sommarskog 107.1K

1 answer

TSQL Lag Calculate the Period Delta from a column which has only Period Ending Balances

We are trying to derive the period change amount from a table which only has period ending values. This is sample code: --We are trying to derive the period change amount from a table which only has period ending values. --This is sample…

asked

vsslasd 556

answered

vsslasd 556

5 answers

double qoutes issue

Hi Expert, I want to remove the double qoutes from end and start of the statement create table table1 ( col1 varchar(200)) create table table1 ( col1 varchar(200)) insert into tale1 values('"Test1 Test1 Test1 "Test1"…

asked

Shambhu Rai 1,411

edited an answer

Adam 21

1 answer

How to calculate number of weeks worked by an employee for a fiscal year in sql server

How to determine the total weeks an employee has worked during a fiscal year using SQL Server. My start date is 12-28-2023 and till today, I would like to calculate the no.of weeks worked by an employee during that time.

asked

Maddi, Shyam 0

commented

LiHongMSFT-4306 25,651

1 answer

T-SQL R language - return fewer columns

I'm running an R language script under T-SQL where I use REGEX to validate data in two columns. However I only want to output the id column in my result set. My script is: EXECUTE sp_execute_external_script @language = N'R', @script = N' pattern =…

asked

Peter Bishop 161

answered

Peter Bishop 161

1 answer

sqlpackage export data

Is it possible to export data only of all the tables in the DB using sqlpackage export action? Schema is not to be included in the .bacpac file.

asked

Indiana 0

commented

LiHongMSFT-4306 25,651

1 answer

How to get dynamic variable in 'Delete Activity' in Azure Synapse.

I am new to azure synapse analytics. I want to delete a folder from a container having format 'YYYYMMM' if it exists. If folder is not there ,a new folder same format YYYYMMM should be created. I have tried as below but could not be able to delete the…

asked

Sebika Pradhan 0

answered

Amira Bedhiafi 20,101

1 answer

Create a Table based on Multiple Criteria

Hello All, I am a Power BI developer and I have come across a problem that I need help solving. I want to create a table based on multiple criteria. I am doing a drill through from one page to another, where I can see the details of feedback that…

asked

Sana Shaikh 0

edited the question

LiHongMSFT-4306 25,651

3 answers

How to get data related from #parts table based on company id and in case of table #company not have companyid then display all data ?

I work on sql server 2019 i face issue i need to write join display data from table #parts based on values exist for #company in case of #company have companyid then get data related if #company table not have any companyid then get all data…

asked

ahmed salah 3,216

edited an answer

SunCrop Group 0

1 answer

Convert day, hour, minute, second (6d 5h 19m 18s) in Hour’s integer value in SQL Server

Hi All, we have a issue to convert Day, Hours, Minute, Second in Hours integer value. This is incoming data format-6d 5h 19m 18s, we need to convert this value in hours as integer value. Thanks MV

asked

manish verma 441

commented

manish verma 441

4 answers

How to store dynamic sql result into temporary table

This is my dynamic sql. SET @Anonymous = ' Select XX.,'''' scale,Isnull(AllowComma,''FALSE'') AllowComma,Isnull(AllowedDecimalPlace,''0'') AllowedDecimalPlace, Isnull(AllowPercentageSign,''FALSE'')…

asked

Sudip Bhatt 2,276

commented

Verney, Thomas 0

2 answers

How to do the bulk insert of one lack records in sql server using node js

Hi, I will store the data in following Json format. Now I want to insert this one lack. records in sql server. Kindly Please provide the best solution and if it's possible share your solution with sql query. [ { key: value, key: value, key: value, key:…

asked

Arutprakasam 261

answered

Konstantinos Passadis 17,456 MVP

2 answers

SCD Type 2 : MERGE Update and Insert

Hi All - I am trying to implement a Type 2 Slowly changing dimension in SQL procedure using MERGE. Here are the rules : If its a new record insert into target table with start date = getdate, end date = null and islatest =1 If the record is…

asked

kkran 831

edited the question

Oury Ba-MSFT 18,021 Microsoft Employee

2 answers

SQL job get blocked after some time by a process on master DB

I have a job which performs following steps on high level 1.) Load Stage table 2.) Load Fact table 3.) Apply lots of rules on fact table, so lots of updates This was working fine for more than a year but now it gets stuck after applying some of the…

asked

Leekha,Mohit,IN-Kolkata 0

commented

GeethaThatipatri-MSFT 29,017 Microsoft Employee

6 answers

Does SQL Table Column is assigned with column number

In Table, we can see there is number assigned automatically (line number) is the same thing is available for the columns (column number) and how can we get that number? I need a SQL query to find the column number not the number of columns.

asked

Sarvesh Pandey 141

commented

Tom Considine 0

2 answers

i have a stored procedure that is complaining about a group by clause but i can see nothing wrong with it

Would someone PLEASE tell me what is wrong with this? select d.customer_no, e.sort_name, d.order_no, d.perf_no, d.season_desc, h.prod_no, b.seat_no, g.description 'section', f.seat_row, f.seat_num, a.sli_no, a.last_event, b.event_code, c.description…

asked

Anonymous

edited a comment

LiHongMSFT-4306 25,651

Filter

Content

4,600 questions with Transact-SQL-related tags

IN SSIS How to change SQL Authentication to Windows Authentication

Azure SQL Database Stored Procedure long execution time issue

Joing two tables in SQL with Different Primary Keys

How to handle blank space in table

Updating running balance in SQL

TSQL Lag Calculate the Period Delta from a column which has only Period Ending Balances

double qoutes issue

How to calculate number of weeks worked by an employee for a fiscal year in sql server

T-SQL R language - return fewer columns

sqlpackage export data

How to get dynamic variable in 'Delete Activity' in Azure Synapse.

Create a Table based on Multiple Criteria

How to get data related from #parts table based on company id and in case of table #company not have companyid then display all data ?

Convert day, hour, minute, second (6d 5h 19m 18s) in Hour’s integer value in SQL Server

How to store dynamic sql result into temporary table

How to do the bulk insert of one lack records in sql server using node js

SCD Type 2 : MERGE Update and Insert

SQL job get blocked after some time by a process on master DB

Does SQL Table Column is assigned with column number

i have a stored procedure that is complaining about a group by clause but i can see nothing wrong with it