Viewing 15 posts - 196 through 210 (of 628 total)
In most cases the Job owner I do not beleive would even need any access to any DB's as long as it is a valid SQL login. We use...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 2:36 pm
that is your problem then try @activityStatusID='1'
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 1:01 pm
what type is @ActivityStatusID defined as?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 12:58 pm
I am not going to try to find line 97 in that but based on the error it is likely you have a subquery in the where cluase of one...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 12:56 pm
this should do the trick I would think.
case
when @ActivityStatusID = 1 then ACS.[Description] = 'Completed'
else ACS.[Description] <> 'Completed'
end
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 12:51 pm
is @ActiveStatusID a parameter or a variable. and is it defined in the stored procedure. What you have look good to me other than you need to add...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 12:41 pm
we make all jobs Etc. Owned by sa. At the time of creation you simply change to owner to sa. That is all that is required.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 12:25 pm
SELECT g_name, villa_type, COUNT(*) FROM guest_reservation, reservation
WHERE guest_reservation.confirm_no = reservation.confirm_no AND res_checkout_date = ‘insert date for when you would want to check out here’ GROUP BY villa_type;
you have a...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 9:52 am
I sounds like you are looking for a range of dates. you would have to define a seperate parameter in the report to store the second date. set...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 7:16 am
you need a + on both sides of the variable.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 7, 2011 at 7:47 am
what is the error message?
you would likely what something like this.
CreateDate> '''+convert(varchar(20),@startdate)'''
you would need three single quotes so that the resulted string would include the string date in single...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 7, 2011 at 7:31 am
In my humble oppinoin I would suggest that SSIS is likely not the best way to handle this process.
SSIS is not a file management system. While SSIS does have tools...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 7, 2011 at 7:25 am
Before anyone could help, you need to provide additional information. Is there an error message? If so what is the error message? What are the elements of the package?...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 7, 2011 at 7:15 am
you need to cast your dates as a varchar in order to concatenate with a string.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 7, 2011 at 7:11 am
I would shoot as large as possible if they are going to make you predict a DB size based on such limited information. I would also clarify over and over...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 5, 2011 at 2:32 pm
Viewing 15 posts - 196 through 210 (of 628 total)