Hi Jeff Moden,

This was a test run on about 88 rows as you can see in the source code posted above.

During production rows will grow in millions.

Hi Lynn Pettis,

On my laptop the old source code took 546ms whereas your new source code took 124ms only. Very good improvement.

Can you also explain to me if it's the...

Hi Lynn Pettis,

Following is the query I'm working on. The status field is summed up for '' in the query. But I need to have a separate column for each...

Hi Lynn Pettis,

I already understand that when data will grow the processing will slow down. My query really needs to be groomed well as I need to add more columns....

Hi Lynn Pettis,

Thanks for your help and sincere efforts. The view is working as desired.

I have gone through your Forum Etiquette and understood it well. My future postings will be...

Hi Luts,

Sorry for inconvenience.

I'm working on a project of timekeeping for my company. I have created SQL data tables and a view in SQL. There are particularly 2 tables used...

Hi Lutz,

As my nickname describes, I am very new to the forum and to SQL, so please do not get upset. Maybe I have to learn how to post a...

Hi Eirikur Eiriksson,

Thanks for your response.

Your suggestion to use ISNULL(NULLIF (STATUS, 'NULL'), '*') works fine when I run a query on a View where the View contain NULL values....

Hi Lutz,

Your query is the same as I originally posted. What may be confusing you is that in the data table, the last record contains null for WkdHrs and Status....

Hi Lutz,

I never mentioned that I'm getting any error.

My problem is that Null value of a varchar field should show a value of my choice. In this case I like...