Data Value Mapping Question

Hi all,First, I am newbie in SSIS, so excuse me in advance if my question is obvious and I miss som…

Case Statement in a conditional Where Clause

Hello, I'm trying to accomplish creating a sql where clause based on a person's security setting i…

SSRS error when using ReportBuilder

Hi We get the following error when downloading a report from the reports db. The report itself runs…

Activity Monitor -Processor Time

Is there a way to see individually how much each process is taking up in relation to to processor t…

start a new select in a case function

Dear NG I have the following issue. I need to know the code of the parent from every possible …

How to Suppress backupToUrl in Error Log

HiDBCC TRACEON (3226,-1) Only works for Backup To Disk.I'm hoping to suppress this for BackupToUrl.…

Roll Up All the Versions

Comments posted to this topic are about the item Roll Up All the Versions

Querying vertically partitioned data(bases) - sometimes known as Federated Databases

Can anyone suggest a technology that will allow distributed queries across multiple servers where t…

Dynamic Colum Name ???

Hi I'm trying to set a column name as the variable below Declare....Set @Month1s = cast(dateadd(mon…

String Search

Data dictionaries

Looking at various options, obviously looking for the least amount of work for the biggest bang. Re…

Service Broker - Missing Permissions? or something else.

Hi, I was wondering if someone could help me find the missing permission. We have a process which u…

Multiple Grouping with multiple tablix controls

Dear Team,I have a requirement to show the data at 3 different levels with multiple sections(in dif…

XE in Azure

Comments posted to this topic are about the item XE in Azure

Issue with using STUFF

HI,I am executing below query in query window then it works fine and get the result for Dept field …