Tuesday, April 7, 2015

get specific day previous month t - sql

get specific day previous month t - sql
there is about six million different ways to compose these queries

select convert(date, concat( Datepart(m,DATEADD(m,-1,getdate())),'/','10','/',datepart(year,getdate())))

Thursday, February 12, 2015

ssrs report on crm dashboard

experienced some issues showing a ssrs report on a CRM 2011 dashboard.
the  standard criteria filters for the view settings were insufficient for the requested query so hence the need to put a rs report up and link to it in a crm dashboard. using a linked report or just a standard iframe both resulted in error city. A work around is possible by writing a html iframe, loading it into crm as a web resource, and then calling the web resource from the dashboard...
heres the sample code


<html><head><meta><meta><meta><meta></head><body style="word-wrap: break-word;"><iframe id="IFRAME_madeUPname" name="IFRAME_madeUPname" class="ms-crm-Custom" tabindex="0" url="http://yourRSURL&amp;rs:Command=Render" scrolling="auto" preload="0" src="http://yourRSURL&amp;rs:Command=Render" frameborder="0" height="100%" width="100%"></iframe></body></html>

Tuesday, February 10, 2015

crm 2011 workflow email issue

experienced and issue with a crm 2011 workflow failing to send and email, and remaining stuck in the status reason 'waiting for resource'. it seems the cause was from changing the cc, and bcc fields. there are other workflows that send emails with no issue.. so it it likely not the email router message Cannot create the given type without the required parameters. Plugin Trace: [Microsoft.Crm.Workflow: Microsoft.Crm.Workflow.Activities.EvaluateExpression] [EvaluateExpression] Error Message: the work around i found here proved insufficient https://rule30.wordpress.com/2014/04/10/fix-microsoft-crm-crmexception-cannot-create-the-given-type-without-the-required-parameters/ and ultimately ended up recreating the workflow

Friday, May 25, 2012

ohio short track 2012

Columbus has a promising short track series starting this summer http://capcityshorttrack.wordpress.com/series-information/ I can't wait for it!

Monday, May 14, 2012

spring

Spring news: Joined the CSU crew team. Fell in love with rowing. Most certainly want to stay with this sport. I think it is a great complement to cycling. Road: Road biking for me has kind of fallen to the side a bit. Though I did one road race in the Cuyahoga Valley National Park. I kept up for a few laps before being shot of that the back into no-mans-land. I will probably do more road races as the season progresses but not for a minute. Other: Bought a single speed mountain bike it is awesome and I spend everyday on it. Went back to polo finally to find that my skills have severely deteriorated. Finally graduated with a Master's, now for the easy part, finding a job.

Sunday, January 15, 2012

Nik







Cleveland lost a good friend last week. Here are the few pics I have of him.

http://www.youtube.com/watch?v=YeBXER6_I1k&feature=context&context=C393be84UDOEgsToPDskI0YBX_Pq82Sa38G5jrFQfj

Monday, November 21, 2011

another slow season

big props to the NEOCX administrators, its hard to imagine the amount of work (probably all of it done in peoples spare time) needed to have such an awesome race series.

big thanks to all the scum city racers, and Joy Machines Bike shop,

Kirtland pump station is my favorite course, always fast and fun, and being the last race of the season no matter what, there is something to look forward to here. I tried to get people to come out the race, making claims that, it will be easy to watch, i'll have beer,you'll laugh when you see me in spandex, and at least come for the food trucks, but everyone bailed. (There were a few surprise shows though, high-fives to the redryders and scott l.)

My race didn't go so well, and called it in the 4th lap when I hopped back on the saddle of the Centurion only to have it drop rails deep to the frame. I tried to fix it and carry on, but it was too jimmy-jacked to continue. I considered my options, and decided some tacos from the food truck were the best choice.

almost immediately daydreams of what to do to make next year better flooded my head and monopolized all my keyword searches in google and yahoo. Should I keep riding singlespeed? Should I get a bike with gears? If I go to geared do I have to race in the B's again? Will there be taco handups instead of beer?

I do have a couple of plans

1) stay in shape over the winter. this is easily the hardest to accomplish. riding the bike trainer is so boring... so very boring... in fact i don't know if there is anything more boring.

2) buy a mountain bike. last summer I was switching out the slicks on my polo bike with knobbies and riding that as a single speed mountain bike, but since that was stolen along with my CX bike I think I might take the plunge and buy the redline 29er

3) ride with people. riding by yourself makes you slow. riding with people makes it easier to push you self

4) become more involved with the NEOCX series