SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• 'DATE' is not a recognized built-in function name

  Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(Transa…

  yrstruly

  26 replies

  1 year, 10 months ago

  By: yrstruly

• Multiple values in a parameter

  Dear All, I want to use these values in the parameter for further usese, but it's giving me an erro…

  vijay.verma2

  15 replies

  1 year, 10 months ago

  By: kaj

• View Or Stored Procedure

  Please see my DDL. I would like to create: a) Dimensional table that tracks Primary Accounts’ gr…

  yrstruly

  2 replies

  1 year, 10 months ago

  By: kaj

• 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

  1 year, 10 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 lon…

  drnicolas

  1 replies

  1 year, 10 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

  1 year, 11 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

  1 year, 11 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…

  SQLServerQuery

  2 replies

  1 year, 11 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

  1 year, 12 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

  1 year, 12 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

  1 year, 12 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

  1 year, 12 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 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 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 outp…

  sabarishbabu

  7 replies

  2 years ago

  By: MarkP