Thank you for all your help. Problem has been resolved.

Hello,

I am in agreement with you that the problem resides in the select statement. I am unsure on where to include the actual table Havbed with the code you provide...

Hello,

First I would like to thank you for you assistance.

You are correct on the following,

- For placements 1, 2, 5, 7 I want to show the count number (any...

Thank you For you reply, Code worked great except for the following problem:

Code you provided produced the following results,

,18,22,,,12,,1,,,

In which I was just missing one comma at the end. There...

Kingston,

Would you be able to help me with the following code utilizing SQL SERVER STUFF function.

I need to acquire the total number of beds in a vertically placement like...

Thank you for your reply.

Hello,

I was wondering if you every received a resolution to this problem, our site is experiencing the same issue. We have taken all the same steps as you have...

Hello,

Can I receive a copy of the VMWare Server\SQL Server 2008 install.

Currently our site has a clustered 2008 R2 sql server instal built by a third party vendor and...

ADI,

Do you know how I can use BCp to create a tab delimited text file.

I am attempting to run the following and it is not working.

Bcp "EXEC usp_nh_oxford"...

Tahnk you Jack that worked.

Hello,

I have followed the advise on the post for the following and have place a 'tab' in the query_result_seperator and the csv file is still opening incorrectly.

I would just...

Thank you for your reply. I will try it out.

Would you happen to know if there are performance issues with using Coalesce. I read an article on how...

Hello,

Would you happen to have any suggestions on how to do the opposite, take a result set and create one line csv file. Example 20 lines of data...

Wayne,

I create a stored procedure and I am executing that stored procedure via job step on the Job Agent creating a text file to an output file location on the...