Viewing 15 posts - 2,371 through 2,385 (of 59,066 total)
With the understanding that I'm not even sure how to spell "SSIS", have you checked it to see if the stored procedure contains a "Revert" statement?
all the SP's...
November 26, 2022 at 12:11 am
I don't know about CyberArk but I would hope that getting a Password for an SQL Service Account couldn't actually be done in such an easy fashion.
Cyberark if...
November 26, 2022 at 12:08 am
Found it, never mind
substring_index(TT.horas,':',1)*60+substring_index(TT.horas,':',-1),
Thanks
The SUBSTRING() stuff will make it slower than you need to. Here's a way to easily convert such "time strings" to Decimal hours.
...
November 25, 2022 at 11:26 pm
I don't know about CyberArk but I would hope that getting a Password for an SQL Service Account couldn't actually be done in such an easy fashion.
November 25, 2022 at 11:16 pm
With the understanding that I'm not even sure how to spell "SSIS", have you checked it to see if the stored procedure contains a "Revert" statement?
November 25, 2022 at 11:08 pm
I have to wonder why the Updates are being done by "Id" rather than by tenant and year.
November 25, 2022 at 11:06 pm
SELECT TOP 1 [Date]
FROM DimDate
WHERE CalendarYear= DATEPART(YEAR, getdate())
AND WeekdayLongName= 'Wednesday'
AND CalendarMonthNumber = 2
ORDER BY [Date] ASCsame as above for august month
That means that you have to...
November 25, 2022 at 10:43 pm
But, you DO have a UNIQUE set of column keys based on Entity, Attribute, and StartDate.
This looks suspiciously like a column based audit table or Slowly Changing Dimension format. Is...
November 25, 2022 at 3:34 am
I don't know your database but I'd take advantage of this as an opportunity to improve. I'd move my two to four largest fragmenting clustered indexes each to their own...
November 25, 2022 at 3:29 am
You can substitute this simple GREATEST with a CASE WHEN THEN END statement.
Since GREATEST isn't available in 2019, you should post that change to the code for the OP....
November 25, 2022 at 2:56 am
Thanks a lot!
For what?
November 25, 2022 at 1:15 am
Shifting gears back to the problem, is there a UNIQUE column in the table to identify individual rows with?
November 23, 2022 at 7:49 pm
Thank you both for replying. I apologize for my delayed response, I though I would get an email when follow-ups were posted.
You thought correctly except that functionality was broken...
November 23, 2022 at 7:40 pm
SELECT StudentId
FROM @student
GROUP BY ...
November 23, 2022 at 7:28 pm
@Raja mssql ,
This is meant as a friendly but serious suggestion... IF you even think that you're experiencing "SQL Injection" and YOU are asking these types of questions on a...
November 23, 2022 at 3:28 pm
Viewing 15 posts - 2,371 through 2,385 (of 59,066 total)