Its a system stored proc, not one of ours, and points to system tables, which are not ours.  I'm slightly hesitant about changing the internals of SQL Server system objects...

One rather weird one that I have found now that I am working from home is that every morning when I get up, I go and open all the blinds...

Figured it out - need to pull out the "B" CTE to a temp table: -

DECLARE @hdoc INT;
EXEC sp_xml_preparedocument @hdoc OUTPUT,
      ...

I currently use geoLocation, along with geoCountry, geoState, geoSuburb and geoTimezone as my five fixed-position geographic tables.  I also have geoCoordinates for auditing movement.

Does this do roughly what you are looking for?

CREATE TABLE #sale
    (
        id INT IDENTITY PRIMARY KEY,
...

Lots of us can help you, but you need to help us help you. What have you completed so far? Why isn't what you've done working, or where have...

• This reply was modified 4 years, 8 months ago by  michael.cole 47030.
• This reply was modified 4 years, 8 months ago by  michael.cole 47030.

In which case you would need to add another column, possibly simply an identity column to provide that order.

Then, you would select all values from each column individually, in order,...

I have come up with the perfect solution for you.  It is really quick, and doesn't use case statements, and does everything you want.

Unfortunately, I am not allowed to share...

Thanks, implemented and works fine.

Given that Christianity covers quite...

I am really CONFUSSED why do i have to create a table i already have a table called [job Info$] with a column called [Time Reported] all i want...