.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

can some one rafactore this cte or provide alternative options , the cte is paramterized

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

CREATE TABLE [dbo].[Asic]
[ID] [int] IDENTITY(1,1) NOT NULL,
[NAme] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentID] [int] NULL,
[LevelID] [nchar])
CREATE TABLE [dbo].[Project](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ProjectName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AsicId] [int] NULL,
[Cost] [numeric](18, 0) NULL)
insert into dbo.asic(name,parentid,levelid) values('Education',NULL,1)

insert into dbo.asic(name,parentid,levelid) values('Construction of School',1,2)

insert into dbo.asic(name,parentid,levelid) values('Building of Rooms',2,3)

insert into dbo.asic(name,parentid,levelid) values('Private Sector',NULL,1)

insert into dbo.asic(name,parentid,levelid) values('Construction of Road',4,2)

insert into dbo.asic(name,parentid,levelid) values('pooring of stones',5,3)

insert into dbo.project(projectname,asicid,cost) values('Construction of building',3,100)
insert into dbo.project(projectname,asicid,cost) values('Pooring of rock by attaturk co',3,100)
insert into dbo.project(projectname,asicid,cost) values('Construction of building 2'

View Complete Post

More Related Resource Links

how to provide login options through facebook/google accounts


Hi all,

Thank you for advance.

We are developing matrimonial website using ASP.net 2.0 with C#.

we need to provide my site users login using facebook/google accounts. how can i do this.


What Do the Different Printer Options using Windows Mobile Pocket Pc

Select Printer Options:
bullet Printer: Select the printer to print to. Some printer selections work for a variety of printers, such as the "HP PCL" selection which prints to most Hewlett Packard DeskJet, LaserJet and compatible printers.
bullet Port: Select between Infrared, Bluetooth, Network printing and Serial (COM1-COM8). Most Windows CE devices only have Infrared and COM1 and need special attachments to use the other selections. USB printing and printing across an ActiveSync connection to a desktop printer is not supported.
NOTE: On many Pocket PC devices, you CANNOT use the serial and infrared ports at the same time. This means that if your device is connected to your desktop PC using the serial Sync cable, the Infrared port will not work. You must disconnect the serial connection to use Infrared printing.
bullet Color/Mono: Select Monochrome (Black & White) if your printer is not a color printer (or if you wish to print in mono). If your printer has color capabilities AND has a black ink capability, select "4-Color CMYK". If your printer cannot hold both color ink and black ink at the same time, select "3-Color CMY".
bullet Paper Size: Select paper size for use. You can choose "Custom" and then set special paper sizes in the "Custom Paper" Width and Height boxes. For printers that use "roll" paper, you can set a maximum paper height of 22 inches.

More Settings O

Replacement options for Membership


Hi everyone,
     I tried to use Microsoft's Membership option for signing up new users and authenticating them on subsequent pages, but it has not worked very well. The biggest issue has been with the REMEMBER ME function. With this checked, I am randomly logged out in the middle of some functions and some pages always show me as not authenticated, while others properly show me as authenticated. I built a site based on VB.
I was wondering what other people are using ro register users and monitor authentication and also if anyone has had better experiences with other solutions. 

Hi everyone,

     I tried to use Microsoft's Membership option for signing up new users and authenticating them on subsequent pages, but it has not worked very well. The biggest issue has been with the REMEMBER ME function. With this checked, I am randomly logged out in the middle of some functions and some pages always show me as not authenti

SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities


SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.

Jay Nathan

MSDN Magazine September 2005

Instrumentation: Powerful Instrumentation Options in .NET Let You Build Manageable Apps with Confide


As systems grow and become more heterogeneous, so their complexity increases. The more code you write, the more that can go wrong. The more that can go wrong, the more you need a good instrumentation policy. In this article, the author looks at the various technologies available in the .NET Framework, such as tracing, logging, WMI, EIF, which are designed to help you. He will also look at the pitfalls you should avoid and provide you with the fundamentals from both a technical and managerial perspective so that you can instrument your code effectively.

Jon Fancey

MSDN Magazine April 2004

ASP.NET: Nine Options for Managing Persistent User State in Your ASP.NET Application


ASP.NET provides many different ways to persist data between user requests. You can use the Application object, cookies, hidden fields, the Session or Cache objects, and lots of other methods. Deciding when to use each of these can sometimes be difficult. This article will introduce the aforementioned techniques and present some guidelines on when to use them. Although many of these techniques existed in classic ASP, best practices for when to use them have changed with the introduction of the .NET Framework. To persist data in ASP.NET, you'll have to adjust what you learned previously about handling state in ASP.

Steven Smith

MSDN Magazine April 2003

Resource File: Technical Support Options


Development can have its frustrating moments. How many times have you been in the middle of a project and encountered a problem you just couldn't solve alone? In order to help you through this, Microsoft provides quite a wide variety of support options from Web-based chats and newsgroups to paid premier customer support.

MSDN Magazine February 2003

SQL Server: Build Apps that Provide Real-Time Information and Customized Content Using SQL Server No


The adoption of wireless devices continues to spread unabated, and organizations are looking for new ways to get in touch with customers through these new mobile devices. In the past, unsuccessful ideas such as push technology were used to send targeted information to customers. Now, SQL Server Notification Services uses the SQL Server 2000 database engine and the .NET Framework to promote a new breed of notification applications that will allow relevant, consensual communications to be sent to any subscriber device.Here the author provides an architectural overview of the core features that make up SQL Server Notification Services. Along the way he discusses how they can be used for pushing Web content.

Mark Brown

MSDN Magazine November 2002

Passport Secure Sign-In: Provide Your Users with Secure Authentication Capabilities Using Microsoft


Secure sign-in, a new feature in version 2.0 of the .NET Passport single sign-in and profile service, is a functionality that will be especially useful for sites containing confidential information or anywhere security is a primary concern. Such sites include banks, medical sites, and so on. Secure sign-in is as safe as any SSL-based Web site login used today and provides a way to virtually eliminate vulnerability to replay and dictionary attacks.This article explains secure sign-in and demonstrates how you can implement this feature with very little effort in either ASP using the Passport.Manager COM object or in ASP.NET using the .NET class PassportIdentity.

Michael Kogotkov-Lisin

MSDN Magazine September 2002

Scripting SQL: VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to


Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of data from SQL Server 2000 and make the process of pushing data to your users a lot easier.

Alok Mehta and Daniel Williams

MSDN Magazine August 2002

Windows CE: eMbedded Visual Tools 3.0 Provide a Flexible and Robust Development Environment


This article provides an overview of writing applications for Windows CE 3.0. Unicode support in Windows CE, the kernel, memory management, the object store, and COM and DCOM are discussed. The article also covers the user interface, graphics, the Internet, and how Windows CE compares to the desktop in each of these areas. eMbedded Visual Tools 3.0 is discussed in depth. To help the reader decide which tools to use, development with Visual Basic, Win32, MFC, and ATL are explained. Text editor samples with this article have been developed with Visual Basic and Win32 so their implementations can be compared.

Paul Yao

MSDN Magazine January 2001

Windows CE 3.0: Enhanced Real-Time Features Provide Sophisticated Thread Handling


Windows CE is a small, configurable, feature-rich, real-time operating system. In Windows CE 3.0, the real-time support has been improved. This article looks at specific support for the creation of real-time systems and how it compares to the support in Windows for the desktop. The way interrupt handlers, processes, memory management, and synchronization work in Windows CE 3.0 is discussed. An extensive look at threads and thread priority, misconceptions surrounding them, and their impact on performance is included. Refinements to the Windows CE scheduler and support for nestable interrupts are also covered.

Paul Yao

MSDN Magazine November 2000

Windows 2000 Registry: Latest Features and APIs Provide the Power to Customize and Extend Your Apps


The Windows registry as it is recognized today first appeared in Windows 95. Its introduction simplified the storage of initialization information and made that data more secure. This article covers the history of the registry, the form it took in the early days, and its current incarnation in Windows 2000. Practical tips for managing data in the registry are outlined, along with descriptions of special keys, functions, and file types. Manipulation of the registry to customize both application behavior and certain features in Windows is discussed. Also covered are future directions of the registry, including the use of XML to store registry information in a hierarchical fashion.

Dino Esposito

MSDN Magazine November 2000

SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users


SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition. The article then concentrates on XML support, covering XML data retrieval and manipulation, queries, and HTTP access. It concludes with a discussion of performance improvements in SQL Server 2000.

Carl Nolan

MSDN Magazine August 2000

Web Security: Part 2: Introducing the Web Application Manager, Client Authentication Options, and Pr


This article, the second of two parts, continues coverage of Web security for Windows. It introduces the Web Application Manager in IIS that allows Web processes to be isolated, decreasing the security risk associated with running in a logon session. The article then picks up where Part One left off-it discusses authentication methods such as basic authentication, digest authentication, integrated Windows authentication, and anonymous logons, and the benefits and drawbacks of each.

Keith Brown

MSDN Magazine July 2000

so many data access options, what to use ?


I always have used Enterprise Library DAAB with stored procedures for data access with 4 seprate layers (presentation layer, custom types layer, business logic layer and data access layer).

My feeling is that this development approach wasts much time.

I have not worked with other ways of accessing data but sure there are many ways that save development time. While searching I read about these:

  1. Data Adapters they generate whole DAL with stored procedures
  2. Linq with different flavers
  3. Entity Framework
  4. Using data controls like SQLDataSource and Dynamic Data
  5. Other mappers, code generaters and utilities

So much options and my little knowledge, I am confused in making decision what development patern I should adopt considering that my development may be fast, extendable, re-usable and up to the standard. Also I want to go for a way in which my code libraries can be used with other technolgies like silverlight, mvc framework, services if I ever need to use.

Kindly guide me and help.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend