Viewing 15 posts - 1 through 15 (of 49 total)
=Lookup(1,Fields!STORE_NO.Value,Fields!STORE_NAME.Value,"StoreByBrandHasLoyaltyRewards")
is what I was looking for
see hard coded 1
June 24, 2013 at 1:20 pm
i already know the value for it its textbox2.value, but it doesn't let you assign textboxes as values only parameters or tablix datasets fields.
im sure ill figure it out today,...
June 24, 2013 at 8:04 am
I can see maybe using a hidden report parameter or a report variable, but how to I change it on the fly. in expressions can you execute more then...
June 21, 2013 at 12:11 pm
I 100% agree this can be hacked. I made 1 improvement which I had -3 days to work on. This site has 12 ip's that can access as...
March 20, 2013 at 4:28 pm
common practice in my noodle, I say nolock when I don't care if I know its read only or don't want to interfere with anyone, and I don't use it...
March 20, 2013 at 2:22 pm
trust me this business logic allows all nolocks allowed. this is a read only database. its only written to overnight.
Thanks for the answer as it seems the dynamic...
March 20, 2013 at 2:07 pm
no it had 9k lines of
IF(@End_date is null)
BEGIN
END
ELSE
BEGIN
ELSE
BEGIN
etc
I changed it to
set @sql1 = 'select field,field field field'
set @sql2 = 'from table inner join tableb b on b.id =...
March 20, 2013 at 1:18 pm
Thank you for you feedback! I did not know they slowed down updates and inserts. Hope they dont bring that up.
Although aliasing with a view would make things...
April 16, 2012 at 8:35 am
the answer is basically the cache is just that big
mabye there is a better way of doing this but its 2 minutes per statment for my server, for a...
November 29, 2011 at 3:33 pm
Sean Lange (10/13/2011)
finallly, you get the question, which happens to be, the very first question!
The very first person who responded to your question...
At best you might be saving a fraction...
October 14, 2011 at 7:46 am
jared-709193 (10/13/2011)
October 13, 2011 at 2:18 pm
jared-709193 (10/13/2011)
xgcmcbain (10/13/2011)
Lynn Pettis (10/13/2011)
xgcmcbain (10/13/2011)
it will null, cause your implicity saying null, if i omit the column the default will fire
I think you are missing the point. If...
October 13, 2011 at 2:14 pm
Lynn Pettis (10/13/2011)
xgcmcbain (10/13/2011)
it will null, cause your implicity saying null, if i omit the column the default will fire
I think you are missing the point. If the column...
October 13, 2011 at 1:56 pm
Lynn Pettis (10/13/2011)
xgcmcbain (10/13/2011)
what im doing is giving it a default so it seams checking not null is ambiguousno outside application has access but myself
You say that now. This...
October 13, 2011 at 1:49 pm
it will null, cause your implicity saying null, if i omit the column the default will fire
October 13, 2011 at 1:45 pm
Viewing 15 posts - 1 through 15 (of 49 total)