SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SUM with a ISNULL - Need to show as 0 (Zero) versus NULL

  Is it possible to have '0' (zeros) versus a NULL in my output?   DECLARE @GroupBy1 VARCHAR(10…

  Jeffs1977

  9 replies

  4 years ago

  By: frederico_fonseca

• ODBC Driver 18.0

        Attachments:You must be logged in to view attached files.

  Peter Heller

  1 replies

  4 years ago

  By: Peter Heller

• IIF statement query using SQL server

  hey, Using the following statement I can calculate conversions taking place within the same month: …

  danny_s

  4 replies

  4 years ago

  By: Phil Parkin

• How to show table in one row

  Hello everyone, I want to display the information in the table in one row for each status (show the…

  giladsh

  3 replies

  4 years ago

  By: giladsh

• Select from a table that might not exist

  Hello! I'm writing a query. As per the logic in my SELECT statement there should be a column from a…

  nkat

  5 replies

  4 years ago

  By: DesNorton

• with within with error

  Hello! Please, consider the following simple code   with cte AS ( SELECT [cntSRV…

  nkat

  4 replies

  4 years ago

  By: nkat

• Global ##TempTable created from different source databases - Naming Conflict??

  Hi all,  Really quick one I hope.   I have a stored procedure as part of an ETL process that d…

  aaron.reese

  7 replies

  4 years ago

  By: frederico_fonseca

• Max data based on month

  Hi All I have a requirement like below ,need to take max of the week data. Ref table +  data table …

  LearnSQL

  4 replies

  4 years ago

  By: Jeff Moden

• Import iAuditor Inspection Data to SharePoint

  Has anyone run into any issues with importing iAuditor to SQL Server?   Thanks, JP

  JP789

  1 replies

  4 years ago

  By: JP789

• Export SharePoint 2013 Lists to SQL Server

  I'm looking for the best way to export SharePoint Lists to SQL Server, preferably with some automat…

  JP789

  1 replies

  4 years ago

  By: JP789

• Extended event - slow queries and waits

  I have an extended event which filters on my slow queries. I have created the following script for …

  Peter Kruis

  3 replies

  4 years ago

  By: Peter Kruis

• Parse the file name in expression

  Hi all, I have SSIS Package in which we uploads files and fetch date based on the file name. The fi…

  christi1711

  5 replies

  4 years ago

  By: christi1711

• ssis output to flat file limit size/number of rows

  Hi All, I'm pretty new to ssis so hoping i can get some suggestions and/or examples on this. I'm us…

  jbrizu2

  5 replies

  4 years ago

  By: jbrizu2

• "Frankenrows"

  I'm not sure if that's the correct term for what we're seeing here, but it seems appropriate. Here'…

  julian.fletcher

  8 replies

  4 years ago

  By: Jeff Moden

• SQL Duplicate remove Query

  Hi Guys, I want to remove duplicates from the table. The duplicate is a typo in the first and last …

  rocky_498

  5 replies

  4 years ago

  By: Jeff Moden