out of the normal but in a particular application from one of my clients sequences always started at 1000.

And on a similar situation, multi-tenant, each tenant would start at 1.000.000...

Hi,

Had not seen it when I hit the send button.

your code works for most - not all cases.

see these two examples

 create view dbo.myview5
/* view name dbo.myview
--*/as
...

you didn't specify where you will be getting the text for the views - that may also change how you process it.

but take the following examples in consideration - they...

darn forum security - not even allowing to add a file with .7z if not a proper zip file

• This reply was modified 5 years, 7 months ago by frederico_fonseca.
• This reply was modified 5 years, 7 months ago by frederico_fonseca.

error is quite clear

Error converting data type nvarchar to datetime.

what you need to do is to look at which field is being converted from a nvarchar/varchar to...

Probably not. The STRING_SPLIT function is relatively crippled for those...

those 2.5 mins are on your pc - how long does it take to run on the server?

and on top of what Jeffrey said - set the packet size to...

I do not understand why you having issues with the link you provided. It is quite clear.

SSIS Package (call it myfile.DTSX) - you create a connection manager to your database...

one possible way.

update a
    set rupdate = 1
output deleted.*
into table_b
from dbo.TABLe_A a
where convert(date,DTime) = CONVERT(date, getdate())
    and cast(DTime as time) >...

just wonder why people still insist in using cursors/while loops when a better solution was given.

for those seeing this thread and thinking its a good way to do- this approach...

using the ONLINE=ON is most likely what is killing the index creation.

but all other comments still valid.

from what I can see the output of that query will filter out the cases where either accountid or alternatecode is null - why are you stating it is not...

to load the full file without errors you basically define a table with a single column and you load the file onto it without specifying field delimiters - only record...

this may give you a hint https://www.mssqltips.com/sqlservertip/3456/getting-sql-server-metadata-with-python/

it would seem that one of your applications does like to get info about tables and its columns a lot - I've seen this...

this looks like code converted from Oracle - is your database/tables really setup to be case sensitive that you require to use UPPER for every single column?

there is a way...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.