Developer technologies Transact-SQL

2 answers

How to Write a Pivot Table Query

I have this table: CREATE TABLE [dbo].[Notifications]( FullName varchar(50) NOT NULL, MessageID int NOT NULL, Sent date NOT NULL) Each "FullName" will have several rows with different MessageIDs and Sent dates. MessageID can only have…

asked

RogerSchlueter-7899 1,611

commented

Viorel 126.7K

2 answers

Group Transactions in Select Statement

This is a complicated one to explain. My company owns convenience stores and I am trying to track inside merchandise/fuel sales. So if a customer comes in and pays for fuel and buys merchandise in the same transaction. The screen shot I have is just…

asked

Bassman75 21

commented

aron Smith 0

1 answer

I want to review the code for several reports

I am researching a new report, and the reports listed below will serve as the foundation for it. To gain a thorough understanding of each report’s purpose, I would like to review the SQL behind each one, as this will provide the most comprehensive…

asked

Ewing, Sean E 0

commented

Ewing, Sean E 0

11 answers

Microsoft SQL Server Studio - Dark Mode

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

asked

Kıvanç ÖZDEMİR 135

answered

Roy V 0

2 answers

How can I fix a semantic model relationship issue in Power BI?

I have two tables: Table 1: Contains a distinct Employee Code with an Active/Inactive flag for each employee. Table 2: Contains Employee Code along with the courses pursued by employees under the company’s training programs. When I try to create a…

asked

Kalpesh Nardekar 0

commented

Varsha Dundigalla(INFOSYS LIMITED) 4,610 Microsoft External Staff

2 answers

What is difference between composite index and cover index?

when we create index then we can mention multiple column name and that is called composite index but when we create cover index then we create index on one column and for cover index we mention other column in include function. so i like to know what…

asked

Sudip Bhatt 2,281

answered

Cholewa Maciej 0

2 answers

SQL Sorting by Non-Aggregate Field

Hello everyone and thank for the help in advance. I have a SQL Server table that tracks incoming phone calls with the phone number and time entered. I want to create a query where I can also retrieve a count of the number of times a phone called, but…

asked

Kmcnet 1,356

accepted

Kmcnet 1,356

2 answers

Convert Julian dates in Normal date

How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates

asked

Vineet S 1,390

answered

Julian Schulz 0

4 answers

Invalid object name 'STRING_SPLIT' in SQL Server 2019

Hi Support, Our SQL server version is 2019 and check the compatibility level is 150, but it still have error "Invalid object name 'STRING_SPLIT' ". We also tried the case sensitive according to this link, both of them have the same error. …

asked

Andy Chong 897

edited an answer

Randy Kroeger 0

3 answers

Add Headers To BCP Export

I am using SQL Server 2016, and I am exporting data using BCP. I need the headers exported as well. I saw an example where I could do bcp "Select ''Field1'', ''Field2'', ''Field3'' UNION ALL Select CHAR(34) + Convert(varchar(10), field1,…

asked

Johnathan Simpson 586

commented

rferraton 0

3 answers

fast farward curson vs while loop on @table

hi, need to known weather fast farwand cursor is faster than a while loop made on @table variable haveing less than 15 rows that means 15 iteration. pls tell me which one is faster.

asked

Rajesh Kumar Yadav 20

commented

Erland Sommarskog 132.9K Volunteer Moderator

5 answers

Export data from Excel to MS SQL Server

Hi, We have an excel that stores data in it. Some forms are created inside it that are not tabular in structure. So we can consider excel sheets act as individual pages as in any website. now we need to pull data from excel into database. I…

asked

Ravi Kumar 1

answered

Ramana Kopparapu 306

1 answer

How to trap errors in Agent Job execution

I have an agent job with several steps, each step executing a stored proc. A few times each year, when a step EXEC takes place, there's no response, the proc doesn't run at all, and the step quits upon failure. I have error checking in the proc, but I…

asked

Corey Fleig 430

commented

Corey Fleig 430

2 answers

Convert 14 Char String to Datetime

I have a field in a table called TraceID that stores data like this: 2024040611102200021 The first 8 characters represent the date (YYYYMMDD). The next 6 characters represent the time (HHMMSS). The last five are insignificant numbers. So this would be…

asked

Dom 951

answered

Ramana Kopparapu 306

2 answers

Preventing Database Deletion in SSMS

prevent accidental database deletions within SQL Server Management Studio (SSMS). Currently, I am exploring options to enforce this restriction effectively implemented a DDL trigger Is the above DDL trigger approach appropriate for preventing…

asked

Niket Kumar Singh 840

answered

Ramana Kopparapu 306

4 answers

MERGE Statement results in a Cannot insert duplicate key in object

So we have a MERGE Statement that looks as though it should do the INSERT on NOT MATCHED and the UPDATE on MATCHED correctly. However when processing for some reason it seems to be falling into the NOT MATCHED INSERT portion of the MERGE rather than the…

asked

Bobby P 231

commented

Erland Sommarskog 132.9K Volunteer Moderator

2 answers

can the ROW_NUMBER() function be used without the PARTITION clause?

I'd like to get row numbers for my output without having to use ROW_NUMBER() OVER(PARTITION BY ...). Is this possible, and can you provide an example?

asked

Gil Robinson 0

answered

Ramana Kopparapu 306

3 answers

how to calculate age from date of birth

im required to come up with a script for a solution where you need both peoples date of birth, and age, when registering them its clearly stated that the person wont be asked to input their age, just their dob. but the age is needed what needs to be…

asked

ganeplay506 1

commented

Ramana Kopparapu 306

1 answer

SSIS using Kingswaysoft

Hi Team, I want to do the On prem CRM migration from 8.1 to 9.1 where we have a 9 TB SQL data which is the big challange for us. Someone suggested to do this using Kingswaysoft tool which handles a large data migration. Could you please provide us…

asked

Sachin Joshi 0

edited the question

Rekha 0 Microsoft External Staff Moderator

2 answers

How can convert decimal value into time format as its

How can change to decimal values in to time format as it is without any change in values declare @intime decimal (10,2) = 7.50 declare @intime1 decimal (10,2) = 17.50 declare @breakhrs decimal (10,2) = .45 declare @breakhrs decimal (10,2) = 1.00 …

asked

Polachan Paily 226

edited an answer

bruce 0

Developer technologies | Transact-SQL

Filter

Content

4,715 questions with Developer technologies | Transact-SQL tags

How to Write a Pivot Table Query

Group Transactions in Select Statement

I want to review the code for several reports

Microsoft SQL Server Studio - Dark Mode

How can I fix a semantic model relationship issue in Power BI?

What is difference between composite index and cover index?

SQL Sorting by Non-Aggregate Field

Convert Julian dates in Normal date

Invalid object name 'STRING_SPLIT' in SQL Server 2019

Add Headers To BCP Export

fast farward curson vs while loop on @table

Export data from Excel to MS SQL Server

How to trap errors in Agent Job execution

Convert 14 Char String to Datetime

Preventing Database Deletion in SSMS

MERGE Statement results in a Cannot insert duplicate key in object

can the ROW_NUMBER() function be used without the PARTITION clause?

how to calculate age from date of birth

SSIS using Kingswaysoft

How can convert decimal value into time format as its