Viewing 15 posts - 106 through 120 (of 130 total)
ok.got solve,but i have another query.
i need to create 1 temp table
and i need to add whatever i got from temp2 and from account function.
so in temp2 i have column...
April 20, 2012 at 10:47 am
no.
account(@p1) is udf and i need to get value i1 from udf.
how can i join this ,it doesn have any common column
April 20, 2012 at 8:27 am
create table #temp2(account int,
MTD float,
ytd float)
its account in temp1 that is same in temp2
if any value is null for mtd or ytd it will fill
April 20, 2012 at 7:09 am
here you go
create table #temp1(account int,
MTD float,
ytd float)
insert into #temp1 values(
1001 ,23.45, 34.32,
1003 ,34.56, 43.2,
1003 null, 32.21,
1003 56.76 null)
temp#1
1001 ,23.45, 34.32,
1003 ,34.56, 43.2,
1003 null, ...
April 20, 2012 at 6:24 am
Lynn, i have seen your post to every thread,instead of helping , you just posting your stranded one to everybody.
thats so annoying . and i dont except any response from...
April 19, 2012 at 9:31 pm
i have given all the information here ,nothing is left
April 19, 2012 at 8:25 pm
in temp1 mtd field ,some of the values r null
if this is null
i need to call another sp and get value
April 19, 2012 at 2:02 pm
give me sample example,how to get rid
April 19, 2012 at 1:54 pm
i ma getting values in all three variables from temp1
April 19, 2012 at 1:52 pm
ok.
this is my complete code
declare @Portfolio nvarchar(32)
declare @mtd2 float
DECLARE @qtd float
declare @maxdate datetime
select @maxdate = ...
April 19, 2012 at 1:29 pm
thats what i did right now,i removed variavel i declare inside cursor,sill not working
my question can understand by whatever i have posted
April 19, 2012 at 1:10 pm
this is my ddl
create table #temp2(account nvarchar(32),
MTDTWR float,
QTDTWR FLOAT,
YTDTWR FLOAT)
this is data i am getting
accountMTDTWRQTDTWRYTDTWR
case-0.8755148870.5430860920.784486036
circle-0.8755148870.5430860920.784486036
hargrov-0.8755148870.5430860920.784486036
hurwitz-0.8755148870.5430860920.784486036
usbal1-0.8755148870.5430860920.784486036
the data should be unique in each field,what else u need...
April 19, 2012 at 12:46 pm
this code should work ,but its not ,
its getting me same row in all the rows and repeating last row 2 times.
declare @P1 nvarchar(32)
declare @mtd2 float
DECLARE @qtd float
declare @ytd float
declare...
April 19, 2012 at 12:37 pm
Viewing 15 posts - 106 through 120 (of 130 total)