I too have run this and get an output that appears correct. So I do not understand the problem. Also from your original post ... please explain "....when the...

hi See attachment

Note the underscore in the sellect column list, and that the result set is ordered by the original Column Names, which is the same as the columns on...

rameshduraikannu (10/30/2009)

---

hai friends

i want to display the data like the below structures

for eg:

customername grade height width

sqlserver ...

Sorry, being fast on the draw.....

small modifications required is

When using dataLength() on unicode, devide by two to get the number of Characters

this seems to work perfectly if one remembers that for unicode

1 character = 2bytes

and datalength counts bytes

so every two bytes = 1 character

Firstly, table definitions, with test dat and required results would help

secondly: check this:

http://www.sqlservercentral.com/Forums/Topic612568-203-8.aspx#bm625111

there is a attachment somewhere near the bottom. it was designed to create...

The question is how do systematically build up the list of files to delete. If you can do this, then you would create a variable that contains the list...

Completely wild guess at what you are trying to do

Select

Name =

case T3.TableName

When 'T1' then t1.name

When 't2' Then t2.name

End

From t3

inner join t1 on t1.id = t3.tableId

Inner join t2 on t2.id...

I can't say that I like this solution but it is an option to consider

You write the check constraint CHECK ( dbo.udfCheckInput(col) = 1)

The user function checks...

What is the Column Definition?

You will need to post a Source Table Definition and some test data in order to understand the problem

Maybe you should check the script I attached in an earlier response on this thread (at the end of page 8.....

Based on your example data and previous post....

a case statement...

Hi....I decided last night too do a bit of a rewrite of the Procedure for 2005. It should demonostrate that you can get very creative with these scripts. ...

Hi. Sorry For only responding now. Between Work stress and trying to get the holiday mood I have not responded to this thread.

Yes I will share, but need to...

Agreed not RBAR, but RBR LOL:D