Forum Replies Created
Viewing 15 posts - 16 through 30 (of 54 total)
-
RE: Compare previous and next rows to derive output
drew.allen - Friday, January 19, 2018 8:48 AMRE: Compare previous and next rows to derive output
You can try below lines of code. I hope that it will work.
;WITH CTE_Main AS (SELECT
Customer,
TranID,
TranDate,
Reason,
TranStatus,
LEAD(Reason) OVER (partition...RE: TEMPDB data gets full and when i check there are no long running transactions
For more detail, you can go throught following link:
https://technet.microsoft.com/en-us/library/ms176029(v=sql.105).aspxRE: Should I use Insert Trigger or not?
Thanks to all for suggestions.
RE: Should I use Insert Trigger or not?
Steve Jones - SSC Editor - Thursday, October 26, 2017 9:37 AMRE: Should I use Insert Trigger or not?
TheSQLGuru - Thursday, October 26, 2017 9:26 AMRE: Upgrading from SQL Server 2008 R2 to SQL Server 2016
SJanki - Monday, December 26, 2016 5:21 PMRE: msdb data file shrinkfile - Large Database
Imran-fast - Monday, September 11, 2017 1:53 AMRE: Copy records from one DB to another
Edvard Korsbæk - Monday, September 11, 2017 11:32 PMRE: Copy records from one DB to another
Is it possible there to create linked servers there and using that to connect both db(s) residing in different instances?
RE: Query Help - Slow Performance
bateman_aaron - Sunday, September 10, 2017 8:39 PMRE: SET NOCOUNT ON at instance level - not working.
So, following is what is the nutshell of our discussion:
1. Whenever, we code execute commands in SSMS. It doesn't matter what user option is selected in default connections...
RE: SET NOCOUNT ON at instance level - not working.
Thanks Gail. Makes sense. But why default connection options are available to choose for?
RE: SET NOCOUNT ON at instance level - not working.
GilaMonster - Monday, August 14, 2017 5:28 AMViewing 15 posts - 16 through 30 (of 54 total)
