Hierarchical query match with multiple tables

I have this business_table ref_ID  name  parent_id -----------------------------ABC-…

Mind Boggling query.

Unable to remotely Connect to SQL 2014 Databases.

Just built Windows 2012 R2 two Node Cluster SQL 2012 Enterprise I have three databases added 1, V…

TRY_CAST in the WHERE clause.

Comments posted to this topic are about the item TRY_CAST in the WHERE clause.

copying Files

Hi Experts,I want to copy files from Server1  D: folder A and Folder B to server2 E: folder A …

Datepart (week) not playing nice

Hi all,I have a datepart issue I can't fix..The 'Date' column is a datetime DT.  --ATTENDANCE …

always include value in filter?

I have several fact tables and a Schools dimension table. IS there a way to always include a specif…

Multiple FK Tables or Single Table w/ Nullable/Empty Fields

I am struggling to decide what the best direction would be to go for one portion of a database sche…

Crosstab With column Sum(values) and Count(nrDocuments) by Entities

Hello communty, I try to build  a crosstab  that  return  for  each entity…

Create dynamic query to report number of products per month per company group with totals per product and per company

Should create a dynamic pivot table to report products sold monthly by company group. * There are s…

Writing IFF statements that reflect fields in various colors

I'm not a programmer by trade.  Fair warning....lol I'm struggling with writing an IFF stateme…

Unable to start Availability group role. error code 0x8007139a

Hello, we have a sql server 20012, latest service pack on a 2 node sql cluster with 1 availability …

Running SSIS from SQL Agent job getting error "Format of the initialization string does not conform to the OLE DB specification"

I am getting the following error when running an SSIS package from the SQL Agent job. "Format of th…

ssrs 2012 using nested isnothing statements

In an ssrs 2012 report, I need to display various messages depending upon if a field is null , if n…

Backup options on Amazon EC2

We have installed a SQL Server 2017 database on an EC2 Ubuntu instance. What will the most efficien…