SQLTeam.com | Weblogs | Forums

sql2014

Topic Replies Activity
SQL Server 19 February 24, 2020
To show the count per month from the date provided 5 February 22, 2020
Avoiding too may temp tables & tweak the query 4 February 18, 2020
Need to avoid NULL & replace with 0 in the result 5 February 15, 2020
Retrieve activities "Followed By" certain activities in SQL 21 January 18, 2020
Deleting records from tables related by foreign key 7 January 10, 2020
Free add-in for "SELECT * FROM" in Management Studio 4 January 1, 2020
Creating new database from saved database scripts 6 December 29, 2019
SSIS deployment through command prompt 1 December 27, 2019
Value based on sequence for each detail 6 December 16, 2019
Query using cast on XML data 6 December 12, 2019
SQL Server Stored Procedure execution from SSIS task 3 December 12, 2019
Make ranges with consecutive ports # and system# 5 December 6, 2019
Need to have ordered results in one shot query instead of 3 queries 3 November 27, 2019
SELECT statement on a stored procedure 3 November 22, 2019
How to log send new or modified records (for FTP purposes) 1 November 16, 2019
Get history tracks 5 November 15, 2019
Calculate a current row value depending on the previous and next values 22 November 12, 2019
SQL query for custoemr retention 10 November 9, 2019
I have Three tables, which need to be joined and columns to be computed based on their values 3 November 9, 2019
Prevent the same record from being extracted 4 November 8, 2019
Inserting into Parents and Child tables 4 October 28, 2019
Errors when Transferring MS Access data to SQL Server 2014 Express 5 October 23, 2019
Import / Export a user from one CRM organization to another 1 October 16, 2019
SQL JSON_Query is not working as expected when using case with For Json Auto or For Json Path 3 October 16, 2019
Database name as input parameter in a stored proc 2 October 12, 2019
Violation of … constraint ‘…’. Cannot insert duplicate key in object ‘…’ (Msg 2627) 5 October 11, 2019
Replace a set of null values for the same date with a set of existing values 5 October 7, 2019
A particular view 8 September 27, 2019
To show the count as 0 if no record is present or NULL 9 September 25, 2019