SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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, 7 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, 7 months ago

  By: Ankita08

• Bulk Insert C# Code Error

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

  water490

  2 replies

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

  By: water490

• CPU

  Hi everyone I am in the market for a new computer.  I have been comparing various Xeon processors a…

  water490

  3 replies

  3 years, 7 months ago

  By: Jeff Moden

• Enable 'Microsoft OLE DB provider for ODBC Drivers' or MSDASQL trace in SSMS

  Hello, I have a Windows 2019 machine with SQL Server 2019. I have created a linked server to Db2 da…

  CheBob

  1 replies

  3 years, 7 months ago

  By: CheBob

• Error for byte size

  Hi, I am getting the following error for following query I am trying to run. Anyone can advise what…

  singhzsql

  7 replies

  3 years, 7 months ago

  By: mistygal08

• Use of '$$xxx'

  I have seen a number of queries that contain statements like "set @SomeBitVariable  = iif('$$SomeNa…

  andymay-496937

  1 replies

  3 years, 7 months ago

  By: Mr. Brian Gale

• UNION ALL with CTE

  Hello. I am trying to UNION ALL two tables 1) Current receipts 2) Historical receipts. Both of thos…

  JeremyU

  11 replies

  3 years, 7 months ago

  By: Jeff Moden

• Bulk Insert Stored Procedure

  Hi I am trying to create a stored procedure.  I am getting an error.  Is someone able to help me wi…

  water490

  8 replies

  3 years, 7 months ago

  By: water490

• Export to Multiple Worksheets / Tabs in Excel ?

  I am able to use an SSIS package to export from a SQL table and create an Excel spreadsheet and ass…

  homebrew01

  3 replies

  3 years, 7 months ago

  By: SoCal_DBD