Hello all!
I am the resident Tessitura human for most things here at Mystic, and I'm starting to teach myself bits of SQL. I've figured out how to set batches to 'held', or 'closed', I can track down orders using the Transaction Number, and so forth- very basic, but useful, as we've had to use those from time to time.
What are some useful, and simple, things I can do with some basic commands?
Also, what would be good resources to building my skills in that area? I've pulled up some past powerpoint presentations done by Tessitura folks, and those have been helpful. Any other ideas?
Code Academy has a decent basic intro to SQL. https://www.codecademy.com/learn/learn-sql
As I've been learning SQL, I've found use-cases really helpful for hands-on learning. Perhaps look for some lists or extractions in your system and challenge yourself to recreate them using SQL. Or do you have an output set that you just really wish had one more element? Try to make it happen. Best of luck!
Lists are a great was to learn SQL Make a simple list. Click on SHOW QUERY. Take the SQL code and paste it into SSMS and fiddle with it to see how it works.Also any SQL job that i've done I've added to a Word doc and indexed. I hack that thing for all it's worth.Actually when I started the best query I ever found was this. Replace Business_Title in the where column with the column heading you are after like "source_no" or "appeal_no". It'll tell you what tables to go look at for your joins.
--Query for names of all tables which contain column with name
SELECT c.name AS 'ColumnName' ,t.name AS 'TableName'FROM sys.columns cJOIN sys.tables t ON c.object_id = t.object_idWHERE c.name LIKE '%Business_Title%'ORDER BY TableName ,ColumnName;
And finally 2 things that are invaluable are the Table Structures doc https://www.tessituranetwork.com/en/Files/Docs/SystemAdmin/Tessitura-Table-Structures-V15_1 and the Tessitura client screens to SSMS reference https://www.tessituranetwork.com/en/Files/Docs/SystemAdmin/Tessitura-Screens-Table-Reference-v125 it's 12.5 but it's amazing!
Redgate has a free plugin that I love which allows you to search very effectively: