Monthly Archives: July 2013

bridging functions in SSRS

hey does anyone I know actually use Bridging functions in SSRS? I’d love some code samples if anyone has done this!   http://www.sqlservercentral.com/articles/Lookup/100391/

Posted in SQL Server | Tagged | Comments Off on bridging functions in SSRS

how to find a date – in SQL Server

#1 – create table CREATE TABLE TheDates( TheDate SMALLDATETIME, DbName varchar(255), TblName varchar(255), ColName varchar(255) ) #2 – run this in a database Select ‘insert into TheDates(TheDate, DbName, TblName, ColName) Select DATEADD(day, DATEDIFF(day, 0, [‘ + sc.name + ‘]), 0) … Continue reading

Posted in SQL Server | Tagged | Comments Off on how to find a date – in SQL Server

14 Reasons To Fire Your IT Staff

A lobbyist for a Windows 8 Start button. Progress means sometimes evolving the UI. If an IT pro can’t handle a new Start button, how is he handling your other technologies? An administrator cites security as a reason for not … Continue reading

Posted in SQL Server | Tagged | Comments Off on 14 Reasons To Fire Your IT Staff