Viewing 15 posts - 1,456 through 1,470 (of 59,061 total)
Hi Jeff,
Thanks for the reply.
It only deletes some of the data. Also, the query that isn't returning data only pulls from that subset that gets deleted.
Those rows are locked...
May 9, 2023 at 5:55 pm
I have table for employee activity with the following fields:
[Emp ID] , [Hire Date] , [Term Date] , [Mod Date] , [Old Div] , [New Div]
When an employee is...
May 9, 2023 at 5:52 pm
Hi Ratbak,
Thanks for your reply but order is the only my main problem.
--Expected o/p : Previours years following by current year data --Jan-2022,January-2022,Jan-2023,01-01-2023,Jan-2023,Jan-2023
Thanks
Bhanu
Since this seems new to you, read...
May 9, 2023 at 5:45 pm
By enabling cross-database ownership chaining or by designating a database as trusted by the instance using the TRUSTWORTHY attribute, a trust relationship between databases can be created. The sys....
May 9, 2023 at 5:20 pm
Are you saying that the DELETE in the hourly process deletes ALL of the data in the table or just some of the data?
May 9, 2023 at 5:09 pm
I can "azure you" that I can't answer your question because I've never used Azure before. 😀
I just want to say "Thank you" for the link to what looks like...
May 9, 2023 at 5:02 pm
Probably a few more times. Is there anything I should be concerned about or something else I can do to improve the process?
I was going to suggest that if...
May 9, 2023 at 4:45 pm
The other method is "WITH NORECOVERY". But, people need to find and read the documentation to know of either option before they tackle the two most important things a DBA...
May 9, 2023 at 4:39 pm
Whooo!!!! That's what I was looking for! Thank you so much! Very helpful!
I'm curious... how often will you need to do this from the same spreadsheet? (Obviously, after some...
May 8, 2023 at 11:38 pm
Hi
I have checked the logs and cannot find any alter database statements.
Think about that statement... Do you have any proof that the database was ever set to anything other...
May 8, 2023 at 1:17 pm
Well, I hope you both get a little refresh going. I'm feeling a bit more on it today after playing radio all day Saturday (Tour De Tulsa, bike rides...
May 8, 2023 at 1:08 pm
Hi All,
I have to highest two word in the columns. It should have the maximum two words combination. I have attached the excel for reference.
So which word pairs do...
May 8, 2023 at 4:37 am
I wonder why it is that there's always more pressure to "get it done" than there is to "get it done right".
Actually, I know why and the answer generally falls...
May 8, 2023 at 4:10 am
can we use the same method in databricks to create group, since for creating workspace local group it doesn't work as ' create group if not exists group_name ' ...
May 8, 2023 at 3:22 am
Had to give this one 5 stars... it should be more. I've been going through the same thing for quite a while now. Seems there's no end and I'm starting...
May 6, 2023 at 2:24 am
Viewing 15 posts - 1,456 through 1,470 (of 59,061 total)