The month is a parameter. It can be any date. The corresponding amount will be stored in the table.
I need the amount for the month (selected by user for example 11/30/2008),
diffrence between the amount for 11/30/2008 and 10/31/2008(amount month-amount previous month)
difference between the amount for 11/30/2008 and 09/30/2008 (amount month-amount of the quarter)
lavadan
Last Activity: Nov 19 '08, 09:35 PM
Joined: Nov 30 '07
Location:
-
Difference between rows in a table
Hello All,
Please help me with the SQL Query.
The table structure is:
EffectiveDate Amount
08/31/2008 400
09/30/2008 350
10/31/2008 200
11/30/2008 500
12/31/2008 100
I want to find the difference between any two rows provided the effective date.
For example: @Month=11/30/3008 then i want... -
Generating XML using VB Script
Hi Folks,
I am a newbie to VB Script. I need to generate the following XML document using VB Script. Can you please advise me on this? I can manage at least if I know the concept of generating XML using VB Script.
<?xml version='1.0"?>
<authors>
<author>
<firstname>john </firstname>
<lastname>norto n</lastname>
<publishingcomp any>westwind...Last edited by Killer42; Dec 18 '07, 08:46 AM. -
Can someone please guide loding tiff images into the sql database.Leave a comment:
-
Uploading Tiff Files into SQL Serevr 2005 Database
Hi Folks,
I am a newbie to SQL Server. Please help me with this.
I have some tiff files. I have to upload them into sql server. How do i do this.
I will be getting the tiff files in a hardware and from there i have to load these images into sql server.
Is it a good idea to load the entire images into the database or just the pointers to the images. My manager said that they want to load the images...
No activity results to display
Leave a comment: