SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Simplifying WHERE Condition with LIKE test on multiple columns

  Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1] LIKE 'B…

  Reh23

  4 replies

  4 months ago

  By: Reh23

• Switch partition: NULL boundary id

  I have table: t1 in schema1 with 19 billion records. I have another table with same name: t1 in sch…

  vpolasa

  1 replies

  4 months, 2 weeks ago

  By: Jo Pattyn

• Deleting data in large table

  I have a large table with 17M+ rows for our package record audits.  I've decided to clear out anyth…

  Jackie Lowery

  12 replies

  4 months, 3 weeks ago

  By: Jonathan AC Roberts

• This doesn't make sense to me - making me crazy - er

  Hi So I have the below select query that won't return results if I have it this way:   --DOES …

  krypto69

  4 replies

  5 months, 1 weeks ago

  By: krypto69

• fast farward curson vs while loop on @table

  hi, need to known weather fast farwand cursor is faster than a while loop made on @table variable h…

  rajemessage 14195

  4 replies

  5 months, 2 weeks ago

  By: carwalk

• Find all the tables in a database containing particular column value

  Hi, I want to find all the tables name under a database where tables having text like "ID". Like in…

  RCRock

  7 replies

  5 months, 2 weeks ago

  By: pietlinden

• Looking for help with SQL statement

  Hi there I am seeking some help with an SQL statement. Any help would be welcomed. TIA   See t…

  DalF1960

  6 replies

  5 months, 3 weeks ago

  By: ScottPletcher

• 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

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

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

  6 months, 1 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

  6 months, 1 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

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

  6 months, 4 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

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

  7 months ago

  By: Chandan Shukla