SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Case or LOOKUP Table on Common but simplistic values

  NOTE: I get that this may be too broad a question to answer and if so just say that, I get it. I do…

  YSLGuru

  2 replies

  8 months, 1 week ago

  By: ScottPletcher

• string_agg issue

  I have a string_agg line in my code that is bringing back hundreds of duplicates in my service_cd f…

  DaveBriCam

  12 replies

  8 months, 3 weeks ago

  By: DaveBriCam

• Losing Saved Connections in SSMS 2016

  Microsoft SQL Server Management Studio 13.0.16106.4 Hi , I am used to having saved connections in t…

  HeftSteady

  2 replies

  9 months ago

  By: Mr. Brian Gale

• Help with to generate Data pattern Sql help

  Need to generate a from and to From to 50 -99 100 -299 300 -- I tried to do the logic ,but its work…

  mnr123

  2 replies

  9 months, 1 week ago

  By: Jeffrey Williams

• Can you pass an undeclared variable to a Stored Procedure

  If I have a SP that calls another/different SP can I pass to that second SP a variable that has not…

  YSLGuru

  2 replies

  9 months, 2 weeks ago

  By: Dennis Jensen

• Deadlocks with UPDATE statements using serializable transaction isolation level

  We are seeing frequent deadlocks occurring due to a particular stored procedure that is using the S…

  zoggling

  8 replies

  10 months ago

  By: zoggling

• How To Approach Adding A primary Key To An Existing Table

  In our vendor created/managed DB we have a table that is like an audit table the vendor uses for tr…

  YSLGuru

  10 replies

  10 months ago

  By: Mr. Brian Gale

• How to get a distinct value from my data set

  Hi, I need help with writing a script that will allow me to pull a distinct value from column A, de…

  skaggs.andrew

  3 replies

  10 months ago

  By: ScottPletcher

• Error while Simultaneous Switching and BCP in same table

  Hi, Our application is created in VC++. We have House keeping process in which the data from main t…

  saum70

  1 replies

  10 months, 1 week ago

  By: saum70

• Database archive tool

  Does anyone know any good  database archive software/tools out there? We are looking into a tool t…

  samyu288@gmail.com

  3 replies

  10 months, 2 weeks ago

  By: Steve Jones - SSC Editor

• Insert (x) rows into table with y columns from string

  First I want to thank anyone who takes a moment to help with this.  I really appreciate all the he…

  Budd

  8 replies

  10 months, 2 weeks ago

  By: Budd

• How to get total sum across the table and sum grouped by date ranges

  Here is sample code and what I tried to achieve, but not getting the output, any advice? select k.c…

  SSCNewbee

  7 replies

  10 months, 3 weeks ago

  By: SSCNewbee

• the workaround for procs truncating varchar and nvarchar max output fields

  Hi , assuming the answer at https://stackoverflow.com/questions/50474892/return-strings-from-sql-se…

  stan

  2 replies

  10 months, 3 weeks ago

  By: stan

• Multiple deadlocks occurring with contentious code

  We are seeing multiple frequent deadlocks occurring with the following extract of code, which forms…

  zoggling

  7 replies

  10 months, 3 weeks ago

  By: Jeffrey Williams

• Order By on a single table raises Ambiguous column name error

  How in the world can the below query for a singular table produce the error msg "Ambiguous column n…

  YSLGuru

  2 replies

  10 months, 3 weeks ago

  By: Dennis Jensen