Hi Yingchai,

It isn't clear at all what the rules of your transformation are. Why do you have 5 columns of output? What does * mean in column 2 of the...

lol, no worries. It's times like these that my favourite Douglas Adams quote comes to mind:

"He attacked everything in life with a mix of extraordinary genius and naive incompetence, and...

Never. I might not be a DBA, but I'm also not a *complete* idiot 😀

On the recovery model...

Hi Mazzz, yes, that's the other option. I just have about a day's worth of changes to apply to the backup. It isn't the end of the world, but is...

Hi GilaMonster,

Thanks for the reply. Recovery interval is SQL managed. My db is not very transactional, so checkpoints are infrequent.

I've checked using the LOP_BEGIN_CKPT,LOP_END_CKPT operations in the log...

Hi,

Another way is to use a table variable to limit your values:

declare @tb table (Vals int)

if @Par = 1

begin

insert @tb values (1),(2)...

etc

SELECT DAY FROM BIZ_CLOSING WHERE BIZ_ID = 802...

As I thought, but always good to get confirmation!

Thanks, Iain

Hi,

There are a number of apps that will automatically reformat SQL. A quick Google search should bring up plenty. I don't use one, so can't recommend one.

If you wanted to...

Hi Dan,

Chris is giving you good advice - sample data and DDL is the best way to get the best answer. This means providing a create table statement, then an...

rajg (11/9/2010)

---

There are two columns that can be used for ordering here - identity column and NextChangeDate. Sorry, I didnt mention this earlier. I didnt thought solution will require this...

Nice solution Sachin. I've run some comparative testing, which throws up some interesting results. Using the following test script, your solution runs quicker and has much lower read counts. But,...

Parthiban, I'm not sure your solution does what is required. As far as I can tell, the OP wants *all* records in a group to show as 'current' where the...

Edit: supplies solution to different problem *facepalm*

Hi Bhimraj,

Do you have any other fields in the table to do the grouping on? If not, it makes things trickier. If you could post a SQL statement to create...

Hi Jeffrey,

I can see one potential issue with your solution that you might want to consider, specifically, what happens when a group of prints for a customer sit either side...