SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Make Table Query

  Hi I have table that I want to make sub tables for.  Below is an example of how it would work. Cons…

  water490

  9 replies

  4 years ago

  By: pietlinden

• Best way to process a large XML file (2MB) or greater

  Hello, Currently have a stored procedure that processes an XML Doc stored in a table. Uses: EXEC sp…

  DanielP

  7 replies

  4 years ago

  By: Phil Parkin

• populate a table with new data set but keep the original identity column values

  I have a table like below, I would reset the values in the table with some fake addresses. I have a…

  sqlfriend

  7 replies

  4 years ago

  By: sqlfriend

• Looking at startdate of one table and calculate the numbers from a different tab

  I have such a situation. I have a table UDT_CKB_SNAPSHOT where we have different events (promotions…

  JeremyU

  1 replies

  4 years ago

  By: JeremyU

• Beginner Query SQL

  I have a 120gig database. I want to analyse it with Power BI. (It's way to Large) This is data from…

  FredC

  3 replies

  4 years ago

  By: Jeff Moden

• How to handle rolling back changes if there is an error?

  Hi everyone I have two stored procedures that update two tables.  If one of the updates fails then …

  water490

  8 replies

  4 years ago

  By: Jeff Moden

• extract columns from a string column

  I would like to extract a street address to separate columns. For example, I have street fake data …

  sqlfriend

  3 replies

  4 years ago

  By: sqlfriend

• Compare 2 rows in the same table and output result when conditions are met

  I am newbie to SQL, tried searching for answers for similar question but couldn't find any. Sorry, …

  Ankita08

  4 replies

  4 years ago

  By: RamonS

• Print Statements

  Hi I am creating SSIS pacakges to automate data collection.  I want to print out statements to the …

  water490

  2 replies

  4 years ago

  By: Phil Parkin

• How to do recursion in join clause or in exits clause or in "in" clause.

  hi, I have used "with cte" to do some recursion, which i have used on top, is there any why that i …

  rajemessage 14195

  4 replies

  4 years ago

  By: Jonathan AC Roberts

• Compare 2 rows in the same table and output result when conditions are met

  I am newbie to SQL, tried searching for answers for similar question but couldn't find any. Sorry, …

  Ankita08

  2 replies

  4 years ago

  By: Ankita08

• Bulk Insert C# Code Error

  I figured out the issue.  Please ignore post. This topic was modified 4 years ago by water4…

  water490

  2 replies

  4 years ago

  By: Phil Parkin

• T-SQL : Slicing time periods

  Consider the following table that gives the validity dates for which an Item is associated to somet…

  IdealPR

  2 replies

  4 years ago

  By: DesNorton

• Does a while loop read all the records in a table? Resolved

  I hope this isn't too long, but I wanted you to understand why I am doing what I am doing/ I have a…

  Jocar26

  9 replies

  4 years ago

  By: Jocar26

• Refactoring an Entity Attribute Value schema

  Apologies in advance, as I know this has been discussed a million times already but I think our req…

  julian.fletcher

  1 replies

  4 years ago

  By: Phil Parkin