AJAY HELP: 04/01/2011

Apr 30, 2011

Very Useful Links...

VERY USEFULL General Use
SrNo    Details URL Loop Falls
1   Details Overview Obout the DataWareHousing
   http://www.simple-talk.com/sql/learn-sql-server/sql-server-data-warehouse-cribsheet/

2   Details overview about SQL Server Integration Services
   http://www.microsoft.com/Sqlserver/2008/en/us/data-warehousing.aspx

3 Copying EXCEL Data into SQL Server 2005
http://www.builderau.com.au/program/sqlserver/soa/How-to-import-an-Excel-file-into-SQL-Server-2005-using-Integration-Services/0,339028455,339285948,00.htm Not Display how to avoid duplicate data copying condition

4 Copying Oracle Data into SQL Server 2005
http://www.codeproject.com/KB/database/ssis2005.aspx

5 Copying Text file data from folder to sql server 2005
http://www.codeproject.com/KB/database/SSIS_ConditionalSplit.aspx

6 Details Assignment On SSAS
http://www.accelebrate.com/sql_training/ssas_tutorial.htm

7 Details Assignment On SSIS
http://www.codeproject.com/KB/database/SSIS-Variable.aspx

8 Use Of Variable In SSIS Pkg
http://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/

9 Use Of Variable In SSIS Pkg
http://sqlfool.com/2009/08/getting-started-with-variables-in-ssis/

10 XML Configaration in SSIS Pkg
http://www.mssqltips.com/tip.asp?tip=1434

11 Create Text File Using SSIS
http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/

12 SSRS Tutorial with step by step excution
http://www.eggheadcafe.com/articles/20040823.asp

13 How To Use Variable In SSIS Pkg
http://consultingblogs.emc.com/jamiethomson/archive/2005/02/09/SSIS_3A00_-Writing-to-a-variable-from-a-script-task.aspx

14 How To Use Variable In SSIS Pkg
http://blog.shutupandcode.net/?p=332

15 Stored Procedure : Output Parameter
http://msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx

16 ExecuteSql procedure for OUTPUT Parameter
http://support.microsoft.com/kb/262499

17 Write Text File Through Query
http://www.mssqlcity.com/Articles/General/OleAutSP.htm

18 SQL Query Keyword And Its Use
http://www.1keydata.com/sql/sql-rank.html

19 A-Z Sql Server Keyword and internal function
http://ss64.com/sql/

20 An introduction about Sql server service broker
http://msdn.microsoft.com/en-us/library/ms345108(SQL.90).aspx#sqlsvcbr_topic1

21 SQL Server Send mail And SetUp profile
http://msdn.microsoft.com/en-us/library/aa155737(office.10).aspx

22 Step by Step To Connect SSAS To Excel
http://support.microsoft.com/kb/940167

23 Step By Step Intro of SAS
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a001310736.htm

24 WebSite For SQL Sever 2005
http://www.sql-server-performance.com/articles/biz/main.aspx

25 Creating Snapshot Of Database
http://www.codeproject.com/KB/aspnet/EnterpriseDataManagement.aspx

26 Adding Action To A Cube In SQL Server 2008
http://www.simple-talk.com/sql/reporting-services/adding-actions-to-a-cube-in-sql-server-analysis-services-2008/

27 XML Data Type and Query Type
http://www.codeguru.com/csharp/.net/net_data/sortinganditerating/article.php/c15329__1/Working-with-the-XML-Data-Type-of-SQL-Server.htm

28 The Tutorial of SSAS
http://www.exforsys.com/tutorials/msas.html

29 Complete SSAS Traning

http://www.databasejournal.com/article.php/1459531

Apr 23, 2011

Java script that extend textbox value By ".00"

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
   <title>Untitled Page</title>
</head>
<body>
   <input id="Text1" onchange="javascript:return addZero()" type="text" />
</body>
<script type="text/javascript" >
function addZero()
{

   var Text1=document.getElementById("Text1");
   var tempVal=Text1.value +".00";
   Text1.value=tempVal;
   alert(tempVal);
   return false;

}
</script>
</html>

---------------------------------------------------------------------------

Specialy for my friend Vinod Thakre.............. :)

Apr 30, 2011

Very Useful Links...

Apr 23, 2011

Java script that extend textbox value By ".00"

What is the use of n-tier architecture and 3-tier architecture?