Self Join Question - I've got a table with the following fields in it: UniqueID Sequence BeforeStatus AfterStatus HistoryStatusDate Sample data looks like : 08-40089445, 1, '','BNT',10/17/17 08-40089445, 2, 'BNT','VFD',1/18/18
Calendar table - I have been trying to find out the best way to design a Normalized table for
how to do Intermediate calculations for partial rows based on a particular field - I have a data table which has RowNo, EntityName, Value, KeyYear. RowNo is Unique. EntityName and KeyYear combination is unique...
Remove duplicate record based on criteria - Hi All, EDIT: I was convinced I was connecting to a 2016 instance but just now found out it's in-fact a 2008...
Result truncation bug - Here's an interesting riddle. I'm building a code generator, so the SELECT clause is just one great big concatenation of...
Does denormalizing the data enhance performance? - We have a sales tracker report which uses a view and that view was created from 15+ tables. I have...
Background blocking process - I have sql server 2014 has a system process that is blocking another systems process every 15 mins and then...
SQL Probe Bitmap 1008 high CPU - We have a very simple query and appropriate index has been created on both tables. But both tables are doing...
Looking to sort two queries by Date, Time - SELECT LTRIM(RIGHT(CONVERT(varchar(6), .,100),7)) AS --, FORMAT(., 'MM-dd-yyyy') AS , CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), .,101),'/','-')) AS , LTRIM(RIGHT(CONVERT(varchar(20),
Replication Issue - Cannot see SUBSCRIBER DATABASE - Hi. I'm having a replication issue on a simple Transactional Repl setup for 2012 PUBLISHER to 2008 SUBSCRIBER. When I get to...
Query performs poorly on prod server, works well when run against a restored copy of DB - Hi all, I have an query that has been set up and running as part of a sql job in prod...
Restrict resource comsumption for user - I have a user who I granted with read only access to our DW and I wanted to know if...
Creating record from multiple records pt 2 - Hi I have the following table which I need to do the following to: 1. Create a single record for each user. 2....
SSMS connect to another server => How to ? - Hello all, before where i worked, it's was possible in sql server management studio to connect to a sql server by...
Data migration from one database to multiple databases - Hello, There are millions of records in one database and expecting to migrate records from two or more tables to other database...
INSERT running slow in SQL 2016 - Good Morning Experts, We had a database on SQL Server 2012. INSERTS were running fine. We migrated this database to 2016...
Getting SSRS 2016 installed properly (so all the pieces work) - I'm trying to install SSRS on my laptop (Win 10, if it matters), but if I customize at all, things...
email with attachment powershell - This code runs successfully but does not send an email.Any help is appreciated. Add-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinue function sendmail_withAttachment { Param ( # $smtpServer...
New destination column not saving - Hello SSC, I have a simple SSIS package with a Source and Destination. The Source is a SQL Server view, the...
Migrated DB to 2016, having ODBC Access problem - Thanks in advance for any clues on this problem. I'm migrating several SQL Server databases from SQL2005 to SQL2016. One...