sql-server-2016-CodePudding

Tags > sql-server-2016

09-13databaseSQL - split numeric into 2 columns?
09-10databaseImproving and solving long running query
09-07front endHow to concatenate multiple columns values into a single value per unique row
09-06Software engineeringReplace first word in a string within query
09-01EnterpriseRemove all characters that fall in a certain pattern
08-30Back-endCompare a few columns for 2 different dates in same table, return what is different?
08-20otherSQL pivot based on fuzzy condition
08-18OSConvert Hex Data in an Image Field to String
08-02MobileUpdate an existing JSON Value inside JSON array
08-01NetIdentify if date is the last date for any given group?
07-30databaseSQL : Records with highest value of a column
07-13Software engineeringSQL - LAG but skip specific rows based on value?
07-07NetInsert records from TABLE_A to TABLE_B without inserting any duplicates
07-07BlockchainSQL - only increment ROW_NUMBER() on specific values
07-06databasehow to update each row using a counter in sql server
07-01OSSQL - calculate total value of group, row by row
06-30MobileHow to compare dates from just only one table, SQL SERVER
06-24Software engineeringOpenJson store processed object in original form
06-22front endTSQL FOR JSON nested value
06-17front endFormatting XML with `GO` into a set of sql commands to be executed
06-08MobileCumulative sum and cumulative count in sql
06-02BlockchainConnect ASP.NET Core container to remote SQL Server
06-01Back-endMultiple Pivot with an existing sql query working contains pivot
05-27OSSQL - Minus Payment amount from rows in ascending order?
05-27Software designIn SQL Server 2012 is there a way to validate a string to a specific DateTime format MM/dd/yyyy
05-18otherHow to find missing hours and show data as 0
05-17BlockchainHow do I Select distinct rows on multiple columns ignoring relations?
05-09Software engineeringTrigger for capturing changed columns in audit table
05-05Software engineeringConvert column to multiple rows using SQL Server
04-30front endConverting a large decimal with percentage sign (%) to a smaller decimal
04-24Software designJSON_QUERY with Column values
04-11NetUsing inline SELECT with IN operator
04-08Software engineeringIn SQL How to choose two of three or more tables to join based on a condition?
04-06BlockchainHow to convert a currency format (from Excel) into a decimal in SQL?
04-06BlockchainSQL - Transpose one column of data into a row
04-05OSMicrosoft SQL Server 2016 - T-SQL puzzle - overlapping date ranges in segregated rows - 'Gaps &
04-04Software designXQuery Node By Value Then Its Sibling
03-25OSGet new fields using existing string
03-22EnterpriseSELECT data first then UPDATE using clustered index or UPDATE directly?
03-19Software engineeringString split in SQL Server

77 1 2 Next Last