One of the reasons I stopped using firefox. . .

There is...

If you did mean that all you want is the "root" and the last leaf, try this instead: -

BEGIN TRAN

CREATE TABLE #Modules ([ModuleId] INT, [ModuleName] VARCHAR(50) NOT NULL, [ParentId] INT...

Oh, misread the requirements.

CREATE TABLE #Modules ([ModuleId] INT, [ModuleName]...

rajeev_vandakar-782919 (1/5/2012)

---

Dear Cadavre,

Thank you for reply.

I tried this way to get member_id, member_name, age also in the same row, but failed.

I need to get all the...

CREATE TABLE #Modules ([ModuleId] INT, [ModuleName] VARCHAR(50) NOT NULL, [ParentId] INT NULL)

INSERT INTO #Modules

SELECT 1, 'Master', NULL

UNION ALL SELECT 2, 'List', 1

UNION ALL SELECT 3, 'EmployeeList', 2

UNION ALL SELECT 4,...

This article contains an explanation of the method used[/url].

BEGIN TRAN

--Sample data

CREATE TABLE employee_master (emp_id INT PRIMARY KEY, emp_name VARCHAR(4), dob DATETIME,

salary INT, join_date DATETIME)

INSERT INTO employee_master

SELECT 1, 'aaaa', '1976-03-01',...

I think you're looking at catch all queries.

Try this blog post by Gail[/url]

SQLKnowItAll (1/4/2012)

---

Thanks for that, but what I am really trying to get at in this post is not an actual delimited...

Jeff Moden wrote an excellent article on splitters here[/url].

That depends on how you're licensing SQL Server. Read the links I provided.

andyman123456 (1/4/2012)

---

on the server which i have used to deploy cube we have Standard Edition of sql server installed but we have another server but we also have another server...

What license do you have?

http://www.sqlservercentral.com/blogs/pearlknows/2011/01/24/microsoft-sql-server-licensing-for-dummies/%5B/url%5D

Having some difficulty understanding what you're after, so here's my best guess.

BEGIN TRAN

CREATE TABLE [dbo].[groupsAssociation](

[Id] [int] IDENTITY(1,1) NOT NULL,

...

Totally untested, I'm not at my desk any more.

using Microsoft.SqlServer.Server;

using System.Data.SqlTypes;

using System;

using System.IO;

namespace XMLWriter

{

public class XMLWriter

{

...

SQL Guy 1 (12/21/2011)

---

I was interviewed today, and one of the questions was : What configuration setting should you setup for new installation of SQL Server 2008?

I could...