SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  6 months, 2 weeks 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

  6 months, 3 weeks ago

  By: Jeffrew

• Convert stored procedure into a Table-valued function

  <sorry, duplicate> =(   This topic was modified 7 months ago by pietlinden.

  pietlinden

  1 replies

  7 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

  7 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

  7 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

  7 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

  7 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

  7 months ago

  By: daniel.manke

• ROWID in MS SQL

  WHERE a.ROWID IN (SELECT rid FROM ( SELECT ROWID rid, row_number() OVER (PARTITION BY c.id ORDER BY…

  tizma

  4 replies

  7 months, 1 week ago

  By: Jeff Moden

• Prepare Sum of Bill Amount Having two different status with fast performance

  1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY…

  techrajendra

  4 replies

  7 months, 2 weeks ago

  By: drew.allen

• what happens to ssis and ssrs whenb we migrate to sql saas

  Hi we know (or believe)  ssas saas gets stood up separately when a company migrates to sql saas. Bu…

  stan

  9 replies

  7 months, 2 weeks ago

  By: ozdobomaniaczka

• Solution to a problem without using a CURSOR

  Hi there to all SQL gurus So, here is the scenario. I have a #temp table in one of my SQL stored pr…

  krishnagceb

  5 replies

  7 months, 2 weeks ago

  By: krishnagceb

• Transpose sql table rows into columns

  I want to transpose sql table rows to columns. I have written a query for that already but its taki…

  SQL Bee

  4 replies

  8 months ago

  By: Jez-448386

• Getting blockage on Update Statement

  Hi, Need your help. I've a SP that is using Update statement on a table. 2-3 processes are updating…

  anshu.shikha

  6 replies

  8 months ago

  By: Jeff Moden

• Issues with SQL Server 2022 Server

  Hello, At my work place I recently migrated our test environment to SQL Server 2022 on Windows 2022…

  alisonwheeler

  6 replies

  8 months, 1 week ago

  By: Perry Whittle