"blank line in subreport" is just a statement - what's the problem? Unless you provide more detail you are unlikely to get any responses. Remember that we can't see what...

Generally most prospective employers will give feedback after an interview. Why not ask for feedback and mention that you were confused by the question as you've never heard of anyone...

Could you clarify why you say you have to use UNION?

This isn't the first time the OP has posted requests for help on different forums The same post is on MSDocs: https://docs.microsoft.com/en-us/answers/questions/444629/how-to-get-gpnsignature-that-first-part-on-it-star.html. The OP in that case is https://docs.microsoft.com/answers/users/3345424/ahmedsalah-1628.html. I'd...

Options:

1. Spammer
2. Person with too much time on their hands
3. 1 and 2

Is there anything stopping you trying it out for yourself?

I suspect the reason you haven't had a response is that your original request is very difficult to follow. I'd suggest you look at what you have written and break...

This sounds a little like a LMGTFY question: https://www.sqlshack.com/magic-tables-in-sql-server. More seriously, it's not possible for you to anticipate every question an employer will ask you. Whilst I don't pretend...

It's a little difficult to know whether this would work form the limited sample shown, but could you create a table with the test name and one line per selection...

Firstly, It may be better to start a new thread - adding to a ten-year-old one with different code may not be the best way of getting a response

The short...

As this is a SQL server forum, and as the subject line indicates you are using an Informix database, you may have more luck on an Informix users forum, for...

You may find that most people will be reluctant to open an Excel file from an unknown source. Could you take a look at Jeff Modem's excellent article on how...

Instead of removing "END AS HCPCS_CPT", just remove "AS HCPCS_CPT" - you might want to read up on the syntax of a CASE.. WHEN statement (it always ends with an...

Is there a specific reason you want to have individual users accessing the database? If you are developing a .NET application would it be better to have one application login...

The problem is that (as Thom has said previously) you are trying to convert the date to a text string and then returning all records where the converted date (i.e....