Viewing 15 posts - 1 through 15 (of 22 total)
May 31, 2018 at 6:23 am
Phil Parkin - Friday, March 10, 2017 9:04 AMPlease post the CREATE TABLE script for dim.PatientEpisode, including the FK definitions.
Thanks - here...
March 10, 2017 at 9:24 am
Thank you for your replies. For clarification, sometimes patients get entered twice. After a decision is made as to which patient record should be the final one, the MRN is...
March 10, 2017 at 8:56 am
Looks like there is an update out now for this. The change log specifically mentions a fix for the issue when modifying a stored procedure.
September 30, 2016 at 12:56 pm
If you are getting this error, try to modify the proc in a different version of Management Studio.
I have been dealing with this problem all afternoon. I...
September 23, 2016 at 2:34 pm
I'm doing a data quality project now to look for oddities. So this is useful for me.
I modified the script so it includes schema, table, and column...
September 15, 2016 at 12:41 pm
Here's another list for healthcare data. This download contains info for healthcare providers. It includes name, business address, certification (MD, RN, LPN, etc.). The primary key is...
February 26, 2016 at 5:05 am
I had this error. In my case, I had the wrong selection in the For Each Loop container. Under collection there are three options:
name and extension
fully qualified
name only
I...
February 5, 2015 at 9:12 am
Thanks for the replies. It's a minor inconvenience. It would be nice if the package would run without waiting two minutes for it to build.
The project is on...
February 14, 2014 at 8:17 am
I have been searching for an answer to this also. I have a package that takes a few seconds to run. It outputs about a dozen rows to...
February 14, 2014 at 6:59 am
I tried this, and got an error saying I had to enable xp_cmdshell. So I Googled, and found this code to enable it:
EXEC sp_configure 'show advanced options', 1
GO
-- To...
December 3, 2013 at 7:24 am
It looks like a useful script after a little debugging. It's not returning a valid format for date fields. Here is an example that was created using the...
November 27, 2013 at 5:53 am
kramaswamy (11/8/2011)
November 16, 2012 at 11:07 am
o1390243 (10/9/2012)
great scriptthank you very much
I'm glad someone found it useful.
Were you looking for this script because yesterday was a bank holiday, and something went wrong?
October 9, 2012 at 12:59 pm
Solved it! (Actually, one of my co-workers pointed out the problem). When I imported the SSIS package to my new computer, somehow the use passive box in the...
March 30, 2012 at 12:36 pm
Viewing 15 posts - 1 through 15 (of 22 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy