Forum Replies Created
Viewing 15 posts - 2,491 through 2,505 (of 2,883 total)
-
RE: Are the posted questions getting worse?
Lynn Pettis - Tuesday, June 13, 2017 8:14 AMRE: Need Suggestions on Best way to Query Data
Based on your description (I didn't look at your excel files), what you are asking for is not possible.
You state that TransTable_Description is a column which is no problem....
RE: Maintenance Cleanup Task Works Sporadically
Sue_H - Friday, June 9, 2017 1:15 PMRE: Data Integrity Check job failure
If I understand the problem correctly, you have filestream access turned on pointing to M: but you removed the M drive.
Did you re-point the filestream access to I:? Are...RE: Maintenance Cleanup Task Works Sporadically
Sue_H - Friday, June 9, 2017 12:19 PMRE: Maintenance Cleanup Task Works Sporadically
Michelle-138172 - Friday, June 9, 2017 10:46 AMRE: SSIS Question - How do we downgrade a SSIS package written in VS2015 to VS2012
You should just be able to take the DTSX's and import them into a new project in VS2012.
The issues you will likely have are more related to the SQL...RE: De-duplicating column values
Jacob, thanks for pointing out that those are blank not null as with my solution.
Update to my solution, replace the first INSERT INTO [#code2] section with:
[code...RE: Get Lowest value
mcfarlandparkway - Thursday, June 8, 2017 2:45 PMRE: Get Lowest value
mcfarlandparkway - Thursday, June 8, 2017 11:53 AMRE: De-duplicating column values
Possibly not the most efficient code, but how about:
CREATE TABLE #CODE
(
ID int ,
MOD0 varchar (20),
MOD1 varchar (20),
MOD2 varchar (20),
MOD3 varchar (20),RE: Maintenance Cleanup Task Works Sporadically
Do you have an antivirus installed on the system?
I know our antivirus sometimes catches the files when we go to delete them and ends up locking it while it...RE: Is my database corrupted?
As a weird thought, are all of your differential restores succeeding?
We do not do differential backups, but we do nightly fulls plus hourly t-logs. I have seen strange things...RE: SQL QUESTION but SSIS related - How do we get a list of parameters used by each DTSX file ?
mw112009 - Wednesday, June 7, 2017 3:03 PM
BTW-Thanks, that query worked fine.
Since you are an expert on this stuff, let...RE: Special Character Being Inserted into Data
As a thought, could this be a client processing issue not a server side processing issue?
What I have seen with some of our 3rd party solutions is that the...Viewing 15 posts - 2,491 through 2,505 (of 2,883 total)
