Are you logging in (SQL Wise) with a login that has restricted rights? Also, are you loging onto the server directly or from another machine (using Management Studio)

CONVERT(NVARCHAR, GetDate(), 100) As Date - Nearest to what you want. See link below... Nothing stopping you from stringing sentence together...

(CONVERT(NVARCHAR, GetDate(), 101)) + ' ' + (RIGHT(CONVERT(NVARCHAR, GetDate(),...

Hi, Use the following code to assist;

==============================================================================

CREATE FUNCTION [SCHEMA].[NAME]

(

@myDelimitedList NVARCHAR(MAX),

@mySeparator NVARCHAR(255)

)

RETURNS @tblList TABLE (vchItem NVARCHAR(MAX))

AS

BEGIN

DECLARE @mySeparatorPosition INT;

DECLARE @myExtractedValue NVARCHAR(255);

WHILE LTRIM(@myDelimitedList) <> N''

/* WHILE BATCH */

BEGIN

/* GET POSITION OF FIRST SEPARATOR...

What address are you using to browse to Report Manager... is it like 'http://localhost/reports' as opposed to 'http://localhost/reportmanager'?

I'm guessing it's how you would access using Management Studio. When you start MSand you are required to enter you credentials and which server you wish to connect to there...

Ideally I'm after a report for use with the Report Services, essentially a report which summaries the users with access to each of our reports on SSRS. As if a...

What do you want instead of nulls? Guessing you want '0', is so easy, ISNULL([FIELDNAME],0) As [FIELDNAME], and again just incorporate the temp table into the stored proceedure,

Create a...

oh and not forgetting the WHERE clause...

Create Procedure rpt_StudentCombined

Declare @studentid varchar(12)

SELECT tblStudent.studentid , tblStudent.firstname, tblStudent.lastname, tblSemester.semesterid,tblSemester.semestername

FROM tblStudent

INNER JOIN ON tblStudent.studentid = tblSemester.studentid

WHERE tblStudent.studentid = @studentid

Okay, what are you trying to show, I'm guessing by the look of the code you want a list of the students by semester? etc, so why not just write...

Are you able to post the code? So from what you are saying, you run one SP which in trun feeds into another SP? Then the final results are then...

Create two datasets, each data set using one of your Stored procedure. You can then use multiple in your reporting... Although you will/may have to display the two datasets in...

Thanks for the quick reply. Just to ensure I understand this correctly If I store the credentials in the data source then the credentials are self contained in reporting services......

Great, Is there also a solution to SQL cutting and pasting the calls recordings to another location as part of this process?

Just to confirm then, when the 3rd party app writes the data back to this table, hen the trigger fires and changes the last column to Null from what ever...

Also are you creating a report for use in SQL reports, have you used the .net BI Tookkit to design your reports? If so you can format the values in...