SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• 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

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

  2 months, 3 weeks ago

  By: ravitiwari

• 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

  2 months, 3 weeks 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 ex…

  danielfountain

  4 replies

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

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

  3 months 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

  3 months, 1 week 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. B…

  stan

  9 replies

  3 months, 1 week 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

  3 months, 1 week 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

  3 months, 3 weeks 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

  3 months, 3 weeks 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

  4 months ago

  By: Perry Whittle

• Problem installing SQL Server 2022

  Hello, I currently have an instance of SQL Server 2019 Developer installed on my computer. I'm tryi…

  cordellmelvin

  3 replies

  4 months ago

  By: cyrusbaratt

• What approach should I take in getting two databases to work together?

  At work I am rewriting an old application which no longer builds. It was poorly written to begin wi…

  Doctor Who 2

  2 replies

  4 months ago

  By: Rod at work

• Using a RETURN

  How does this capture multiple values from a cursor, and put them into an email message? DECLARE @S…

  stevec883

  6 replies

  4 months, 2 weeks ago

  By: stevec883