T-SQL Display Month Numbers and Names

By -
SELECT Number + 1 as [Month Number],
DateName(mm,DATEADD(mm,Number,0)) as [Month Name]
FROM master..spt_values
WHERE Type = 'P' and Number < 12

Comments

Post a Comment

Popular posts from this blog

Run a VBscript using SQL Server.

By -
Image
Today I came across a question in EE  of how to run a VBscript using SQL server. Well, it could be done using the SQL server agent or using SSIS, but the easiest way would be the SQL agent. Here how: 1-Right click on "SQL Server Agent" and select "New Job" 2-Name the job according to your needs. 3-From the "Steps" , select New. 4-Name it to your needs and select the "Type" as "Operating System CmdExec" as shown in the screenshot. 4-Set the schedule as desired and that's it!!
Read more

Open SSRS Linked URLS in a new window

By -
Image
Greetings....as I mentioned before sometimes I use my blog posts as a way to remind myself of the stuff that I need frequently and never keep to memory. I needed to add a link in a new SSRS report and the link has to open in a new browser's window. Just Right click on your report field, select "Text Box Properties", select "Action", click on the "FX" sign to write that special expression. ="javascript:void(window.open('" + Fields!URL.Value + "','_blank'))" Assuming that your URL is dynamic and the column name is "URL" in your dataset SSRS Link in  new Browser's Window Hope that helps...
Read more

SSRS Font Weight expressions

By -
Image
Recently I was tasked to edit an old SSRS report, the report has multiple columns and I need to change the font weight to BOLD based on a specific value. It's so simple but annoying that it needs to be done manually to all the columns that you need the expression to check. which was 25 columns in my case! Steps: Right-click on the column and select "text Box Properties" Select "Font" from the left menu Next to BOLD click on the expression menu In the expression screen; write the expression based on your column and the condition. =IIF(Fields!JB.Value > 0, "Bold","Normal") So here I'm setting the Property "FontWeight" of the textbox to be "Bold" when the value is greater than 0, otherwise, you're setting it to "Normal". hope that helps!
Read more