I am having a set of medication where I am trying to split the data and get the required output, I have the following medications

ARANESP 100MCG...

Why are you using a file to run a batch from?  Why not a stored procedure?

Also, any chance of you posting your SQLReIndex.sql file?  I ask because it appears to...

Heh... I smell another spammer on the horizon.

Hi Everyone

I have the below script which is very useful for single database usage. (Credit to the author)

How can I make this execute against all my user databases?

Thanks

            
August 18, 2021 at 3:20 pm
            
#3921416

            
            
                                                
        

Thanks, Ron.

Lordy.  Thanks for the feedback and good to "see" you again.

I also love the short story in your signature line.  The only problem with either books or "GIYF" is that...

Heh... Yeah... understood there.   I have the same feeling about FORMAT except that FORMAT is actually a performance issue on top of everything else.

Heads up, folks.  Norton Life Lock lit up big time on the following breach.  It looks pretty serious...

https://www.wired.com/story/t-mobile-hack-data-phishing/

I've heard of so many such limits, missing features, and other problems having to do with Azure, I have to seriously wonder two  things...

1. What the hell is Microsoft thinking?

...

Only with a bad data model.  Parts from the same invoice line could be shipped on different dates.  You...

I don't see the need for all that, this is much simpler:

SET @ytdfrDate = DATEFROMPARTS(YEAR(@frdate) - 
    CASE WHEN MONTH(@frdate) < 4 THEN...

I'm more confused...

unfortunately it is not something simple that T-SQL can handle. There are complicated logic to calculate stop corners according to time and direction of the bus etc, that is...

SSIS only has one execute task that  calls the web service.  I run today, there are 2000 routes to process, it runs about 8 hours on dev, and 10...

Ok... assuming the following requirements...

1. Given any DATETIME value, calculate the starting date of the Fiscal Year the value falls into.
2. The Fiscal year starts on the 1st of April.

In...