Viewing 15 posts - 1 through 15 (of 21 total)
Thanks, but again, I'm having trouble getting the syntax right with two queries back-to-back. Could you elaborate?
December 19, 2018 at 11:47 am
I got the following to work, probably not kosher, but hey.
I created the url to put in the temp table like this: http://tada/folder/reportName?param1=blahparam2=blah
I then parse it for...
October 11, 2018 at 2:50 pm
That's so awesome! Did the trick. THANK YOU!
October 5, 2018 at 11:15 am
The restore to another database and then trying to copy just the specific rows did not work. My guess is the encryption key or something. I had a full backup...
May 26, 2016 at 11:21 am
a. I had a report up under the deployed/published site under http://
b. I was editing the report and accidently hit refresh and it published the report, now incorrect...
May 26, 2016 at 9:15 am
Found this one and it's just exactly what I need. Many thanks to Jingyang Li for sharing.
declare @date datetime = '2014-07-10 00:00:00.000'
, @start...
July 10, 2014 at 10:23 am
Thanks so much Elliott - will proceed. Was hoping a bigger and brighter brain than mine would have a slicker way.... Cheers.
February 3, 2010 at 12:29 pm
Found this and it worked like a charm - hope it helps someone else.
1. Select the ID with the select statement
select * from sysmaintplan_plans
2. Replace with the selected ID and...
March 5, 2008 at 8:45 am
Colin,
Thanks so much for the reply. I'm ashamed to admit I took the word of my contact at the 'remote' campus. When I did an @@version, I discovered that they're...
August 1, 2006 at 2:01 pm
Well, thank you Markus! We'll just go back to the subdirectories then. The examples given are weird, though, aren't they? They are the same size, with BAK and TRN extensions,...
July 28, 2006 at 8:15 am
Bill,
Ummm, already have that but I haven't found that to be very helpful with large, bulk inserts. It certainly works with entries made a record at a time with a...
July 27, 2006 at 1:40 pm
Thanks Bill! Actually, that's what I wound up doing and it's working great. Seems like there should be a way to convert null fields in the conversion, though, so you...
July 27, 2006 at 1:18 pm
Well, hell, Andy. I'm just dumb as a rock. Looked at this too long in panic, I guess.
I guess if you have no control over your import file, though, you'd...
July 27, 2006 at 12:13 pm
If this is helpful to anyone, here goes: Tried to go through the virtual lab for ssis on the MS site, but, unfortunately, got to page 7 of 15 and...
July 27, 2006 at 11:36 am
Andy,
Thanks so much for the reply. The engine is installed and running - with SP1 applied. If I resinstall, then reinstall SP1, what's the diff?
Somebody did suggest installing SP1...
July 27, 2006 at 7:07 am
Viewing 15 posts - 1 through 15 (of 21 total)