SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Select Returning Blank Rows

  I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as S Where…

  JP789

  5 replies

  1 years ago

  By: JP789

• How to update a history table with changes.

  Good morning to all.  I am a novice when it comes to SQL so my question is TSQL related on how to u…

  bswhipp

  4 replies

  1 years ago

  By: Phil Parkin

• After an Oracle migration, write out a function into a View SELECT statement

  This is the function oracle.xxxfloat BEGIN IF @first IS NULL OR @second IS NULL RETURN NULL IF @fir…

  stevec883

  13 replies

  1 years ago

  By: xemsomenh

• Inserting data into a column that is using Always Encrypted

  Problem: I am trying to insert a a value into a column that has been encrypted using 'deterministic…

  PearlJammer1

  2 replies

  1 years ago

  By: Emperor100

• SSIS Execute Process Task forfiles not working

  I'm trying to use forfiles in an Execute Process Task in my SSIS package to delete files older than…

  s15199d

  2 replies

  1 years ago

  By: s15199d

• sql server not responding

  SQL server became slow before I ran exec sp_updatestats

  aman

  3 replies

  1 years ago

  By: Mary_Jen

• Junk Dimensions

  Reposted this in Data Warehouse  forum. This topic was modified 1 years ago by Lord Slaagh.…

  Lord Slaagh

  1 replies

  1 years ago

  By: Lord Slaagh

• Getting error in sql server 2022

  Hi folks We have migrated database from sql server 2014 std to sql server 2022 std. database get re…

  zacharyfull

  2 replies

  1 years, 1 months ago

  By: Emperor100

• Volunteering SQL Server Skills

  Can anyone please recommend where one can volunteer SQL Server skills to gain experience in other t…

  zoggling

  2 replies

  1 years, 1 months ago

  By: Jeffrew

• Convert stored procedure into a Table-valued function

  <sorry, duplicate> =(   This topic was modified 1 years, 1 months ago by pietlin…

  pietlinden

  1 replies

  1 years, 1 months ago

  By: pietlinden

• Convert stored procedure into a Table-valued function

  Feel like I'm missing something blatantly obvious. I am trying to return the cost of each of a set …

  pietlinden

  2 replies

  1 years, 1 months ago

  By: pietlinden

• Or condition in where clause works differently in MS SQL comparing with Sybase

  Hello, I ran below statements in MS SQL, and got error, but fine in Sybase: create table testDiffTy…

  james_toronto

  10 replies

  1 years, 1 months ago

  By: james_toronto

• ROWID in MS SQL

  How to rewrite a query in MS SQL, please? WHERE a.ROWID IN (SELECT rid FROM ( SELECT ROWID rid, row…

  tizma

  3 replies

  1 years, 1 months ago

  By: Faustalker

• RLS Causing RBAR

  Hi all, First I want to ask just a generic question.  Does RLS in SQL always cause a Row by Row exe…

  danielfountain

  4 replies

  1 years, 1 months ago

  By: Jonathan AC Roberts

• Having issues installing SSIS extension for VS 2022 Community

  I have installed the SSIS extension for VS 2022 community. When I go into Manage Extensions, it is …

  daniel.manke

  4 replies

  1 years, 1 months ago

  By: daniel.manke