sqlsql-servertsql-CodePudding

Tags > sqlsql-servertsql

02-03otherAn association x-reference table
02-03Software designWhat is an efficent way of calculating a person's age at a particular time in the past?
02-02databaseMasking String with unconfirmed length
02-02databaseQuery to find 2 cheapest items sum value of which gives 3000
02-01Back-endHow to select, ignore the data when some values contain same value in the latest input(make it like
01-27EnterpriseChange dynamically generated view culumn's datatype
01-27EnterpriseCompare value of current row to average of all previous rows
01-26databaseconvert JSON array of foreign keys to comma separated list of names (from other table's field)
01-25MobileWhere is the tradeoff between a join with logic (ranges) versus a Join with an intermediate table?
01-24Netconverting datetime to float in sql
01-23databaseSELECT random 10% of rows for each category on SQL Server
01-21OSHow do can I combine two columns to perform an aggregation?
01-20Software designSubstring match in an arbitrary set of columns
01-20Software designAdding Child Records to New Columns Instead of New Rows
01-19Back-endParsing through free text field in SQL
01-16Software designHow to sort last four weeks between two years in SQL?
01-16otherWrite a (better)query that returns an aggregate with an associated value?
01-13databaseHow do I Improve T-SQL query performance for retrieving the most recent date?
01-13Software designI need a T-SQL script to update only the titles in a row for a whole table
01-12NetCalling Table-valued Function with inline convert parameter
01-08NetWhat does negative one mean when passed as a date in the DATEDIFF function?
01-06Software engineeringDisplay only the columns of two different select statements containing one row?
01-06MobileHow can I find the repeating ROW_NUMBER value in SQL and get the data set with the highest value?
01-04Back-endHow can I get the first state after a certain condition in SQL?
01-04NetSQL Server index rebuild consumes all disk space
01-04NetIn T-SQL, what does negative one mean when passed in as a date in the DATEDIFF method?
01-03NetHow can I get the information that the start time is the end time in the next change according to th
01-03NetHow can I optimize CASE WHEN - THEN statements when the conditional expression and the assigned expr
12-28front endHow can I group and sum data by day using T-SQL?
12-26NetSQL query with poor performances
12-22front endSet ParentKey correctly according the latest date
12-21otherSQL Server, Lazy Spool runs endlessly in View but not when I run the query directly
12-20EnterpriseSQL Code to forward-fill row values till next non-null rows in SQL Server
12-17Software engineeringUpdate with aggregate
12-11databaseTrying to JOIN table of transactional data (and aggregate on the fly) using between dates
12-09Software engineeringMore efficient way of creating extra rows based on data range
12-08EnterpriseDrop temporal table returns does not remove in a single query run
12-07MobileCreate a Variable that is declared for the length of a connection session?
12-02otherHow to I get distinct combinations of one XRef column related to any value in the other XRef column
12-02otherSQL statement to count instances based on a rolling 24 hour windows

96 1 2 3 Next Last