sorry, just curious : design of identity as PK & timestamp/datetime [convert(datetime, getdate(), 21)] as clustered key for those heavily-relied-on-date table, i think it will improve the perf on...

Michael Valentine Jones (11/25/2008)

In that case, let me jump in.

There are many opinions of this subject, but I am...

thanks.

you are right. I checked the execution plan and it does not differ much, thanks.

the one I could find is:

insert @SSNField (N, V_xml)

--select N, D from openxml(@iDoc, '/SerialNumber/S') with (N varchar(200) '@Descr', D varchar(800) 'text()')

select

tab.col.value('@Descr', 'varchar(100)'),

convert(varchar, @xml.query('/SerialNumber/S/text()'))

from

@xml.nodes('/SerialNumber/S') tab(col)

but I would...

Maybe, but the data can filtered with identity, should be unique enough.

select TOP 1 PARTNumber from AAA where [ID]=@PartID

using top 1 maybe...

Quatrei.X (9/1/2008)

Simple IF or case:

IF (...)

....

ELSE IF (...)

...

ELSE

....

I realy don't know if i named them right but could you tell me which one of these three examples do...

Hi Quatrei.X, thanks for your reply.

Sorry, maybe i should mention earlier. Actually inside the 'var5', it could be more that one output values returned. It makes "CASE" statement nearly impossible,...

I get 1469283328 for that. Sorry I do not quite understand what you are trying to explain. Can elaborate more?

hi Lowell, Carl Federl, thanks for your suggestion. Althought the actual case is like similar to what Lowell think of ( and could be only choice), but using dynamic...

anyone?

I intend to do something like this:

SELECT @FValue =

CASE @FieldName

WHEN 'var1'THEN (select Col1 from Table1)

WHEN 'var2'THEN (select Col2 from Table1)

WHEN 'var3'THEN (select Col3 from Table1)

WHEN 'var4'THEN (select Col4 from...

The original SP is something like this and need to be fine-tuned:

if @FieldName='var1'

select @FValue = Col1 from Table1

else if @FieldName = 'var2'

select @FValue = col1 from Table2

else if @FieldName =...

thanks for your explaination.