Teradata Basic command on Date & Time

1.To select date
Select Date

2.To select time
Select time

3. To find the number of days between two date
select (date '2006-12-31'- date '2006-01-01' );

Teradata Query to display nth Record

To select nth row from Teradata database table,u can use the below specified query

SEL * FROM (
SELECT sum(1) over (rows unbounded preceding) As ROW_ID
,columns FROM databasename.tablename
) a WHERE ROW_ID = n ;

Note:
update the above query(marked as red) with ur database related info.

Thanks

Adding PageBreak in Excel using VBA

To add page Break by using Visualbasic for Application in Excel using following code

ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Cells(R,W)

where
R - Row & C-Column

the page break will be added to Activewindows selected sheet before the specific Cell

Cheers
Renugopal D

Programming

Programming

Sending Fax From ASP Page

Sending Fax From ASP Page

 

    this articles explain how to send fax from ASP page

u need faxcom.dll to creat an instance fro Faxserver.

 

 

1) First Create an intance for FaxServer   

        Set FaxServer = CreateObject("FaxServer.FaxServer")

 

2) Specify the Fax Machine
        FaxServer.Connect ("\\" & FaxMachine)

 

3)Select the input document you want to send as Fax
        Set FaxDoc = FaxServer.CreateDocument(FileName)

 

4) Specify Fax Number 
        FaxDoc.FaxNumber = FaxNumber

 

5) Send Fax
        FaxDoc.Send

 

6) Initialize to nothig
        Set FaxDoc = Nothing
        Set FaxServer = Nothing

 

 

References:   MSDN

Renugopal - Programming Task

Renugopal - Programming Task

Interface between C# and asm

Hi,
anyone can tell me , is there any way to call an subroutine in asm
from C# program..
if possible, can u expalin to me?
thanks
-Renugopal
http://renugopal.rediffblogs.com/

Programming Task: Studies on .Net

Programming Task: Studies on .Net

Studies on .Net

Planned to study 10 class each from Jan 01 2005