derekmcdonnell3 (10/21/2013)
when trying to export my test data, I am using the procedures from your signiture line, yet i am recieving some of the values as null, instead of the select statement, what could be causing this?
Maybe you have some NULL values in your data? It is kind of hard to know for sure. It doesn't have to be perfect, we can work with it a little bit to help you get it figured out. Or you can just manually modify the inserts if you need to. You don't need to create a lot of rows, just enough to demonstrate the scope of the situation which for your case might be as few as 5 - 10 rows or so.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/