SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Select @ for different fields

  I have a need where I need to pass a field name to a Stored Procedure then lookup information on it…

  bswhipp

  6 replies

  4 months, 2 weeks ago

  By: Mr. Brian Gale

• Varchar(max) to lines

  I have an issue with a varchar(max) field with up to 7000 characters needing to be put in to lines …

  bswhipp

  5 replies

  4 months, 2 weeks ago

  By: bswhipp

• ERD Tools recommendation

  Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations? Thanks!

  coffee_table

  8 replies

  4 months, 3 weeks ago

  By: mamta25

• Beginner in sql server

  Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id…

  YuChan

  3 replies

  4 months, 3 weeks ago

  By: Steve Collins

• SQL Newbie HELP: The query references an object that is not supported in distr..

  Hi everyone! I'm new to SQL and am trying to query a view (dbo.) made from a D365 table. My goal is…

  WBenning

  1 replies

  5 months, 1 weeks ago

  By: Steve Jones - SSC Editor

• repeat results without loops, MSSQL2005 Express

  hello everybody, new here and this is my first question I have a table contains: Name, Id, joinDate…

  Sailor

  7 replies

  5 months, 1 weeks ago

  By: Sailor

• Question about Data Warehouse Management

  Hello SSC, Wishing everyone happiness and health and hope you are all doing well! I have a question…

  Lord Slaagh

  2 replies

  5 months, 2 weeks ago

  By: Lord Slaagh

• sp_prepare and sp_execute vs sp_executesql

  I have noticed sp_executesql also makes a single plan for a stmt with parameter in a loop. q1) Gene…

  rajemessage 14195

  2 replies

  5 months, 2 weeks ago

  By: Chandan Shukla

• Parameter sniffing issue with different minutes as opposed to using midnight

  Hej, I'm not facing this issue but as I was working another parameter sniffing issue I came to thin…

  mikael_ljunghorn

  5 replies

  5 months, 2 weeks ago

  By: mikael_ljunghorn

• XML_COMPRESSION for existing tables

  We are in the process of upgrading to SQL Server 2022 and would like to make use of the XML compres…

  zoggling

  2 replies

  6 months ago

  By: zoggling

• Is there some good routines for updating SQL Server database objects with GitHub

  At work we've been getting better at writing what's known as GitHub Actions (workflows, YAML). I've…

  Rod at work

  3 replies

  6 months, 1 weeks ago

  By: Rod at work

• Rounding Off issue in SQL Server

  I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64)  Microsoft Corporat…

  vikramchander90

  5 replies

  6 months, 1 weeks ago

  By: pedro.costa

• taking the rcsi dive

  Hi, we put together an extract that runs every 15 minutes against what i believe is a homegrown som…

  stan

  4 replies

  6 months, 3 weeks ago

  By: Ken McKelvey

• Tracking changing prices and recalculating inventory value

  I'm trying to figure out a how to do average costing over time in T-SQL... I'll use up ingredient i…

  pietlinden

  6 replies

  6 months, 3 weeks ago

  By: pietlinden

• having the right GIT (or whatever) for when i clone repos from devops

  Hi, i'm getting set up to begin using dev ops for source control over lots of dev types of objects …

  stan

  5 replies

  7 months ago

  By: Mr. Brian Gale