Hi

I want count of binary tree levels..

example:

...

thank u

CREATE TABLE [dbo].[tbl_tree](

[node_id] [varchar](50) NOT NULL,

[parent_id] [varchar](50) NULL,

[node] [bit] NULL(False means Leftside and True means Rightside)

[JoinDate] Datetime

node_id...

Date Format : (dd/mm/yyyy)

My week is strat from saturday to friday

and im enter Fromdate - 1/12/2010 and Todate - 21/7/2010 that giving me output will be total week number

thank...

thank u so much LutzM ....

Date Format : (dd/mm/yyyy)

My week is strat from saturday to friday

and im enter Fromdate - 1/12/2010 and Todate - 21/7/2010 that giving me output will be total week number

thank...

Thank u guys...

and one more thing my week is strat from saturday to friday

and im enter today's date that giving me output will be like this:

(dd/mm/yyyy)

10/7/2010 - 16/7/2010

3/7/2010 -...

i got perfect one solution ..

thank you so much Peter Brinkhaus..

my problem is solved

paul pls try to understand me nd give me solution..

please try it nd give me proper solution...

thank u..

i want to talk to u..

is it possible..?

USE tempdb;

GO

IF OBJECT_ID(N'dbo.Tree', N'U')

IS NOT NULL

DROP TABLE dbo.Tree;

GO

-- Test...

USE tempdb;

GO

IF OBJECT_ID(N'dbo.Tree', N'U')

IS NOT NULL

DROP TABLE dbo.Tree;

GO

-- Test...

How to count left side nodes and right side nodes for managing a chain link(binary tree)application

in already u posted script in sql server 2008 but i want need in sql...