Hi,

you can use CASE, as it is done in the previous result column.

Regards,

Goce.

Hi,

I am afraid there is not a shortcut for this. Next time use user defined data types, so you will have to DROP and CREATE SPs again after the table...

Hi Freyre,

due to the NOT NULL constraint on all columns, you can use NULL values as indicators that corresponding values did not change. But, I would suggest you not to...

Hi,

if you have index on temp1.Sales (as you said), I think that further optimizations will not give some major execution time savings. I tested some modified versions of the SQL...

Hi Robin,

I solved a similar problem recently (dealing with matching colors), so it was much easier this time. I think that a recursion is not the best choice to handle...

Hi,

try this one, I hope it will help:

select
  bh.Tank_no, bh.Start_time, bh.End_time,
  ts.Output_Reading - te.Output_Reading as Trend_Tonne,
  eds.Output_Reading - ede.Output_Reading as External_Data_Tonne
from
  Batch_History as bh
  inner...

Hi jennifer,

If you placed the image data on some other file group (using the TEXTIMAGE_ON option of CREATE TABLE command) try this: check what is the most frequent size of...

Hi all,

I read somewhere the same question (i think it was on ORACLE discussion groups), and the answer was something like this: a constraint is a logical term (used in...

Hi Kay,

An interesting idea :-). Wasn't SQL invented for the purpose of hiding data retrieval details from the end users/programmers ? One of the most important SQL features was its...

Hi,

Try this one:

select

tmp.Appointment_Log_ID, a.Appointment_Date_Time, tmp.Data_Entry_Time_Stamp

from

(select

Appointment_Log_ID, max(Data_Entry_Time_Stamp) as Data_Entry_Time_Stamp

from

Appointment_Date_Time

group by

...

Hi,

what kind of backup is that: complete, transactional, differential maybe ? Are there any other backup jobs, targeting the same backup file ? What is the backup error message ?...

Hi Jim,

Now I see that the DISTINCT is obsolete in the SELECT, since the UNION will return a result set without the duplicate colors.

Regards,

Goce.

Hi Jim,

after reading your detailed explanation, I realized that all colors should be treated equally, without taking one colors as "base" ones and others as attached to them. Ok, let's...

Hi Jim,

I developped a similar UDF as Tal, but it does not use a recursion. I need to do some additional testing and I will post it tomorrow. It assumes several...

Hi Marshall,

try moving the assignment of @VTRight inside the @VTLeft's WHILE. Shouldn't the initialization of the loop counter be placed before each loop's WHILE ? As it is now, the...