Hi Maria, if you want to deploy a report (.rdl) from Visual Studio, for TargetServerURL, you need to use  <a title="http:///reports" href="http://himalayas/reportserver" target="_blank">http://himalayas/reportserver ,
Himalayas being the...

Hi Maria, if you click on Connect and you get any errors, Click Find, Select 'Report Server Instance': , click Connect.
If you still get errors, go to Control...

Hi Maria, just use UNION ALL to join the queries of the 3 parts (State Grants, Federal Grants,  Federal Loan) into one query.
For SSRS, it's always best to use...

Hi RTaylor2208, 
We have a web service which pushes some information from many sites (cities or states) into a data-warehouse in another site (city or state). The daily amount of data...

Hi Phil, I used the section:

Data Warehousing »

Integration Services »

How to prevent disabled Sites in CRM from showing in SSAS and SSRS

So I was looking for...

Hi Lowell, I agree, the following will give Catalog Name:

SELECT * FROM openquery([SSASLocal], 'SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS')

Method 1:

If you connect to Analysis Services via SSMS, then right-click on the...

-- Below is based on Theo's script (just modified to run on local server (not remote server)

USE [master]

-- Setup a linked-server first (only need to do once off)

-- I use...

Hi celticfire63, did you run the code I posted (which I copied from your post), it returns null.

Hi MMartin1, your code works great, even with multiple studentuid.

Thanks.

Hi celticfire63, your method below gives same result as michael zrax.

Luis Cazares method gives what michael zrax wanted.

-----------------------------------------------

--DATA:

CREATE TABLE #tbldaysworked(

dayworkeddate,

namevarchar(10))

INSERT #tbldaysworked

SELECT '20140110', 'Harry' UNION ALL

SELECT '20130110', 'Dick' UNION ALL

SELECT...

Hi Jeff, I fully agree with cleaning the source. Only problem is it depends if you are responsible for it, if you are an application or sql developer, you can...