you likely can create a unique filtered index to achieve that - with a "where <> 'D'"

create unique nonclustered index xxx on table yyy (username) where ...

and what is the issue?

Adding new columns to the table you should know how to do it.

converting cm to feed/inches you should apply the formulas to convert from one to...

then give us the code as it is supposed to run - and are you going to be hardcoding and changing the dates everytime it runs? you were already advised...

and what is the third server?

you are connecting to SERVER X (where you execute the code)  - from this one you do a open query to SRV1 - and that...

as you have been advised before do not do the dateadd on the column - instead convert the dates to a value compatible to the source t_stamp and use a...

spam - exact copy of DEC 2020 post - https://www.reddit.com/r/SQLServer/comments/k6t4ti/error_when_installing_sql_express_2012/

taking in consideration that the database is tiny doing as Jonathan mentioned is likely your best choice. - or alternatively just to an initial ETL from that main db onto...

have a look at https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2019?source=recommendations&view=sql-server-ver16 and https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver16

and https://www.mssqltips.com/sqlservertip/6686/edition-upgrade-and-downgrade-in-sql-server/ - but risky

note that it is better to use "COLLATE DATABASE_DEFAULT" than to hardcode a specific collation (unless there is a need to use a very specific collation) as that will allow...

I'm sure you have heard of

• Dynamic SQL
• Synonyms
• where field in (a,b,c,d)

All the above can help you with

• Build a query that fetches x number of rows only
• prevent...

based on your update you can still do multiples in one go - we don't have enough detail on how you get those formulas and how much they differ, neither...

can't you group /pre process updates so you have a lower number of transactions but each updating a higher number of records in a way that the records updated by...

you need to make sure you have SQL Server Integration Services installed for it to work.

LEFT JOIN pag5_users US2

ON TR.id_res_puser = US2.id

give it another alias

dup post

• This reply was modified 2 years, 10 months ago by frederico_fonseca.