YTD Concept
Apr 15, 2008
Hi Friends,
Can anybody help in introducing the YTD Concept:
My Table[ Monthly_Highlights_tb ] schema should contain like below:
[Month] [Base_Amount] [YTD]
APR-07 1000.00 1500.00
APR-07 500.00 1500.00
MAY-07 2000.00 3500.00
jUN-07 5000.00 8500.00
WHEN I run the below query:
UPDATE t
SET t.ytd = (SELECT SUM(q.base_amount) FROM Monthly_Highlights_tb q WHERE q.[month] = t.[month] AND q.[month] <= t.[month])
FROM Monthly_Highlights_tb t
output is coming as:
[Month] [Base_Amount] [YTD]
APR-07 1000.00 1500.00
APR-07 500.00 1500.00
MAY-07 2000.00 2000.00
jUN-07 5000.00 5000.00
cAN anybody correct the query?
View 1 Replies
ADVERTISEMENT
Jul 13, 2006
What are some strategies in categorizing items?
View 4 Replies
View Related
May 15, 2008
Hi all,
Please let me know the details of the following.
1.What is Multi-Threading?
2. How it is useful to increase the Performance of a SQL query.( How it is useful
in Optimizing the query.
3. How we'll use MultiThread concept in Partitions and Using Processors.( For Eg.. If I want to use MAX threads=14 and 16 processors in this situation how we use PArtition concept and how it will improve the bufffer size of the CPU)
Thanks in advance
View 6 Replies
View Related
Oct 2, 2007
The distinction between Entity and Relationship is obvious to me. But I am confused by Table. Table describes Entity, Relationship, or both?
Thanks for any input.
View 9 Replies
View Related
Jul 20, 2005
Before going in to details i like to understand more about concept anddesign of this database. Most books go directly in to details.Please, can a current admistrator gife me information on this?Thanks in advance,Dick vd Spek email: Join Bytes!
View 1 Replies
View Related
May 8, 2004
Hi all,
What is the equivalent for Oracle's nested table concept in SQL Server ?
Is there anything like TABLE( ) function to select from nested table as in Oracle ?
Eg in Oracle :
SELECT t.* FROM TABLE(nested_table_datatype) t;
( like the above query used in Oracle PL/SQL and 'nested_table_datatype' is a table datatype created in Oracle using 'create type ...' syntax )
Please give the equivalent for above...
Thanks,
Sam
View 2 Replies
View Related
Jul 6, 2015
what is the concept of smart backup in sql ?
View 1 Replies
View Related
Feb 7, 2006
i would like to know where can i find information on the concept of SQL like Base Table , View Table and Search Table as now i am using VS.Net 2005 and SQL Server 2005 to write a addressbook program and i am just a newbie to Sql and c#... i wish to write my sql commands in c# side before passing it into sql and may i know how to do it?
View 20 Replies
View Related
Jun 6, 2007
The below code is ASP 1.0 to dynamically search a database and I want to use the same concept for a ASP.Net 2.0 solution. Do I do this in the code behind or on the aspx page and if on the aspx page what controls do I use for the array split? Basically where do I start. It took me a long time to get this old code working, I am hoping it is simpler in 2.0.
Thank you
OLD ASP 1.0 code to dynamically build a Sql Select statement for searching a database using one or more search words entered by user.
If Request.Querystring("kwdSearch") <> "" ThenDim kwdString, ArrKwdString, iCountiCount = 0 kwdString = Replace(Request.Querystring("kwdSearch"), "'", "''")ArrKwdString = Trim(kwdString)ArrKwdString = Split(kwdString, " ",-1,1) For iCount = 0 to UBound(ArrKwdString) If iCount < UBound(ArrKwdString) Then Criteria = Criteria & "tblLinkInfo.L_Keywords LIKE '%" & ArrKwdString(iCount) & "%' AND " Else Criteria = Criteria & "tblLinkInfo.L_Keywords LIKE '%" & ArrKwdString(iCount) & "%' " End ifNext RS.Open "SELECT * FROM tblLinkInfo Where (" & Criteria & ") AND L_Enabled = 1 ORDER BY " & SortBy & "L_Rank", CNN, 3 If RS.EOF Then If Rs.State Then RS.Close RS.Open "SELECT * FROM tblLinkInfo WHERE L_Description LIKE '%" & Replace(Request.Querystring("kwdSearch"),"''","'") & "%' AND L_Enabled = 1 ORDER BY " & SortBy & "L_Rank", CNN, 3 End If
RESULTS --- Display results with Repeater1.DataBind(); etc
Exit SubEnd If
View 3 Replies
View Related
Apr 2, 2004
Hi
I am involved in a product development and want to understand the current best practices from the conception to product rollout. I have few questions. Appreciate your help and suggestions
Our project in a nutshell: Our team has developed the apps. using GUI-Oracle Forms & DBMS-Oracle 8i/9i with weblogic, Corba, windows 2000 server environment. It’s meant for 1000s of users with million of data. We are trying to integrate additional services/capability - messaging (wireless, chat etc.). As per the initial plan we have a central database and users will be using a local footprint database. The deltas (the changes) will be synchronized with the central database at a frequency say daily or nightly... We are concerned that having the database at the users desktop could leave the door wide-open for others to take a look at our code/design...
Questions:
1. UML case tools-- What’s the best tool available in the market as we want to revisit the design phase and identify the things that have been missed out in the prototype-(which was developed by a third-party)?
So far we have used ERWIN to extract the data model...
2. How can we eliminate the need to have a local footprint database at the users desktop.?. Since there is a lots of data, retrieving the data via internet could be very slow for users? (hope this is the case!) That’s what led our team to think of having a local database at the users desktop. Someone suggested to use the data files or caching the data.. Appreciate if anyone shed some light on this.. Is there a better way to do it?
3. Client connectivity: What are the softwares needed at the users PC. Since we use Oracle Forms to develop the application, do we need to install the oracle clients at the users PCs? how to establish the connectivity from the Users PC to our server and to the database. IF we have to use the oracle client, does that require licenses for every User? What do we need to consider from the network connectivity stand point.
4. Application Rollout: how to package our finished product - application exe that is installable across wide array of environment. (we thought of install shield). how do we test it for accuracy etc.,
5. Database optimization: In addition to DBA help, is there any product or proceedures to ensure dataModel optimization, SQL query performance etc.,
Appreciate you sharing your valuable thoughts on this with us..
View 1 Replies
View Related
May 11, 2015
I tried samples of FileTable in SQL Server 2012 to store files in database. I have following questions.
1. When I right click on FileTable, and say Explore File Table Directory, I was taken to a directory. But if I search the same directory in my server/machine, the directory is not available.
2. Can I use some external server/disk as a directory for FileTable?
3. How easy is to use FileTables using .Net web applications?
View 2 Replies
View Related
Mar 6, 2008
In SQL Server 2000, when i install a client connection only, it also install the enterprise manager, just by adding/register new SQL server. there you can access all the tables. but in SQL Server 2005 how can I achieve that? Coz when i only install the client tool for SQL Server 2005 it only enables to connect to database, not accessing it freely and sql server management studio not included.
please help..
View 2 Replies
View Related
