SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• can my phone run ssms inside our firewall?

  Hi my phone is now upgraded to allow teams , outlook etc using my work account.   Its a portal more…

  stan

  3 replies

  1 year, 2 months ago

  By: Mr. Brian Gale

• what have people done for ssrs params needing very precise start and end times

  Hi we run 2019 standard.  one of our mfg locations requires somewhat precise start and end param ti…

  stan

  2 replies

  1 year, 2 months ago

  By: Jeff Moden

• is netsuite's analytics warehouse (NSAW) a viable alternative to the sql stack?

  Hi our corporate level warehouse currently sits on sql server 2019 standard where some cubes also r…

  stan

  1 replies

  1 year, 2 months ago

  By: stan

• error in both ssis and ssms - something about losing connections - new error

  hi for about 4 or 5 days now, i've been seeing various connections (to our dw server) issues in ssi…

  stan

  11 replies

  1 year, 2 months ago

  By: stan

• UPSERT question for performance and efficiency

  Hello SSC! First, I would like to thank everyone for responding to my posts. It is greatly apprecia…

  Lord Slaagh

  8 replies

  1 year, 2 months ago

  By: Lord Slaagh

• When exporting data from SQL Server to Excel file getting error message.

  I am working with a SSIS package that loads .CSV files from a network drive to the database, proces…

  BradWilk

  5 replies

  1 year, 2 months ago

  By: Phil Parkin

• Compare query results between two databases

  Hi. I would like to compare results of a query to highlight differences in the data between a produ…

  2Tall

  11 replies

  1 year, 2 months ago

  By: Johan Bijnens

• Return string between parentheses

  Hi. I have a column that lists group names. Varying lengths. I want to extract the text between the…

  2Tall

  7 replies

  1 year, 2 months ago

  By: 2Tall

• How to get calculated values from a derived(?) table?

  Here is my filtered dataset: I would like to calculate the time difference between each 0 and 1 th…

  mjdemaris

  12 replies

  1 year, 2 months ago

  By: mjdemaris

• Summarize the proportions stored in the table

  CREATE TABLE dbo.tab1 ( idrow INT NOT null IDENTITY, group1 VARCHAR(10) NOT NULL, c1 NUMERIC(…

  us26

  7 replies

  1 year, 2 months ago

  By: Steve Collins

• how to find a table who have updated and when have updated in a week duration i

  how to find a table who have updated and when have updated in a week duration in sqlserver need a u…

  naga.rohitkumar

  1 replies

  1 year, 2 months ago

  By: frederico_fonseca

• where is my commit size in my pkg

  hi, while trying to give our operations guys as much info as possible about a separate ssis issue /…

  stan

  8 replies

  1 year, 2 months ago

  By: stan

• needing to insert 2 sets of numbers to a table to use as ranges for a query

  the ranges (a lot) need to have a preset spacing between each set of numbers. value1, value2 -99999…

  roy.tollison

  6 replies

  1 year, 2 months ago

  By: schleep

• How do I get a certificate for a SQL Server database?

  I'm working on a new application at home, using SQL Server 2019 Developer Edition. I'm trying to sc…

  Doctor Who 2

  2 replies

  1 year, 2 months ago

  By: Ken McKelvey

• Sum Nested Join Help

  Hello all, I have a query where I am trying to do a left join to gather a sum and this one seems no…

  beantownace

  3 replies

  1 year, 2 months ago

  By: jmetape