SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Create a View with Index

  I am using a large Manufacturing Database and would like to create a number of Indexed Views in ano…

  robertopmorris

  38 replies

  4 years, 5 months ago

  By: robertopmorris

• Extract out Parent/child records from XML String

  Hi there I  have an XML String from which I would like to extract the data out to create a set of r…

  Weegee71

  2 replies

  4 years, 5 months ago

  By: Weegee71

• Select into object from an SQL server to another through linked server

  Hello. I need to execute a select into statement from one SQL server to another. I try to execute i…

  kakovatos7

  5 replies

  4 years, 5 months ago

  By: kakovatos7

• logging data with variable column count

  I want to log a table (in this case Payroll) where number of columns might vary from time to time c…

  Ben

  8 replies

  4 years, 5 months ago

  By: Ben

• Import data from PostgreSQL to MS SQL Server

  I am trying to import data from the PostgreSQL into the MS SQL Server database, using SQL Server Im…

  itlk

  1 replies

  4 years, 5 months ago

  By: itlk

• Comparing two sets of value sets

  I have two columns that I need to check for a given set of values: SELECT * FROM test t WHERE t.col…

  Aaron N. Cutshall

  2 replies

  4 years, 5 months ago

  By: Eric M Russell

• "Number of rows Read" vs "Actual Number of rows for all Executions"

  I'm using SSMS 2019 and comparing two execution plans. When looking at a seek or scan operator deta…

  Alan Burstein

  7 replies

  4 years, 5 months ago

  By: Alan Burstein

• SQL Replace Command help required

  Hi I am Part of a Car Club and volunteering to help where I can. The Club has ask me to do some vol…

  hajduk1908

  5 replies

  4 years, 5 months ago

  By: Sergiy

• column count per table best practice

  I want to design a database for an OLTP app where it mainly involves customer and transaction. I kn…

  Ben

  27 replies

  4 years, 5 months ago

  By: Jeff Moden

• RESOLVED | With a QUERY | CTE or a Sub-Query for Cross-tab Concatenate

  Hi, I am stuck with a problem & was hoping if someone can please help me. Not sure if this is a…

  sqlguru1day

  8 replies

  4 years, 5 months ago

  By: Jeff Moden

• Splitting adhoc queries into a data structure

  Issue - Current adhoc SQL can be generated by our reporting module that is difficult to maintain mu…

  JKSQL

  5 replies

  4 years, 5 months ago

  By: JKSQL

• Select Statement in proc does not work

  select @MaxRows = count(distinct AT.AccountId) from ATable AT inner join SomeTable A on A.Account…

  abhishekpats

  5 replies

  4 years, 5 months ago

  By: Jonathan AC Roberts

• Querying on prem AD and Azure AD

  I have a task that requires me to query multiple on prem AD domains and Azure AD domains to bring a…

  tommiwan

  1 replies

  4 years, 5 months ago

  By: frederico_fonseca

• Converting MS Access Queries to SQL Views

  We have a MS Access database that we have separated the tables and now have Azure SQL linked as our…

  JP789

  3 replies

  4 years, 5 months ago

  By: JP789

• Get total no of minutes by hour hand between two dates

  am trying to avoid using while loop but OK with it... We are talking about 500K source data... Orig…

  SSISSSRSSSAS

  2 replies

  4 years, 5 months ago

  By: SSISSSRSSSAS