select * from [LINKEDSERVER].[DBNAME].dbo.CampaignFAct

CREATE PROCEDURE [dbo].[ReturnCustDetailsFromTelNumber]
	@DatabaseName varchar(200),
	@Telephone varchar(20)
AS
	BEGIN

	DECLARE @UseStatement varchar(2000)	
	
	SET @UseStatement = ('USE [' + @DatabaseName + ']')

	SET NOCOUNT OFF

	EXEC (@UseStatement + ' SELECT * from CustomerData where Telephone

:


AnnualRP = sum(CASE WHEN Original.CampCode like '%u%' 
AND(Original.CompletedCode = 24 OR Original.CompletedCode = 25) 
THEN cast((adprem)*12 as money)
WHEN Original.CampCode like '%u%' 
AND(Original.CompletedCode <> 25 AND Original.CompletedCode <> 24) THEN 0 
ELSE cast((Price)*12 as money) END) 
+ (Select

CREATE PROCEDURE [dbo].[ReturnCustDetailsFromTelNumber]
	-- Add the parameters for the stored procedure here
	@DatabaseName varchar(200),
	@Telephone varchar(20)
AS
	BEGIN

	SET NOCOUNT ON --!

	DECLARE @UseStatement varchar(2000)	
	
	SET @UseStatement = ('USE [' + @DatabaseName + ']')

	SET NOCOUNT OFF --!

	EXEC (@UseStatement + ' SELECT

CREATE PROCEDURE [dbo].[ReturnCustDetailsFromTelNumber]
	@DatabaseName varchar(200),
	@Telephone varchar(20)
AS
	BEGIN
	DECLARE @UseStatement varchar(2000)
	SET @UseStatement = ('USE [' + @DatabaseName + ']')
	EXEC (@UseStatement + ' SELECT * from CustomerData where Telephone = ''' + @Telephone

Public Shared Function timeFormat(Seconds As Double) as String
   Dim t as TimeSpan
   t = TimeSpan.FromSeconds(Seconds)
   timeformat = CStr((t.Days*24) + t.Hours) & ":" & t.Minutes & ":"

=Fields!TotalDailySeconds.value

 =sum(Fields!TotalDailySeconds.value)

=code.timeFormat(ReportItems!ctlTotalTime)

Public Shared Function timeFormat(Seconds As Double) as String

Dim outHours, outSeconds, outMinutes as Double

if (Seconds = nothing) or (Seconds = 0)
     timeFormat = 0

else
    outHours = Seconds / 3600
    outMinutes = (Seconds % 3600) / 60
    outSeconds

Public Shared Function timeFormat(Seconds As Double) as String

if (Seconds = nothing) or (Seconds = 0)
     timeFormat = 0

 else