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 […]

You rated this post out of 5. Change rating

2004-11-22

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 […]

You rated this post out of 5. Change rating

2003-09-03

2 reads

Blogs

Enabling an Index: #SQLNewBlogger

By

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers