create proc t @val varchar(10)

as

insert into...

If you need to keep the values within that row you'd have to do a pivot on the result set you've got when using Jeffs tally Table method.

Basically, there are...

Would you mind sharing your solution so others can benefit?

Would something like the following help?

DECLARE @xml xml

SET @xml='<root>

<column_name>

<node_a>value1</node_a>

<node_b>value2</node_b>

</column_name>

</root>'

SELECT

T.n.value('localname[1]', 'varchar(100)') AS Localname,

...

You might want to search for "split string function" on this site.

ritesh.kansara (10/8/2009)

---

to create the view, I've gone into the management studio and selected view - new view and copy and pasted the above SQL statement into it. I've saved...

Lynn Pettis (10/6/2009)

---

I'm taking a 2 week vacation starting next week, and I may or may not be around. We are driving to Ft Jackson, SC to see my...

Like I stated above:

If you insist on using your data structure you might want to search for "split string function" on this site. It'll help you for now but it's...

Ruaghain (10/7/2009)

---

As it stands it's envisaged that Admin users will be fairly knowledgeable with regards to database design (indeed, it's something that we demand), and obviously we will provide some...

Easiest thing would be to change your data to be normalized:

Instead of

tbl_house_fails

---------------

4 - 1,2,3 - 07/10/2009

insert the values as separate rows. It's a lot easier to work with...

4 -...

Duplicate post.

Please continue discussion here .

Allowing users to create their own tables is almost like open Pandoras box...

Once they can create a (simple) table the next requests most probably will be:

- design complex tables using...

You could try to force the output from SQL Server to U.S. standard format using CONVERT(CHAR(10),YourDateValue,101).

Edit: ... but this won't be a date format anymore. But it's possible that your...

The error message you're referring to will show you the line in your proc that causes the error (even when calling it from within a proc):

Msg 16924, Level 16, State...

Please read the link in my signature and post sample data as described.

Make sure to include your expected output together with what you've tried so far.

This will help us help...