Viewing 15 posts - 961 through 975 (of 2,452 total)
Rankerg (1/10/2016)
Yes I think this is pretty close, I want the amended and new records in a NEW File
am a bit confused...what are you going to do with your NEW...
January 10, 2016 at 2:28 pm
--- example only to fully understand the problem.
--- expect some feedback to determine if this is representative of your problem
--- if not then PLEASE provide necessary code to explain...based on...
January 10, 2016 at 1:43 pm
Rankerg (1/10/2016)
January 10, 2016 at 12:33 pm
Yes Good question see inline answers above
???
where are they? (help <grin>)
edit...timing issue...sorry
January 10, 2016 at 12:18 pm
So let me rephrase the question
We would take the full file (Dec file) , compare/ check it to prior records imported (Nov file) and ignore the duplicate...
January 10, 2016 at 11:36 am
Alvin Ramard (1/8/2016)
simon-hulse (1/8/2016)
...
Do people forget the SQL is a FREE tool and ANYONE can download it - so yes, a lot of the questions you see are from...
January 8, 2016 at 11:21 am
farside41 (1/8/2016)
Lowell (1/8/2016)
how about fully qualified instead of WINS name?
ie connecting to 10.40.10.100 or...
January 8, 2016 at 10:29 am
is the sql instance you are trying to connect with on your local Pc or remote server?
has this issue started just recently or always been "slow"
January 8, 2016 at 10:02 am
Tallboy (1/7/2016)
Jeffs code ran brilliantly until changed my test data and added two appointment rows for the same client with same date and times data but with different StaffID's.
The...
January 8, 2016 at 4:41 am
guy 1966 (1/7/2016)
January 7, 2016 at 12:12 pm
Tallboy (1/7/2016)
January 7, 2016 at 7:55 am
With the above test data we should end up with 48 new rows in the TblAppointments!
sorry bit confused......does the frequency indicate a single day or every day.
perhaps if you helped...
January 6, 2016 at 1:00 pm
azawan (1/5/2016)
I have task to calculate future dates which excludes weekends and holidays for few columns. Example is below.
workdb contains following
Columns in sql server 2014 workdb.
Start Date ...
January 5, 2016 at 1:06 pm
Viewing 15 posts - 961 through 975 (of 2,452 total)