How to declare variable and assign value in xslt

Hi,

I am converting a VB6 app to VB2008 and are having problems with replacing Variant variables.

I used Variant in cases where the data might be string or Null.

Is there a way I could check for Null and just set the string to zero lenght?

Any help would be appreciated.

Ragnar

Hi All,

I have to write query in which i have to declare variable ,i dont want to use SP ,i tried to write in DATASET only.

The query which runs fine in Query window in SQL as below

declare @a int

Set @a=(select count(*) from roles where rolename='browser')

select @a

but when i run the same query in SSRS Dataset in throws error

"An error occured while the query design method was being saved. ORA-06550; line 1,column 9:PLS-00103: Encountered the symbol "@A" when expecting one of the following:

Being function package pragma procedure subtype type use <an identifier><a double -quoted delimited-identifier>form current cursor

Kindly Suggest how to declare variable in SSRS dataset

Amit

Hi folks, can someone please help me with this error?

Msg 102, Level 15, State 1, Procedure AddCMEXperience, Line 15
Incorrect syntax near ','.

Msg 137, Level 15, State 2, Procedure AddCMEXperience, Line 49
Must declare the scalar variable "@ReasonLeft".

Here is the Stored Procedure that is in question here

USE [ResponsedDatabase]
GO
/****** Object:  StoredProcedure [dbo].[AddNewEmployer]    Script Date: 10/03/2010 14:24:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[AddCMEXperience]
(
    @MemberID bigint,
    @EmployerID bigint,
    @DateStarted smalldatetime,
    @IsContinuing bit,
    @DateLeft smalldatetime,
    @PositionStarted nvarchar(50),
    @PositionLeft nvarchar(50),
    @StartingSalary nvarchar(20),
    @EndingSalary nvarchar(20),
    @TimeWorked float,
    @JobResponsibilities text,
    @ReasonLeft, nvarchar(200)
)

AS

INSERT CMExperience
(
    MemberID,
    EmployerID,
 &nbs

Hello,

I have the following:

use master
go

exec sp_configure 'filestream access level', 2;
reconfigure;
go 

declare @Database nvarchar(40) = 'MyDB';
declare @Login nvarchar(40) = 'MyDBLogin';
declare @Password nvarchar(40) = 'MyPass';
declare @Role nvarchar(40) = 'MyRole';

if exists (select * from sys.server_principals where name = @Database)
drop login @Login
go

I get the following error on "drop login @Login":

Incorrect syntax near '@Login'.

What am

I am receiving this error in my application :" Must declare the scalar variable "@UserId"."

Here is the code that generate the error: