SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Creating appropriate data type from varchar(max)

  This is something I am thinking someone may have done already. Basically we have data loader which …

  dva2007

  4 replies

  1 day ago

  By: MMartin1

• arabic digits stored in varchar column with Arabic_* collation

  Hello, FYI Database collation is Arabic_100_CS_AS Why do Arabic characters in a varchar column (c…

  Mark T.

  2 replies

  3 days, 6 hours ago

  By: Mark T.

• Need help on T-SQL

  I've table and data as script below, CREATE TABLE [dbo].[ClientProjects]( [Id] [int] IDENTITY(1,1) …

  Adelia

  2 replies

  3 days, 14 hours ago

  By: Adelia

• replace chain of function calls with better code

  We have a scalar function that is used to add a specific number of business days to a date however …

  david_h_edmonds

  15 replies

  4 days, 4 hours ago

  By: ScottPletcher

• Inline Table

  Please assist creating an inline Table Valued Function. Output  https://drive.google.com/file/d/1…

  yrstruly

  2 replies

  2 weeks, 6 days ago

  By: frederico_fonseca

• Inline Table

  Please assist creating an inline Table Valued Function. Output should look like this: https://drive…

  yrstruly

  18 replies

  2 weeks, 6 days ago

  By: Jonathan AC Roberts

• Insert missing records for each month/year with the previous month's value

  I have a sample data, see below. Sample data The base rules are If the same CustomerID and Account…

  sxzhu

  5 replies

  3 weeks, 3 days ago

  By: koko365

• Reading data with MSDASQL/OPENROWSET - periods in the filename

  Hi all, I ran into an issue this morning to read the data using OPENROWSET I was able to read the f…

  murthyvs

  1 replies

  3 weeks, 4 days ago

  By: murthyvs

• OPENROWSET & BULK INSERT Skip First X Rows, Skip Last Y Rows

  Hi all, I have a requirement to read csv files skipping the First X Rows and Last Y Rows using OPEN…

  murthyvs

  2 replies

  3 weeks, 4 days ago

  By: murthyvs

• Join together two Dynamic SQL variables

  All, I feel like I have done this in the past, but cant remember what I did for it and even worse, …

  GBeezy

  7 replies

  3 weeks, 4 days ago

  By: ScottPletcher

• SSIS Package Issue using ODBC Data Source

  I have a SSIS package with the following Connections: ODBC Connection to 32 bit MS Windows System …

  mamugra

  2 replies

  3 weeks, 5 days ago

  By: IrfanHyd

• What is the best strategy to check for changes to a record in DWH ETL processes

  Hi All, We have a current ETL process that takes a delta and uses MERGE to decide whether the data …

  aaron.reese

  3 replies

  3 weeks, 6 days ago

  By: IrfanHyd

• Capture Tables Updates-Add , updare and delete record) when Sp executed

  When i run a stored procedure, i would like to capture all the Database updates with table name and…

  skb 44459

  2 replies

  4 weeks ago

  By: sgmunson

• Most recent and previous row

  Hello, Thanks if you can help. DDL below. This is similar to problems usually solved with RANK but …

  Chrissy321

  4 replies

  4 weeks ago

  By: Steve Collins

• need help on query

  Hi all, need help on below requirement. Thanks, Abhas

  abhas

  6 replies

  1 month ago

  By: Jeff Moden