If I am not mistaken the Primary key Index or clustered is physical storage, so yes it will rebuild-Specifying a low fill factor on pages could help a bit.

On a...

Hi Chris,

If your table A only has the FK1-FK7 columns and Table b has the PKey and definition, than that is the only way.If not, please post your table structures.

Apart...

Copying and pasting your original post won't assist you,

Your previuos reply was

when i run by selecting NULL for the @level parameter and SOME color value for the @color dataset...

Hi Zombi,

Does your data contain NULL?

or do you want to retreive everything when NULL is passed?

I'm not understanding your reqiurement

Got it thanks,

there is an option for last day of every month:)

This won’t work if you have more than 1 user submitting form data simultaneously.

Is SSIS available to you?

i came accros this before as well and not too sure on the resolution 🙂

as an interim solution try

set dateformat ymd before your select statement

a try... catch block should do the trick to ensure the trigger completes

try using EXCEPT

select 5 columns from table A

except

select 5 columns from table B

Instead of enabling the user to select his ID can you not let it be an auto increment from the table itself?

something slighty different

select cast(tarief as decimal(10,2))/100

post some sample data and table structures

sorry had a spell check issue...

try now

declare @i int

set @i=1234567890

select left(@i,len(@i)-2)+'.'+right(@i,2)

Howdy,

try this:

declare @i int

set @i=1234567890

select left(@i,len(@i-2))+'.'+right(@i,2)