Let’s say I am concatenating a string with values from a collection. Every time I add a value, I want to append with a comma (,) and a space to separate. I don’t know at run time how many objects … Read the rest
When working with a menu control, I found that Internet Explorer 9 can’t handle setting both the static and dynamic hover style properties of the menu control. It works fine in Chrome and Firefox, but not IE-9.
To make IE-9 … Read the rest
I came across a scenario where I needed to write conditional statements in my WHERE clause of my SQL that was more complex than what a ‘CASE WHEN’ statement could provide.
I have two parameters, @FieldA and @FieldB. Both … Read the rest
Have you ever witnessed running a report in the Business Intelligence Development Studio only to see data that you know does not exist anymore in your SQL Database?
In certain circumstances, when previewing a report in BIDS, the environment bypasses … Read the rest
You have a collection of objects. You want a subset of that collection. Instead of making another SQL call to the database or using programming code to create a filtered subset of your original collection, you can accomplish this simply … Read the rest
If you are not using a stored procedure for you table adapter, then the answer is DON’T!!
I have done a lot of research and have found no perfect answer. Trying to pass ‘%’ to the fill method or embedding … Read the rest
While I was debugging in Visual Studio 2010, I come across this error when working with an aspx page that has a report viewer control. This only happens with IE. My report displays, but as soon as I click a … Read the rest
select * from date_range_table where ((@startdate1 IS NULL AND @enddate1 IS NULL) OR (start_date1 >= @startdate1 AND start_date1 <= @enddate1) OR (start_date1 >= @startdate1 AND @enddate1 IS NULL) OR (@startdate1 IS NULL AND start_date1 <= @enddate1)) AND ((@startdate2 IS NULL… Read the rest
To see, deactivate, or delete email subscriptions to your feed:
1) Login to www.feedburner.com
2) click Feed Title
3) Click ‘Publicize’ tab
4) Click ‘Subscription Management’ left column
5) Scroll to the bottom and click ‘View Subscriber Details’… Read the rest