sql-server-2017-CodePudding

Tags > sql-server-2017

09-15Back-endSQL Server: Login failed for user 'testing'
09-14Back-endSplit one column with weird string into multiple columns by specific delimiter in single select sql
09-08OSCount days inside date period, count the first 7 days separately
09-06Software designConcatenating single quote in where clause to a variable in T-SQL
08-12BlockchainIs there a more efficient method of getting end of day?
08-11EnterpriseHow to Rank By Partition with island and gap issue
08-09Software engineeringWhy case..when get a table scan ? how to workarround
07-19NetSQL2017 TSQL Pivot multiple rows to flattenend table
06-28MobileWhy calculated fields using scalar functions are slow
06-28OSWhere to download the old SQL ODBC driver version 10 (not the Native Client)
06-15MobileI need to convert rows to column for calendar app
06-13Nethow does one use a created column as input to group by in SQL?
06-11MobileSQL - Separating a merge field into separate fields based on delimiters
06-09BlockchainHow to sign a SQL Server assembly created with assembly_bits / hex bytes?
06-06Back-endSign SQL Server assembly create with assembly_bits
06-06OSFind non consecutive date ranges
06-05Software designmerge consecutive dates ranges using SQL
05-27MobileAdd table data from sql server to text file with select query
05-11Back-endConverting VARCHAR with divide operand to INT
05-02front endwhich is best using delete or truncate when i need to delete all data from table?
04-01MobileSQL Server table data to JSON Path result
03-29MobileOrder competitors by multiple conditions
02-27Software designSQL SUBSTRING function doesn't work properly when using CHARINDEX function to locate ']�
02-16databaseIdentifying changes over time
02-11Software designGet the rank of each string extracted from split_string
01-01NetValues Across Different Rows - combine them into 1 row
12-30Back-endHow to run cumulative totals by date with multiple groupings
12-25MobileRecursive Sum of each level in SQL Server 2017
12-25MobileEscaped for JSON nested nodes using union command
12-07Software designFind and Replace values in curly braces with values coming from other column
11-27Software designSELECT TABLOCKX then MERGE vs MERGE with TABLOCKX
11-22BlockchainCalculate the previous sundays date from a Date column?
11-05Software designHow do I copy a DISTINCT set of column data into a new table and write back to the first table the I
10-29databaseCalculate Date difference between multiple rows SQL
10-28Software designNeed a better way to compare one column value to many column values in the same table row
10-20BlockchainOver Partition for set column SQL
10-17Software designPivoting but handling Column Names
10-12OSPERCENTILE_DISC - Exclude Nulls
10-12databaseWhat is the intent of this SQL statement?
10-11MobilePath between two points

43 1 2 Next Last