SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Need to be written comment like "Lost"

  Dear All, I am new in SSRS, I created one report like the attached file. (Design, Output) I want to…

  vijay.verma2

  9 replies

  2 years, 5 months ago

  By: pietlinden

• Problem with a SQL Server Proxy account

  I am using an Application which  accesses certain registry hives. the application runs fine as long…

  drnicolas

  1 replies

  2 years, 5 months ago

  By: drnicolas

• How to turning 1 Row into 2 Rows following best practices?

  Hello, I am looking for advice to write code following best practices.  I will be receiving a data …

  rjjh78

  6 replies

  2 years, 5 months ago

  By: frederico_fonseca

• Generation of Auto Series based on logic

  Hello, I have a requirement where I need to generate values for ID column of table. The series shou…

  kirti

  18 replies

  2 years, 5 months ago

  By: Jonathan AC Roberts

• Parsing XML data into multiple Datasets

  Hi, Thanks in advance for your help.  I’m trying to download some data from a website and import it…

  SQLServerQuery

  2 replies

  2 years, 5 months ago

  By: Jeff Moden

• A question about stored procedures and Transactions

  I have been trying go get an answer to this question for sometime now. It has to do with transactio…

  eichnerm

  4 replies

  2 years, 6 months ago

  By: eichnerm

• Column names for each of Merge update Statement

  Hi All, I have around 120 columns and it has around 1 million record. Use to receive a csv file and…

  LearnSQL

  5 replies

  2 years, 6 months ago

  By: Ant-Green

• Passing multiple values into a SQLCmd script

  I want to be able to pass multiple values into a sqlCmd script which calls a stored procedure The s…

  Weegee2017

  3 replies

  2 years, 6 months ago

  By: chanab

• Powershell Step in SQL Job not returning full data

  I created a sql job and have multiple powershell steps. Powershell step runs query on databases hos…

  sunchips

  4 replies

  2 years, 6 months ago

  By: Steve Jones - SSC Editor

• A question about unique keys

  I've been away from SQL Server for a number of years. Years ago what I am asking could not be done.…

  eichnerm

  8 replies

  2 years, 6 months ago

  By: eichnerm

• Sql table join help

  I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101, maths, 76 …

  SQL Bee

  4 replies

  2 years, 6 months ago

  By: MarkP

• Merge String into single string

  Hello Team, I have a input fields like below with fixed value separator (6)  and the expected outpu…

  sabarishbabu

  7 replies

  2 years, 6 months ago

  By: MarkP

• Get Date Monday Show results for weekend and then else 24 hours

  Hi,   I have a SQL query below in which i need to be able to see all results for TimeGenerated…

  DMcMorris@welcom.co.uk

  5 replies

  2 years, 6 months ago

  By: Jeff Moden

• Split string

  I have a table where values into field is like this way There are multiple rows now we need to find…

  sks_989

  12 replies

  2 years, 7 months ago

  By: Steve Collins

• query help

  Hi All, I have 2 tables. both tables hold db file sizes. I want the difference of sizes using tsql.…

  bobrooney.81

  3 replies

  2 years, 7 months ago

  By: bobrooney.81