SSRS Load Balancing, Listeners and Licenses - I hope someone can verify this for me. We're about to upgrade to 2017 and we're addressing an old question that...
How do combine row sets (create a Sku table from product / attribute combinations) - A store sells products. Products have attributes grouped into types. (Ex. Product 'shirt' has size and color, so a sku...
value based on sequence for each detail - I am using SQL Datawarehouse for my database Find the V,T,C in sequence for a given detail group by Shipment_id order...
DB design thoughts - This is more of a question around DB design as opposed to DML so hopefully I'm in the correct place. I...
Group by companyid with Latest date - Hi Team, Can you please help me on this below query. create table #test ( companyid int, companyname varchar(100), actiondate datetime ) insert into...
SSIS packages slow BCP processing - We are using SSIS packages to just do a data transform and map from one table to another. Within SQL Profiler...
????RHUL???RHUL??? - ??|??:695640122?RHUL??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??
????RSAMD???RSAMD??? - ??|??:695640122?RSAMD??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,?
????RCM???RCM??? - ??|??:695640122?RCM??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,
????UCL???UCL??? - ??|??:695640122?UCL??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,
????UAL???UAL??? - ??|??:695640122?UAL??” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,
?????????????? - ??|??:695640122?????” ~~~~~~~~~~ 24????????????,?????,?????????,?????????,????????, ???????,??????,?????? ???????Q /??:695640122?????????,???????,????,????/????????,?????,??,????,???????,?????????,?,?,?,:??,??,??,??,??,??,??,?
Login Failed for user Domain\User - I have a .net web app on development machine. It is WIndows 10 with .Net Framework 4.7, SQL Server 2012...
Transfer a text file from one server to another server - Is there any way to transfer a text file from one server to another server using powershellscript. Please help .
mapping back - i have table as below: country code australia 55555 australia 55555 australia checklater ukraine 33333 ukraine checklater ukraine checklater ukraine 33333 america 22222 i would like to map back the same country and replace the code...
Importing an XML file into a sql table - Edit to make things more understandable, I wish to import my XML file into an sql table. The XML has a...
SSIS 2017 connection to Access .accdb file - Sorry, I'm an SSIS noob. I've connected to .MDB files in the past using the Jet 4.0 connector, and it...
Modelling multi language datawarehouse - Hello I need your help. I work for a survey company and I am responsible for creating its architecture and modeling a...
Linked AS400 stopped working - We have a linked AS400, connected through OLEDB (IBMDASQL). Up until last Thursday it was working fine. We are now...
The SQL Saturday Thread - As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created...
