Viewing 15 posts - 196 through 210 (of 314 total)
nairsanthu1977 (10/11/2008)
Dear All,Is ther any in build function to convert numeric into words.?
I mean I want to display AMOUNT in WORDS.
Thanks,
Santhosh Nair.
Where do you want to...
October 15, 2008 at 4:19 am
Miss Qureshi (10/15/2008)
help me to select ROW_NUMBER in sql server 2000
Why do you want to have row_number?
Do you want to simply generate serial no for the recordset?
If so, do this...
October 15, 2008 at 4:09 am
SprocKing (10/14/2008)
rudy komacsar (10/14/2008)
... and also ...exec sp_help 'Tablename'
You can also select the table name and hit alt-F1 which is the shortcut for the code above.
Here are many possible methods
October 15, 2008 at 4:06 am
October 14, 2008 at 7:32 am
Also
EXEC sp_columns 'table_name'
October 14, 2008 at 7:25 am
October 14, 2008 at 7:23 am
jacob sebastian (10/6/2008)
October 7, 2008 at 9:10 am
October 7, 2008 at 9:01 am
October 6, 2008 at 2:11 am
Jeff Olson (10/2/2008)
Your pivot code is beautiful. I can't believe I'm going home today with my problem already solved. Thank you, Peter.
Which code are you referring to?
October 4, 2008 at 3:40 am
Philip Horan (10/2/2008)
Finally was my approach valid in constructing a query to use in a report?
Many Thanks,
Phil.
Update:
Jacob in answer to my own question...
October 4, 2008 at 3:33 am
venki_1276 (10/3/2008)
IS there any Possibility to use if on ctelike
with mycte(id,name,status)
as
(
select id,e_name,status from emp
)
if id=10
select * from mycte
it's getting error pls help
Only way is
with mycte(id,name,status)
as
(
select...
October 4, 2008 at 3:17 am
jacob sebastian (10/3/2008)
Other approaches
October 4, 2008 at 3:14 am
Another approach
declare @timeint int,
@dateint int;
set @dateint = 20081003;
set @timeint = 70004;
select
dateadd(hour,@timeint/10000%100,
(dateadd(minute,@timeint/100%100,
(dateadd(second,@timeint%100,ltrim(@dateint))))))
October 4, 2008 at 2:06 am
Viewing 15 posts - 196 through 210 (of 314 total)