Run Multiple Queries and Export To Different CSV Files

Question

I have a script that will run a sql query and if results are returned export those results to a csv file. I need to take that a step further now and have something similar to this: -- Run Query 1, if it returned results save. Run Query 2, if it returned results save, Run Query 3, if it returned results save.

$server = "Main"
$database = "hellfire"

$query1 = "Select * from mousetrap"
$query2 = "Select * from mickey"
$query3 = "Select * from brimstone"

$templatefile = @"C:\book1.csv"
$savedirectory = @"C:\ExportedFromSQL\Results\"

#Actual Conenction To SQL Server Goes here
#for brevity I am omitting

#check if query returned results
if ($SqlAdapter.Fill($DataSet) - ge 1)
{
    #this is where my catch comes in
    #if $query1 was executed I want to save the file as mouse
    #if $query2 was executed I want to save the file as mi
    #if $query3 was executed I want to save the file as stone

    #$DataSet.Tables[0] | Export-Csv $templatefile -NoTypeInformation
}

@AnsgarWiechers - as long as the correct query is associated with the correct filename they can run in any order. — MasterOfStupidQuestions
– MasterOfStupidQuestions, Commented May 28, 2015 at 21:18
Let me repeat the question: how do you decide which query to run? — Ansgar Wiechers
– Ansgar Wiechers, Commented May 28, 2015 at 21:19

Jan Chrbolka · Accepted Answer · 2015-05-29 00:37:52Z

3

Use a function to run your query, keeps it simple and you always know which query you are executing.

Function Execute-SQLquery {
    param ($QueryName, $QueryString, $ResultDir)

    #Actual Conenction To SQL Server Goes here
    #for brevity I am omitting

    if ($SqlAdapter.Fill($DataSet) -ge 1)
    {
        $DataSet.Tables[0] | Export-Csv (join-path $ResultDir ($QueryName + ".csv")) -NoTypeInformation
        return $true
    } else {
        return $false
    }
}

#Call your function
    if (Execute-SQLquery "mousetrap" "Select * from mousetrap" $savedirectory) {
        if (Execute-SQLquery "mickey" "Select * from mickey" $savedirectory) {
            Execute-SQLquery "brimstone" "Select * from brimstone" $savedirectory
        }
    }

edited May 29, 2015 at 0:37

answered May 29, 2015 at 0:32

Jan Chrbolka

4,4842 gold badges32 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Run Multiple Queries and Export To Different CSV Files

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related