Category Archives: SQL

Reset or Reseed SQL Server IDENTITY Column

Posted on March 4, 2008 by Terry Apodaca

I am sure this is well known by most of you, but I am a noob! and want to help other noobs out there that are like me. I needed to Create a new Cube today, and in the process … Continue reading →

Posted in Code, SQL | 1 Comment

SQL Server Reporting Services – Extract RDL Files

Posted on February 5, 2008 by Terry Apodaca

If you have ever needed to extract the .rdl file from SQL Server Reporting Server, it’s not very easy. The physical .rdl (Report Definition List) is not stored anywhere on the server file system. It’s stored in the Catalog table … Continue reading →

Posted in Free Software, SQL, Technology | 1 Comment

SQL: First and Last Day of Year

Posted on January 29, 2008 by Terry Apodaca

These lines of code will get you the First and Last day of the current year. SQL: SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0),’First Day of the Year’ UNION SELECT DATEADD(dd,-1,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,getdate())+1,0))),’Last Day of the Year’ Results: 2008-01-01 00:00:00.000 First Day of the Year … Continue reading →

Posted in Code, SQL | 3 Comments

SQL Dates – First, Current, Last Day of Month

Posted on January 28, 2008 by Terry Apodaca

I can’t give you a full tutorial on all things Dates when it comes to SQL, but I can show you how I solved a date task for a project I am now finishing up. This project includes finding data … Continue reading →

Posted in Code, SQL | 2 Comments