SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• How do I add files to the server?

  Hello all, I would like to begin storing and displaying PDFs and images using SQL Server.  However,…

  mjdemaris

  23 replies

  1 year, 10 months ago

  By: Ken McKelvey

• Import ridiculously large CSV file

  First off, I know how to spell BCP, and that's about it. I'm trying to import a stupid huge CSV fil…

  pietlinden

  8 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Time allocation across blocks of time

  I've been working on this problem for a few days now and cannot find a way to solve it. blockstart …

  max266

  24 replies

  1 year, 10 months ago

  By: max266

• Advanced SQL Query Optimization Assistance Needed

  Hey guys, I'm having a real tough time optimizing a SQL query for my project. I've been working wit…

  sindhuagarwal

  4 replies

  1 year, 10 months ago

  By: Johan Bijnens

• Excel report into SQL - View

  Please assist. What would be the quickest and most convenient/effective way of turning an Excel rep…

  yrstruly

  4 replies

  1 year, 10 months ago

  By: Phil Parkin

• Trigger to track changes

  I need to track changes when a column is updated on two tables. Is there a way to do it. please sen…

  sqlguy80

  9 replies

  1 year, 10 months ago

  By: Mr. Brian Gale

• No Data Being Inserted

  I have a table that i populate using joins.One of the tables don't insert its data. Tables are:-- T…

  yrstruly

  2 replies

  1 year, 10 months ago

  By: Emperor100

• Generate sql in the instance

  I need to generate SQL code that, in the instance, creates all the objects for each of the database…

  vpmaciel

  5 replies

  1 year, 10 months ago

  By: Emperor100

• Searching in date field provides inconsistent results

  I have been working with SQL Server for too many years to count and this is baffling; perhaps someo…

  Ed Thompson

  12 replies

  1 year, 11 months ago

  By: jcelko212 32090

• inserting into varchar field doesn't error when > 8000 bytes

  hi, Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why …

  robh0502

  8 replies

  1 year, 11 months ago

  By: Jeff Moden

• SQL Query help

  Hi, How can Insert the same record until I find the next value in SQL? Here is my sample code/data.…

  mikesql710

  2 replies

  1 year, 11 months ago

  By: drew.allen

• Replace Special Characters in SQL

  How to replace all special characters in SQL input System.Text.RegularExpressions.Regex.Replace(inp…

  ralahari

  3 replies

  1 year, 11 months ago

  By: Phil Parkin

• Query Help regarding top 10 customer

  I am newbie to  SQL programming. wanted to get top 10 customer for the totaldue. tried to build the…

  praveensc2021

  7 replies

  1 year, 11 months ago

  By: praveensc2021

• SSRS Report Performance issue after Upgrade

  We Upgraded db from MSSQL 2008 to Microsoft SQL Server 2019  & SSRS Server 2008 to 2014 While r…

  ralahari

  4 replies

  1 year, 11 months ago

  By: ralahari

• Loop query help

  Hi Guys, Please see below the test data and syntax. What I want to populate a one field based on ca…

  rocky_498

  9 replies

  1 year, 11 months ago

  By: Steve Collins