let us take this example

 CREATE TABLE [dbo].[date_cal](  [callno] [int] NULL,  [sdate] [datetime] NULL,  [enddate] [datetime] NULL ) ON [PRIMARY]

 Insert some values into it

callno      sdate                   enddate ———– ———————– ———————– 1           2010-08-01 00:00:00.000 2010-08-04 00:00:00.000 2           2010-08-04 00:00:00.000 . . . → Read More: Max Date in SQL Server]]> It is not possible to find the maximum date in a given field by means of a direct function, but the objective can be performed in different way.

let us take this example

 CREATE TABLE [dbo].[date_cal](
 [callno] [int] NULL,
 [sdate] [datetime] NULL,
 [enddate] [datetime] NULL
) ON [PRIMARY]

 Insert some values into it

callno      sdate                   enddate
———– ———————– ———————–
1           2010-08-01 00:00:00.000 2010-08-04 00:00:00.000
2           2010-08-04 00:00:00.000 2010-08-07 00:00:00.000
2           2010-08-07 00:00:00.000 2010-08-10 00:00:00.000
1           2010-08-07 00:00:00.000 2010-08-09 00:00:00.000

 Here based on the maximum date of the enddate column I need to retrieve the value.

For this I am writing the following query

SELECT     TOP 1 *  FROM  date_Cal  where callno = 2 ORDER BY enddate DESC

When this query is executed, we will be getting the following result.

 callno      sdate                   enddate
———– ———————– ———————–
2           2010-08-07 00:00:00.000 2010-08-10 00:00:00.000

When we run the query for callno = 2 the maximum value of thd date column will result as follows

callno      sdate                   enddate
———– ———————– ———————–
2           2010-08-07 00:00:00.000 2010-08-10 00:00:00.000

If there is any other solution, please share me.

SELECT          u.name + ‘.’ + t.name AS [table],              td.value AS [table_desc],                  c.name AS [column], .value AS [column_desc]  FROM            sysobjects t  INNER JOIN  sysusers u      ON          u.uid = t.uid  LEFT OUTER JOIN sys.extended_properties td    . . . → Read More: SQL Server: Extract Table description, fields and their data types]]> Example 1

SELECT          u.name + ‘.’ + t.name AS [table], 
            td.value AS [table_desc], 
                c.name AS [column], .value AS [column_desc] 
FROM            sysobjects t 
INNER JOIN  sysusers u 
    ON          u.uid = t.uid 
LEFT OUTER JOIN sys.extended_properties td 
    ON          td.major_id = t.id 
    AND         td.minor_id = 0 
    AND         td.name = ‘MS_Description’ 
INNER JOIN  syscolumns c 
    ON          c.id = t.id 
LEFT OUTER JOIN sys.extended_properties cd 
    ON          cd.major_id = c.id 
    AND         cd.minor_id = c.colid 
    AND         cd.name = ‘MS_Description’ 
WHERE t.type = ‘u’ 
ORDER BY    t.name, c.colorder 

Example 2

                cd

Have this as the base :-

select * from INFORMATION_SCHEMA.TABLES 
select * from INFORMATION_SCHEMA.COLUMNS 

select       TableName = tbl.table_schema + ‘.’ + tbl.table_name,  
    TableDescription = prop.value, 
    ColumnName = col.column_name,  
    ColumnDataType = col.data_type 
FROM information_schema.tables tbl 
INNER JOIN information_schema.columns col  
    ON col.table_name = tbl.table_name 
LEFT JOIN sys.extended_properties prop  
    ON prop.major_id = object_id(tbl.table_schema + ‘.’ + tbl.table_name)  
    AND prop.minor_id = 0 
    AND prop.name = ‘MS_Description’  
WHERE tbl.table_type = ‘base table’ 

Example 3

select   TABLE_CATALOG, 
    TABLE_SCHEMA,        
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE, 
    CHARACTER_MAXIMUM_LENGTH 
from  
information_schema.columns 

First invoke the remove operation using control panel and choose add or remove program.

In the option choose change / remove operation then choose remove functionality and choose the shared components option here choose managment studio and remove . . . → Read More: Uninstall Management studio in SQL Server 2008]]> When you are planning to remove management studio from existing installation.

First invoke the remove operation using control panel and choose add or remove program.

In the option choose change / remove operation then choose remove functionality and choose the shared components option here choose managment studio and remove the functionality

Your .NET applications are important to your company’s profitability. Therefore, protection of these applications is crucial. To this end, any .NET program where the source code is not bundled with . . . → Read More: Dotfuscator Community Edition 3.0]]> I started trying the installation of Visual Studio 2008, I choosed custom option where I saw a option Dotfuscator Community Edition 3.0. I started searching the net.

Your .NET applications are important to your company’s profitability. Therefore, protection of these applications is crucial. To this end, any .NET program where the source code is not bundled with the application should be protected with Dotfuscator. Ignoring application protection increases the risk to your organization in the form of intellectual property theft, hacking, and piracy.

PreEmptive Solutions’ Dotfuscator is the leading .NET Obfuscator, Compactor and Watermarker that helps protect programs against reverse engineering while making them smaller and more efficient. Dotfuscator Professional Edition is designed to stop even the best of decompilers from producing useful output. It provides comprehensive and efficient .NET code development and deployment.

If IIS is not installed in the machine, first install xampp, then do the process of iis installation.

if IIS is installed, uninstall it and then install xampp.

please make sure to change the port of xampp in C:\xampp\apache\conf\httpd.conf as

Listen 85

IIS will work normally in port 80

xampp . . . → Read More: XAMPP and IIS in Windows XP]]> If you are planning to work both XAMPP and IIS in a same machine.

If IIS is not installed in the machine, first install xampp, then do the process of iis installation.

if IIS is installed, uninstall it and then install xampp.

please make sure to change the port of xampp in C:\xampp\apache\conf\httpd.conf as

Listen 85

IIS will work normally in port 80

xampp will be accessed from port 85

We can acheive the requirement by two simple usages,

In from field type the addresses in the following manner.

1. ram@rajaramsystem.com OR kumar@rajaramsytem.com

2. {ram@rajaramsystem.com kumar@rajaramsystem.com}

If there is any options share . . . → Read More: Google - One Filter Multiple email addressess]]> Today I thought of adding multiple email addresses for one filter in Google.

We can acheive the requirement by two simple usages,

In from field type the addresses in the following manner.

1. ram@rajaramsystem.com OR kumar@rajaramsytem.com

2. {ram@rajaramsystem.com kumar@rajaramsystem.com}

If there is any options share your ideas.

HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java. HSQLDB is . . . → Read More: Instant Messaging Using Openfire]]> Openfire is a instant messaging software - it is rich with lot of features. Openfire is adaptable to different to different user management scenerio.  Openfire uses a embedded database engine named HSQLDB. I want to share some words about HSQLDB.

HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java. HSQLDB is based on the discontinued Hypersonic SQL Project.[1].

HSQLDB is available under a BSD license.

It has a JDBC driver and supports a large subset of SQL-92, SQL-99, and SQL:2003 standards.[2] It offers a fast,[3] small (less than 100 kilobytes in one version, around 600 kilobytes in the standard version) database engine which offers both in-memory and disk-based tables. Embedded and server modes are available.

Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets), and a number of demonstration examples. It can run on Java runtimes from version 1.1 upwards, including free Java runtimes such as Kaffe.

HSQLDB is currently being used as a database and persistence engine in many open source software projects, such as OpenOffice.org Base and the Standalone Roller Demo,[4] as well as in commercial products, such as Mathematica or InstallAnywhere (starting with version 8.0).

The automation of a business process, in whole or part, during which documents, information or tasks are passed from one participant to another for action, according to a set of procedural rules

Computer application contains a number of different ‘tasks’, ‘transactions’, ‘programs’ or ‘modules’, each of which performs a particular function. Sometimes the processing of . . . → Read More: Windows WorkFlow Foundation.]]> Work Flow System

The automation of a business process, in whole or part, during which documents, information or tasks are passed from one participant to another for action, according to a set of procedural rules

Computer application contains a number of different ‘tasks’, ‘transactions’, ‘programs’ or ‘modules’, each of which performs a particular function. Sometimes the processing of one particular task is supposed to be followed by one or more other tasks in order to complete some higher process. For example, the task ‘Take Customer Order’ may have to be followed by ‘Get the amount from Customer’, ‘Pack Order’ and ‘Ship Order’. This higher process may have a name such as ‘Order Fulfillment’, but as you can see it cannot be handled by a single task and has to be broken down into its component parts.

Without a workflow system the processing of the component parts has to be handled manually, which is where mistakes can occur. Forgetting to get the amount from the customer or ship the order is not a good way to run a business.

With a Workflow system it is possible to define ‘Order Fulfillment’ as a workflow process, with ‘Get the amount from the Customer’, ‘Pack Order’ and ‘Ship Order’ as components of that process. When an instance (or ‘case’) of the workflow process is created the workflow engine will then take responsibility for dealing with each component in turn. These components may be executed automatically, or they may be directed to appear in someone’s inbox.

There can be two basic types of workflow:

• Activity based - means that the processes, the workflows, are made of activities to be completed in order to get something done.
• Entity based - means that the focus is set on a given document and the states it has to go through in order to be completed.

Windows Workflow Foundation (WF) is mainly used in supporting workflow management.

WF was first released with the .NET Framework 3.0 in 2006, then updated in the .NET Framework 3.5. These first two versions were useful, especially for independent software vendors (ISVs), but they haven’t become mainstream technologies for enterprise developers. With the version of WF that’s part of the .NET Framework 4, its creators aim to change this. A major goal of this latest release is to make WF a standard part of the programming toolkit for all .NET developers.

Reference for better understanding on the subject

http://www.tonymarston.net

http://msdn.microsoft.com/en-us/library/dd851337.aspx