SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months ago

  By: Ankita08

• Bulk Insert C# Code Error

  I figured out the issue.  Please ignore post. This topic was modified 3 years, 10 months ag…

  water490

  2 replies

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months 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

  3 years, 10 months ago

  By: Phil Parkin

• SSIS SFTP using WinSCP

  Hi I am using WinSCP to create a SFTP task by following this guide: https://winscp.net/eng/docs/gui…

  water490

  19 replies

  3 years, 10 months ago

  By: Jeff Moden

• SSIS package to select a button on a windows app

  Hi everyone I am creating an SSIS package where I run an windows program to download data.  The dat…

  water490

  3 replies

  3 years, 10 months ago

  By: water490