Two DataSets, Two aggregates combined

I am struggling to create a report to show statistics on shipments. One data set selects Item#, Ord…

Pass Multi Value Parameters to SSRS Report Using URL

Hi , I've a URL below with 5 multi select parameters (Branchcode, Branch, Niche, Team & Consul…

Easily grant access to a single Azure sql database-view

Hihow can I easily grant access to a single Azure sql database-view (without creating an AD account…

Msg 102, Level 15, State 1, Procedure AuditView, Line 1 Incorrect syntax near 'AS'

When i try to run the below procedure from my application i am getting stored procedure error as Ms…

Question about agent jobs

Hi,All of my jobs have stopped running, and I noticed something in security.If I go to my agent log…

Conversion Error and Language Settings

Hi Experts, I am facing a strange issue where casting varchar to date throws conversion error …

Self-join Update query taking too long to run

Hello,I have a query that runs on daily basis and keeps on looping itself and takes too long to run…

Issue with Chinese Unicode

I tried many collations still the below sql returns ??????  , Please help. declare @titleEntry…

Mind Boggling query.

SQL AlwaysOn AG - Cluster with a secondary replica in DR location

Hi everyone, I am taking over a SQL AlwaysOn Availability Group Clustering and there is a cluster n…

SSMS Slow Open

Is it normal for SSMS 2012 to take about 42 seconds to open on a workstation? Windows 7 Enterprise …

SQL Server 2014 to Oracle 12c Replication issue | Datatype mismatch

Hi, I've setup replication between SQL Server 2K14(Publisher) and Oracle 12c(Subscriber). During In…

pb in archived file

Hello everyoneI will need to do a simple ETL SSIS that takes care of doing imported lists of txt fi…

SQL Server 2016 32 bit.

Is 2016 available in a 32 bit version?   How about 2012? Thanks... When the snows fall an…

SMO Scripting

Comments posted to this topic are about the item SMO Scripting