SQL Audit

Technical Article

RE: sql reporting

  • Reply

Do you have a table listing departments for each company? Assuming there are always 4 depts for each company as in your example: SELECT counts.company_no, counts.dept_no, counts.count FROM (    SELECT dept_no = 1    UNION SELECT dept_no = 2    UNION SELECT dept_no = 3    UNION SELECT dept_no = 4    ) depts […]


Technical Article

RE: Data from SQL 2000 to Progress9.1d

  • Reply

hi Phill your reply was very helpful, thank you. we don't the process at the moment. what we are trying is: VB 6 front end and SQL 2K back database. then we need to send this data to other department. In other department they use Progress front end and Progress database as back end. Once […]


2 reads


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