you can do it - but not easy.

option 1 - Sharepoint Excel Services - https://docs.microsoft.com/en-us/sharepoint/dev/general-development/excel-services-overview 

option 2 - use OpenXML https://github.com/OfficeDev/Open-XML-SDK - C# code - better as an independent...

Hello everyone,

I am currently looking for a way to create Excel reports that include formulae (probably also Pivot tables and other stuff) from Reporting Services. Searching the web...

try

,convert(decimal(38, 2), case when f.HAI ='A' then (isnull(f.NUM,0)/f.DEN) *10000
                  ...

add required indexes - and see why the table does not have any at all - including a clustered index as that is normally, although not always, a good idea

I assume you are running that query and outputting onto a table so you can compare changes between runs - those are cumulative values since last instance startup - having...

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 4 years, 9 months ago by frederico_fonseca.
• This reply was modified 4 years, 9 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...