As a bit of a sidebar, it's a real...

Yeah - I probably could have simplified the question to just "why do aggregate functions return NULL instead of no rows" ... but now that I think about it, my...

So this is a super-old thread to bump, but ironically, I'm working on SSIS packages again after several years, and this exact problem has been coming up again.

I realise now...

That is some very useful info Brian - thanks! The setup I'm trying to create is indeed very similar to yours. Unfortunately since the system is a bit of a...

@desnorton - I don't think sp_ExecuteSQL would actually diminish the danger. If the @WeatherFieldName variable had a semicolon in it, followed by a query - I believe it...

@desnorton - yeah that does seem like it should work better. Still will look rather ugly when dealing with hundreds of columns though.

@scottpletcher - I'll take...

• This reply was modified 4 years, 1 month ago by  kramaswamy.

The tables and fields are purely for demonstration purposes. The actual table definitions and field names are a bit more sensible (though not much more so).

As for your proposed solution...

Short answer? 'Cause that's the way the third-party designed their schema / software :/

The #FieldValues table has a whole pile of columns (String_00, String_01, String_02, etc...), while the #FieldDefinitions table...

Indeed. Sadly, I have no control over this. We're using a third-party application, and I'm retrofitting functionality onto it.

On the plus side, this is purely for auditing, so there shouldn't...

Alright. Good news. Using the aforementioned approach, I was able to identify the problematic records. Unfortunately, I wasn't able to manually update or delete those records, but after running CHECKTABLE...

Oh! I might have found something!!

I was reading through the original output, and I noticed that at the end there are several records of the following nature:

Msg 8929, Level 16,...

So I did a bit more digging - running DBCC PAGE('mytable', 1, 101273, 2) WITH TABLERESULTS works, and produces the DATA output rows, but since it's a VARBINARY column, I...

Will try the page check option and see if that gets me any more info.

Regarding restoring from a previous backup - to clarify, I do have a working...

Ah. Roger. Will take a look and report back. Thanks!

Hey Numpty,

The output I had pasted is the result of DBCC PAGE against that page. I'm not sure how to interpret that output though; is there something in there which...