use table variable tables for easy understanding.

-----------modify only third sp

Create Proc Third

AS

begin

Declare @date1 int

, @date2 int

, @date3 int

declare @VerTable2 table(SndSpV int)

declare @VerTable1 table(FstSpV int)

insert into @VerTable1 exec...

thank q Hugo Kornelis for clear explanation for my post.

thank q Koen Verbeeck

hi

find below code

declare @retval varchar(100)

DECLARE @Str VARCHAR(100);

set @Str='Nyal Pra Raj'

SET @str=RTRIM(LTRIM(@str));

SET @retval=LEFT(@str,1);

WHILE CHARINDEX(' ',@str,1)>0 BEGIN

...

Very nicely article share with us ,thank q Dwain Camps.

regards

prasad

hi all,

i got answers

declare @table table (rid int, tot int)

insert into @table

select 1,10

union

select 2,20

union

select 3,30

union

select 4,40

union

select 5,50

union

select 6,70

SELECT rid,tot,

(SELECT SUM(tot)

...

hi,

I think you can use two select statements

1) for select top 10 results with count

2) wanted columns list from tables using where cluase above Query.

SELECT TOP (10)...

hi all ,

Regarding above issue I got a answer

declare @var1 varchar(5000)

declare @table table (ColNames varchar(5000))

insert into @table

----here i doesn't want COLUMN45,COLUMN46,COLUMN35(you need to write which columns doesn't want)

select stuff((select...

2008 r2

Put single quotes (') around your dates

like

USE [RECLACSR-DB]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[ListeLettreFichier]

@DateDebut = '2012/05/01',

@DateFin = '2012/05/30'

SELECT 'Return Value' = @return_value