Month: April 2008
-
AuthSub token has wrong scope
I was playing around with the Google Data API last night and I kept running into this error. The app I’m creating allows me to pull down a list of Google Calendars and then insert a new entry into the calendar that I select. Pulling the list was the easy part, adding a new entry…
-
SSRS Switch Statement
=Switch(Fields!Orders.Value < 100,”Red”, Fields!Orders.Value > 100, “Green”) The above statement is an example on how to use the ‘Switch’ statement in SQL Server Reporting Services. This example checks the ‘Orders’ value in a row and if the value is less than 100, displays “Red”. If the value is greater than 100, then display “Green”
-
Re-seeding the Identity Value
dbcc checkident ([table to re-seed], reseed, [value to set identity value at]) If you set the value to 0, the next inserted value will be 1