SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• How to find ultimate parent

  Hi I have dataset like this   drop table if exists #dataset create table #dataset(CIF VARCHAR(…

  inayatkhan

  4 replies

  1 year, 10 months ago

  By: Jeff Moden

• How to Pivot Table From Simple #TEMP Sample Data?

  I know this is easy for someone.  We want to create a pivot table from the sample data below. Resul…

  montgomery johnson

  5 replies

  1 year, 10 months ago

  By: montgomery johnson

• Splitting delimited values across multiple columns on same row.

  Hi All, Not sure If I'm over complicating the process but I'm struggling to write or find a solutio…

  Tava

  8 replies

  1 year, 11 months ago

  By: Tava

• Select a distinct list of values from tables, return the dataset

  I am trying to select a distinct list of values from multiple tables, combine them into a single ta…

  BradWilk

  5 replies

  1 year, 11 months ago

  By: drew.allen

• Count only unique dates from a subquery

  Hello, I have a question. I have a code where I am trying to calculate 'Count of Days with Sales'. …

  JeremyU

  3 replies

  1 year, 11 months ago

  By: ScottPletcher

• Is it always better to redo a database, when upgrading an application?

  Today's editorial (Modern Development) got me thinking about a related topic, but I didn't want to …

  Rod at work

  10 replies

  1 year, 11 months ago

  By: Jeff Moden

• What is wrong with this query?

  Hi everyone I have a table that has close to 30 columns.  One of the columns UNDERLYING_SYMBOL need…

  water490

  3 replies

  1 year, 11 months ago

  By: water490

• Setting up a view with parameters

  Hi Folks, I'm not very well versed in SQL so I come here to the experts for advise. I have a nice l…

  Tourless

  6 replies

  1 year, 11 months ago

  By: Jeffrey Williams

• SQL Server converting "IN" to "OR" condition internally

  I have a TFS script with Check constraint " Check Col1 in (1,2)"  when deployed to database its cha…

  Chinna

  2 replies

  1 year, 11 months ago

  By: Phil Parkin

• T-SQL | Group Invoices with concern dates that overide the issue date

  I have a table with Invoice Documents per Project, in which i need to get statistics per project , …

  tkon1982

  5 replies

  1 year, 11 months ago

  By: drew.allen

• Select statement result change as insert statement values

  Hi All, Looking for following results. Can you please help in this. Original 1 A US Expected result…

  Saran

  7 replies

  1 year, 11 months ago

  By: Saran

• Stored procedures in Analysis server

  I have written a stored procedure to format data and return them as a table with custom columns. In…

  don075

  1 replies

  1 year, 11 months ago

  By: don075

• Correct syntax for this Contains statement

  I want to search a table alias doc, column name Result, where doc.Result is full text indexed, usin…

  isaac_654135

  1 replies

  1 year, 11 months ago

  By: isaac_654135

• How to check if SQL is installed on any of my multiple windows servers

  I have about 400 windows servers. How can I check if SQL Server is installed on any of those server…

  Mh-397891

  4 replies

  1 year, 11 months ago

  By: Mh-397891

• I can query one by one. Need help how to become Single Query

  Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY…

  Adelia

  4 replies

  1 year, 11 months ago

  By: Michael L John