SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  2 years 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

  2 years 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

  2 years 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

  2 years 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

  2 years 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

  2 years 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

  2 years 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

  2 years ago

  By: Michael L John

• Need help on query within 2 column, generate another column

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

  Adelia

  5 replies

  2 years ago

  By: Adelia

• How to speed up this?

  Hi everyone One of my SSIS components seem to be very slow.  I am fairly new to SS so I am probably…

  water490

  18 replies

  2 years ago

  By: water490

• Need to output table data into multiple CSV files

  Hello, I created the below script to output 999 rows from SQL Server table into multiple CSV files.…

  Mh-397891

  1 replies

  2 years ago

  By: Johan Bijnens

• Convert Binary or Hex field to show text information

  Hi all, I have an SQL database table with events, and within it a field of binary (32) datatype. I …

  kakovatos7

  5 replies

  2 years ago

  By: Michael L John

• need some help with spilt raw data

  Hello,   I am trying to split data, looks like there is some special character or white space …

  mxy

  2 replies

  2 years ago

  By: Mr. Brian Gale

• error access is denied when access to remote shared path ?

  I work with SQL Server 2019 on server I face issue when I try to read an Excel file from shared pat…

  ahmed_elbarbary.2010

  3 replies

  2 years ago

  By: ahmed_elbarbary.2010

• Script for deleting data from a table and corresponding FKTables

  Hi, Looking for a script to delete data from a table and also from the FK tables of data exists. I …

  juniorDBA13

  4 replies

  2 years ago

  By: Wingenious