DT_BYTE to DT_DBDATE - I've got an SSIS project pulling data from a MySQL database into SQL Server. One of the date values in the...
synonyms vs views when using a linked server - Forum, In our current environment where we have 2 domains 1-PROD 2-DEV we usually restore previous night 6pm backup daily to...
Full Backup Files - Fastest Way to Copy Over WAN - Hi, I am trying to Robocopy large .bak files over the WAN and it's going terribly slow. The full backup files...
How To Truncate Log with Transaction Replication - I am running a transactional replication and seeing the transaction log growing in the publisher database; it is a little...
OPENROWSET - issue with spaces in the file name - Using SQL Server 2016. I am trying to read an Excel file using OPENROWSET. This works perfectly: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0...
TSQL query suddenly taking hours to run - Hi, I have a query that has suddenly started taking hours to run instead of a few minutes. I have tried...
Date Field Calculation Logic - Can somebody please help with this issue... /* Here’s the problem: Let's say we had a table of all US Presidents, with...
????????????NYU??Q/?457202606?????????????????????????????New York University - ????????????NYU??Q/?457202606?????????????????????????????New York University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2.
???????????RU??Q/?457202606????????????????????????????? Rutgers University - ???????????RU??Q/?457202606????????????????????????????? Rutgers University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??
????????????????UMN??Q/?457202606????????????????????????????? University of Minnesota Twin Cities - ????????????????UMN??Q/?457202606????????????????????????????? University of Minnesota Twin Cities QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1.
?????????????MSU??Q/?457202606????????????????????????????? Michigan State University - ?????????????MSU??Q/?457202606????????????????????????????? Michigan State University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ????????????
???????????UMich??Q/?457202606?????????????????????????????University of Michigan, Ann Arbor - ???????????UMich??Q/?457202606?????????????????????????????University of Michigan, Ann Arbor QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ?????
??????????NEU??Q/?457202606????????????????????????????? Northeastern University - ??????????NEU??Q/?457202606????????????????????????????? Northeastern University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ????????????
?????????????KSU??Q/?457202606????????????????????????????? Kansas State University - ?????????????KSU??Q/?457202606????????????????????????????? Kansas State University QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ????????????
???????????KU??Q/?457202606?????????????????????????????University of Kansas - ???????????KU??Q/?457202606?????????????????????????????University of Kansas QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ?
?????????????????UIC??Q/?457202606?????????????????????????????University of Illinois at Chicago - ?????????????????UIC??Q/?457202606?????????????????????????????University of Illinois at Chicago QQ??:457202606???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ?
What can be the benefits of copy_only backup - Dear Folks, I want to understand what could be the benefits of copy_only backup except independent with the existing log chain
Concatenate Strings in a COLUMN using comma delimiter, I need some nice code. - Please run my code and you will see what I mean. So I like to concatenate values in a column and...
Flag record change - Hi All, create table #pick ( Member_id INT, ApplicationID VARCHAR(30), Product varchar(5), EffDate Date, TermDate Date, AppRecDate Date ) insert into #pick select '200394', '2-16461538', 'A100', '1/1/2017', '7/31/2018', '12/18/2016' union...
Calculate Month Over Month - Hi , I want to calculate month over month change for below data Date platform Value 09/04/2018 X 2345 09/05/2018 X 2678 09/06/2018 X 2673 10/05/2018 ...