SQL Server 2019

Technical Article

RE: GROUP BY problem

  • Reply

Hi Rob,just to let you know. I adjusted your SP for my needs and found out following:Ok, I didn't mentioned that I can have also day 0 (zero); because of that I had to bring in a isnull function. (See first statement for first where clausel)select h_min.hotel_id, h_min.theday, h_max.theday - h_min.theday + 1 from hotels […]


Technical Article

RE: obtaining a reference to the current package

  • Reply

Dim objPkg  ' Get Package object  Set objPkg = DTSGlobalVariables.Parent This will get you a reference to the package itself. Then you can access all the properties you just mind have to google ad dig around for what you need syntax wise. I have no test machin here so if you need more help leave a […]


Technical Article

RE: Use RAISERROR with International error messages?

  • Reply

Ah, ussage is your promblem! this is how you are supposed to use it:at setup time call sp_addmessage for all required languagesex:use master exec sp_addmessage @msgnum = 50001, @severity = 10,  @msgtext = N'US English message',    @lang = 'us_english'EXEC sp_addmessage @msgnum = 50001, @severity = 10,    @msgtext = N'Mensaje en Español',    @lang = […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Multiply time by hourly rate

By pedroccamara

Hello all, I have this table with time for each row. It shows hh:mm....

Compare 2 tables and highlight where the column values has been updated

By Ravi

Hi All, I have a requirement to compare data from same table with different...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers