Show us with some actual code. I can't figure out...

How about posting the table DDL, sample data, and expected results. Please read the first article referenced in my signature block about asking for help. Follow the instruction...

After first fixing the missing comma after field_c in your code, you will get the following error:

Msg 207, Level 16, State 1, Line 11

Invalid column name 'rowNum'.

You can't use the...

John Paul (8/3/2009)

---

When the sub Store procedures (sp2) executes , it gives ouput of 6 columns ,

but it need to insert 4 Columns insert into #temp table ,...

JC (8/3/2009)

---

Hi Folks

I am trying to incorporate a CAST statment into my CASE statements and am not having any luck and do not know if that is even possible.

This is...

If there are more than 4 columns being returned by the second stored procedure to the first one, how is the first one supposed to know which four it needs?

You can also check out the DelimitedSplit function in this thread as well.

I agree, you really should look at normalizing the table. Barring that, however, there is a solution.

Please see the attached files. (posting from work is hit or miss,...

As a guess, you previously only had the Standard Edition loaded? Yes, you need the Profession Edition to debug stored procedures. I thought, however, they had brought back...

And then you a question like this one.

I think we are confused a bit. Could you explain what the problem you are have actually is? It would also help if you could provide the full...

Usually that is stored with the physical media. My copy of SQL Server 2005 Developer Edition has a sticker with the product key on the inside of the box...

Considering the wide varietyu of people on this site, I'd recommend that you save...

How many full and transaction log backup files you retain on disk really depends on your requirements for fulfilling restore requests and how much space you have for these files.

I...

William Plourde (8/3/2009)

---

Thanks for the reply but after reading it I was still confused (no surprise there), so I re-read my own post and I had a typo that probably...