Hello,

Please try the following script

Within the script, you can find the source of the split function at Split String using XML - How to Convert or Split a Delimited String...

Here is my alternative solution according to my understanding

select * from tbl_tree

declare @nodeid int = 3

;with cte as (

select

node_id, parentid, node,

null lnode,

null rnode

from tbl_tree where node_id =...

Hi,

Are you sure your samples are correct

I can not see that numbers of items on the left or right of node 3 or node 1

Hello,

Easiest solution is using DATEPART function

select DATEPART(WEEK,GETDATE())

If that is not useful for your requirements, you can also think of to create date table in SQL Server

Congratulations all,

So right after 70-432 and MCTS, you will be on track for 70-450 to get your MCITP DBA 2008 certification.

I had ttoo passed 70-432 when it was in beta...

Hi Jeff,

Actually the sample data provided has more than one record for RAM and for Maths

It is not explicitly stated but, I chosed using MAX perhaps and AVG could be...

Shared data sources enables report developers to use a datasource that is already created and exists within the related reporting services project.

This makes it easier to maintain the reports.

For example...

Hi Naveen,

You can use both below queries

select

e.equipmentnumber,

MAX(c.createdate) createdate

from equipment e

inner join configurations c on e.rifgeneratedid=c.rifgeneratedid

where

c.createdate > '01/01/2010' and

c.createdate < '07/14/2010'

group by e.equipmentnumber

;WITH CTE AS (

select

e.equipmentnumber,

c.createdate,

rn = ROW_NUMBER()...

Hello dheer,

Please thy the following select query

select

name,

MAX(dob), MAX(maths), MAX(science), MAX(chemisty), MAX(physics),

MAX(maths) + MAX(science) + MAX(chemisty) + MAX(physics)

from lessons

group by name

I hope that helps you

70-433 is actually a development exam. If you work frequently on the tsql enhancements introduced with SQL2005 that experience will be helpful for success in 70-433

You can see my exam...

I have a very similar solution to Mark's.

select

row.value('@id', 'varchar(100)') as id,

row.value('@type', 'varchar(100)') as type,

row.query('.')

from @xml.nodes('/U/N') as xmltable(row)

where

row.value('@type', 'varchar(100)') = 'good'

I hope that helps,

It might be permission issues perhaps.

Did you tried connecting sql server using php application uses for db connection and call cmdshell?

One other reason may be that the server is not...

Hi Sethuraj,

You can try using T-SQL DENSE_RANK() function instead of using ROW_NUMBER function.

Dense Rank will take care of rows having same value

Hi,

SQL Server Database Mail can be used for such a task using DML triggers. But will not suggest this way too.

Actually the dbmail just queues the mail requests and then...

Hi,

Here is two articles that will help you to find and delete duplicate records in a sql table.

How to delete duplicate records or rows among identical rows in a table...