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