Viewing 10 posts - 1 through 10 (of 10 total)
Hi sumit.agrawal,
Thanks for your correction.
July 20, 2010 at 1:02 am
Hi,
Sorry for the delay.yeah i saw my problem any have u got solution.
i give one example for charindex here,
select charindex('t','sethuraj')
First Parameter - Return the...
July 20, 2010 at 1:00 am
Hi,
I findout solution for interchange the variable without Temp variable.
Pls see below solution helpfull for you
DECLARE @Var1 varchar(max),@Var2 varchar(max)
SET @var1='Sethuraj'
SET @var2='Sahithya'
SELECT SUBSTRING(@var1+@var2,CHARINDEX(@var2,@var1+@var2),LEN(@var1+@var2))
SELECT SUBSTRING(@var2+@var1,CHARINDEX(@var1,@var2+@var1),LEN(@var2+@var1))
PRINT @var1
PRINT @var2
'Strength is Life'
'Weakness is Death'
- Swami...
July 19, 2010 at 11:51 pm
Hi,
I findout solution for interchange the variable without Temp variable.
Pls see below solution helpfull for you
DECLARE @Var1 varchar(max),@Var2 varchar(max)
SET @var1='Sethuraj'
SET @var2='Sahithya'
SELECT SUBSTRING(@var1+@var2,CHARINDEX(@var2,@var1+@var2),LEN(@var1+@var2))
SELECT SUBSTRING(@var2+@var1,CHARINDEX(@var1,@var2+@var1),LEN(@var2+@var1))
PRINT ...
July 19, 2010 at 11:49 pm
Hi Eralper,
Thanks for your replay. Now i got correct answer.
Today i learn some...
July 7, 2010 at 5:13 am
Hi,
The Dixie Flatline using Comman Table Experssions concept good and also this query return correct values. Another Person also gave the result (using inner join concept)...
July 7, 2010 at 4:43 am
Hi,
If u want first client name details then use rowcount option.
Rowcount keyword is inform to the sql server fetch the mensioned records from table.
Ex:
...
July 6, 2010 at 3:26 am
Hi,
/* This stored proc display list of tables and immediately followed by depends Stored Proc */
create proc DisplayTableDependentProc
as
begin
set nocount on
declare @objname as nvarchar(4000)
declare @objname1 as...
July 1, 2010 at 4:10 am
/* This Stored Procedure display list of tables and immediately followed by depends Stored Procedure */
create proc DisplayTableDependentProc
as
begin
set nocount on
declare @objname as nvarchar(4000)
declare @objname1 as...
July 1, 2010 at 4:01 am
Delete tblMMStanTestScores TS
Inner Join Student_data_main SD On SD.Permnum=TS.Permnum
Inner Join Teacher_Data_Main TD On TD.TeacherID=SD.TeacherID
Where TS.TestShortName = 'SFM1' and TS.InsertDate >= '11/04/04'
and TS.InsertDate < '11/05/04' and...
March 23, 2010 at 3:26 am
Viewing 10 posts - 1 through 10 (of 10 total)