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

Practical Web Scraping with Python: A Clean, Safe Pattern for Pulling Company Names & Emails

By -
Image
Practical Web Scraping with Python: A Clean, Safe Pattern for Pulling Company Names & Emails Turn that quick-and-dirty script into a reliable tool you won’t be afraid to run twice. Meta description suggestion: Learn a production-friendly pattern for scraping company names and emails with Python, Requests, and BeautifulSoup—featuring retries, timeouts, robots.txt checks, pagination, and CSV export. On this page The problem The cleaned, safe solution Copy-paste code How it works How to run it Practical use cases Pitfalls & guardrails Variations & alternatives What to try next The problem You’ve got a page of companies and you want the name and email for each one. The “first pass” script might work on your machine, but it’s brittle: no retries, no timeouts, no robots.txt check, and it assumes every email is a mailto: link. The cleaned, safe ...
Read more

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

Pydantic: your bouncer for messy data (with real examples)

By -
Pydantic: your bouncer for messy data (with real examples) If you’ve ever had a pipeline blow up because "quantity" showed up as "two" , you already get why validation matters. Meta description suggestion: Learn how to use Pydantic (v2) to validate API inputs, clean data-pipeline rows, load typed settings from environment variables, and produce clear error messages—with practical Python examples. Quick jumps Why validation saves your sanity The problem Pydantic solves Install Examples you can copy/paste Benefits Use cases Wrap-up Why validation saves your sanity Pydantic is a guardrail for input data. You describe the shape using Python type hints, and Pydantic checks it at runtime. When something’s off, you get a clean ValidationError that tells you exactly what faile...
Read more