SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SchemaBinding and Temporal Tables

  I have schema bound a view to a temporal (system-versioned) table and receive no errors in doing do…

  dandschulz1433

  2 replies

  4 years, 3 months ago

  By: Bredon

• Subquery returned more than 1 value. This is not permitted !

  Hello, I run the following query: SELECT RIS_OPT_SERV.CTC_DEPOT ,CONVERT(CHAR(4), B.DATE_DE…

  silbahi

  3 replies

  4 years, 3 months ago

  By: Jonathan AC Roberts

• SSIS SQL Agent Job - SQL Step referring other server

  Hi there, everyone. I have a bit of a pickle. I need to move all our SSIS jobs from one server to a…

  darkangelBDF

  2 replies

  4 years, 3 months ago

  By: darkangelBDF

• tune a table valued function that is using recursive CTE

  We have a function that calculates student truancy records by counting their absence in a moving 30…

  sqlfriend

  15 replies

  4 years, 3 months ago

  By: VoldemarG

• Only lists records when StockValue changes

  Good day, After running below create and insert scripts, my query should only return the rows in bl…

  waldemar

  6 replies

  4 years, 3 months ago

  By: waldemar

• Is Fuzzy Matching available in SQL 2019 Standard?

  Hey folks. I can't seem to find a definitive answer to what seems like it ought to be a really simp…

  danchard

  4 replies

  4 years, 3 months ago

  By: Steve Jones - SSC Editor

• How to stop a user creating a new table

  I'm experiencing a problem where tables in my SQL Server database are getting randomly re-created a…

  Rupster

  6 replies

  4 years, 3 months ago

  By: Rupster

• T-SQL SubQuery Help Please

  Hi, I know this will be rather obvious to many, but I am struggling writing a sub-query at the mome…

  gs1975

  6 replies

  4 years, 3 months ago

  By: gs1975

• String Manipulation Work?

  Hello Geniuses, I have a string manipulation task that I am not sure is even possible...   Her…

  sqlislife

  2 replies

  4 years, 3 months ago

  By: sqlislife

• Where statment is not working when reference to table

  Good day today i manage to come across a problem when i am using where statment in my quri and refe…

  Deimos_farm

  5 replies

  4 years, 3 months ago

  By: Deimos_farm

• Help with non-clustered index fragmentation

  I'm trying to rebuild indexes to clear some heavy fragmentation in the nonclustered indexes.  I've …

  rando

  3 replies

  4 years, 3 months ago

  By: Jeff Moden

• Can I update an Excel file from SQL database?

  I am not sure this the right place to post this but, Is it possible to update an Excel file from an…

  jnbrown

  6 replies

  4 years, 3 months ago

  By: jnbrown

• 'Must declare the scalar variable' error msg.

  I have a simple query, however I am failing to understand the issue in my statement and getting bel…

  nayg

  3 replies

  4 years, 3 months ago

  By: nayg

• How can do a loop select stmt from this folowing table

  Hi..How can do a loop statement for the following table first loop shld be e1,e2,e3.... first loop …

  aggy_02_20

  5 replies

  4 years, 3 months ago

  By: The Dixie Flatline

• Many executionplans for one query, why?

  I've yet to find an answer for this. I've found a few queries that have a few executionplans. Why i…

  oRBIT

  2 replies

  4 years, 3 months ago

  By: jcelko212 32090