Does the DDS column in the table/view contains comma separated values (of each offices)? If yes, then you have to use the LIKE operator using wildcards.

SELECT BOCLEARED, CTCLEARED, MECLEARED,...

...You can also connect to a remote server using OPENROWSET function. Check in Books Online for OPENROWSET function, it has an example on connecting to a remote sql server....

I don't know why it's not working in EXCEL, but I know this task can be done without cursors. Well, in fact, it is just a simple SELECT...

SELECT *...

..Create a linked server in your local server using sp_addlinkedserver and a remote login mapping using sp_addlinkedsrvlogin. Then do a cross server select/insert query using four-part naming convention.

Here is an updated version with ONLY one PIVOT and it should also perform better than the one you have

by approximately 30% (though I am not sure about it, because...

Unfortunately, I...

Goto...

Why do you need to store these values in a separate table? Why can't you query the view that you just now created? It will have all the...

Excerpt from BOL:

Corresponding columns in the result sets that are being combined with UNION, or any subset of columns used in individual queries, must be of the same data type,...

Firstly, it was my mistake, I...

...Don't worry we are here to...

...Simple, need 1 Data Flow Task, 1 SQL Connection & 1 Flat File Connection

Jack Corbett (2/11/2009)

---

It doesn't look to me like you have uninstalled. It looks like you already have default instances of Analysis Services and SQL Server, so you would select...

Assuming that this ssvs004.byu.edu includes the domain name, you can try using the actual machine name (without the domain suffix). If you still can't access the server, then it...

The LEN function does not work on MAX data types. Use DATALENGTH instead to find the length of the string. Note that, DATALENGTH returns the bytes required to...