Viewing 15 posts - 76 through 90 (of 1,113 total)
I would like to delete the securities from the table where as the returns are only NULL from 01/JAN/2000 to tilldate.
Note all the securties will have the returns from 01/JAN/2000.
November 23, 2011 at 6:59 am
yes.basically i just wanted to delete it from the table.
November 23, 2011 at 6:37 am
Code inside the function:
select @out_factor = factor from test_xrv
where id = @id and return_date = @out_date
return @out_return
Code inside the proc:
update dbo.test_xrv
set returns = dbo.FnMonthlyFactorsToReturns(id,return_date)
this will impact the performance. right?
It...
November 17, 2011 at 5:12 am
we just fetch the records from the table and show in the UI. We won't update the table.
my question is,
INSERT into PRIMARY with CLUSTERED
and
INSERT into PRIMARY ...
November 3, 2011 at 3:47 am
how to know what is the default collating sequence assigned for any database?
October 21, 2011 at 6:09 am
yes...
ORDER BY LEFT(Name,1), ASCII(Name) desc
--> works fine.
anbua97
AzhaguA65
balub98
BabuB66
BamaB66
chennaic99
ChitraC67
the second one is not giving the expected result set.
chennaic99
ChitraC67
balub98
BabuB66
BamaB66
anbua97
AzhaguA65
October 21, 2011 at 6:08 am
ORDER BY LEFT(Name,1) COLLATE SQL_Latin1_General_CP1_CS_AS DESC, Name
I still don't understand the working mechanism of these queries.
October 21, 2011 at 5:50 am
order by LEFT(name,1), ASCII(name) desc
How it works internally?
October 21, 2011 at 5:49 am
sure. my question is how should i get the expected result from a single column. If you look at the table structure, it has only one column. But the expected...
October 5, 2011 at 4:15 am
I would like to get the below output from the table.
"712232"|"FR"|"PCH1M)*1.000"||"12-31-71"|"06-30-11"|"M"|475| 1971 |N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|3.212
"712232"|"FR"|"PCH1M)*1.000"||"12-31-71"|"06-30-11"|"M"|475| 1972 |N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A
"712232"|"FR"|"PCH1M)*1.000"||"12-31-71"|"06-30-11"|"M"|475| 1973 |N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A
"712232"|"FR"|"PCH1M)*1.000"||"12-31-71"|"06-30-11"|"M"|475| 1974 |N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A
"712232"|"FR"|"PCH1M)*1.000"||"12-31-71"|"06-30-11"|"M"|475| 1975 |N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A
October 5, 2011 at 3:45 am
the important one is "dynamic column".. When we receive the same file next month we will have one more column in the file. i.e 31/oct/2011.
October 5, 2011 at 12:53 am
Jeff (one of my most valuable sql teacher) ,
Thanks a lot 🙂 I understand the concepts now.
I appreciate you for spending some time for me to give a detailed answer...
September 14, 2011 at 12:51 am
oops..i just read the Part 1 article. Anyway, I have gone through the part-2. I think it will fit for my requirement. I will try and get back here.
September 8, 2011 at 7:03 am
Viewing 15 posts - 76 through 90 (of 1,113 total)