FAQ Database Discussion Community


php “||” assignment logic compared to Javascript

javascript,php,variable-assignment
I was testing Heredoc and || functionality function test() { $obj = [(object)['col1'=>'val1'], (object)['col2'=>'val2'], (object)['col3'=>'val3']]; $output = ''; $mystring = <<<EOT a non empty string EOT; foreach($obj as $prop) { foreach($prop as $i) { $output .= <<<EOT <div style='background-color:lightblue'> \$head : {gettype($i)} </div> EOT; } } $out = $output ||...

Why does single `=` work in `if` statement?

ruby,variable-assignment
This code is provided as an example in for use with devise and OmniAuth, it works in my project. class User < ActiveRecord::Base def self.new_with_session(params, session) super.tap do |user| if data = session["devise.facebook_data"] && session["devise.facebook_data"]["extra"]["raw_info"] user.email = data["email"] if user.email.blank? end end end end I don't know why it's a...

Declaring variable and assignment [closed]

java,class,variable-assignment,variable-declaration
I was just practicing java program in eclispe following is the code: import java.util.*; class Problem7 { public static void main(String args[]){ int num,sum=0,mod_num,count;//Syntax error on token ";", { expected after //this token. Ques=Why? System.out.println("Enter a 5 digit number"); try(Scanner n1 = new Scanner(System.in)) { num = n1.nextInt(); } for(count...

python pandas variable assignment

python,loops,pandas,variable-assignment
I have an issue with python pandas variable assignment: I have a tuple like asd=('prostate1.csv','dtime','status1','age','hg','sz','sg','pf','rx') reading the file is just fine: prostate_dataset=pd.read_csv(asd[0]) but trimming the dataset doesn't work seamlessly: prostate_dataset=prostate_dataset[[for x in asd[1:]]] what I want to get is like this: prostate_dataset=prostate_dataset[[asd[1],asd[2],asd[3],asd[4],asd[5],asd[6],asd[7],asd[8]]] I've tried: act='\',\''.join(asd[1:]) prostate_dataset=prostate_dataset[[act]] but it didn't work...

Simultaneous column assignment

python,pandas,variable-assignment
I just found that I can't assign like this: df[['a','b','c']] = 'total' or df.loc[:, ['a','b','c']] = 'total However, I can do df['a'] = 'total' df['b'] = 'total' df['c'] = 'total' or df['a'] = df['b'] = df['c'] = 'total' Am I missing something?...

Why is my brushstroke thickness changing?

java,variable-assignment,graphics2d
My assignment is to draw horizontal lines random in width and random line thickness. When I run my program the thickness changes part way through. I don't understand how that is possible since I am setting the width then drawing the line. I don't update so I am not redrawing...

Prolog: Appending to the head of a list

list,prolog,variable-assignment
How do I do the above? Specifically, if I have a list like this: List = [8, 9, 10]. % I know this using matching to assign the say that [8, 9, 10] = [8, 9, 10], thus making List contain [8, 9, 10] Now if I try to append...

static and final static assignment

java,variables,static,variable-assignment,final
I was using same kind of concept , I used in first class. b was initialized to 0 and I got 0 everywhere I used b. After some time I got the reason and ran debugger and saw a has not been allocated any value till function call.variable a has...

CodeIgniter, pass data from model to controller to use in view

php,codeigniter,variable-scope,variable-assignment
I want to pass data queried in my model to the controller, to do so I am using return $data. Then in the controller I use $this->load->view('my_view', $data); From my understanding var_dump($data); in the view should show me the results from the query... This is not the case. I am...

Why can I not use the Unicode characters √ and ∀ in assignments?

unicode,variable-assignment,julia-lang
Julia has an interesting support for Unicode characters. The syntax allows me to run the following in the iJulia notebook. μ = 10 σ = 20 ∑ = sum a = [1,2,3,4] ∑(a) # prints 10 However, it doesn't always seem like you can use Unicode characters for function/variable names....

Can't select Object of Array with correct index

java,arrays,variable-assignment
We are developping a game for monsters and hero's. Upon intialization of the hero, he has a given strength. (in this case 50) Strength is a double with precision of two digits. According to the strength of the hero, his capacity for carrying various Items is initialized by following rules:...

C++ compile error - no match for ‘operator=’

c++,constructor,variable-assignment
The following code compiles without problem class MyClass { public: MyClass() { std::cout << "Default Constructor!" << std::endl; } MyClass& operator=(const MyClass& m) { std::cout << "Copy assignment operator!" << std::endl; } }; int main() { MyClass a; MyClass d; d = MyClass(a); } but when I change assignment operator...

Can you use equals assignment when removing delegate members in a disposing method?

c#,delegates,operators,variable-assignment,dispose
I have the following code in my class public class Receiver : IReceiver { public event EventHandler Received; public void Dispose() { Dispose(true); GC.SuppressFinalize(this); } protected virtual void Dispose(bool disposing) { if (disposing) { if (Received != null) { foreach (EventHandler delegateMember in Received.GetInvocationList()) { Received -= delegateMember; } }...

How to make nested while loop faster in R? Converting to C++

c++,r,while-loop,nested,variable-assignment
This question seems to be answered but I didn't get quite a certain idea from the previous answers. I am having an R-code where I need to assign 9k by 9k matrix. (assignment algorithm) In my optimization test part, while assigning as many task as possible (refer to Hungarian algorithm...

Java constructor reference assignment Vs new created object assignment

java,constructor,java-8,variable-assignment,method-reference
I met in our project following code: MyInterface var = MyClass::new; Is there difference with MyInterface var = new MyClass(); Lazy?...

Global assignment within a reactive expression in R Shiny?

r,null,shiny,variable-assignment
suppose I have a data object that is uploaded by the user: data <- reactive({ inFile <- input$file if (is.null(inFile)) return(NULL) data <- read.csv(inFile$datapath) return(data) }) And suppose I want to delete columns in the dataset. I want to set it to global assignment so that I can run the...

C - understanding struct members vs pointers (char *)

c,pointers,struct,variable-assignment,c-strings
So I started learning C. It has been smooth so far, but I am finding it difficult understanding a few things. Since I am new, I don't really know what search terms to use, but all my searches have turned up nothing useful. Look at the code below #include <stdio.h>...

The usage of let in Haskell

haskell,variable-assignment
I have this code in Haskell. import Data.List main = do putStrLn $ "\nVerify if Exists in a String" let wordlist = ["monad", "monoid", "Galois", "ghc", "SPJ"] let tweet = "This is an example tweet talking about SPJ interviewing with Galois" print $ map (flip isInfixOf tweet) wordlist Without the...

Assign variables imported from csv

python,arrays,csv,variable-assignment
I have a .csv file which has 3 columns, and looks like this. -10.5,7.79,0 -10.5,8.37,0 -10.5,9.52,0 -10.5,10.10,0 -10.5,11.25,0 I want to assign the numbers in the 1st column to the variable array 'x' and the 2nd column to 'y' and 3rd column to 'z'. So that I can plot a...

conditional assignment of multiple values

lua,variable-assignment
I've got a function that either can take two parameter, or calls another function to retreive these values(semi-defaults in that case). Let's say the first function looks like this: -- the actuall issue function: function foo( param_1, param_2 ) local bar_1, bar_2 = param_1, param_2 or getBar() -- make funny...

sh boolean short circuit variable assignment

bash,sh,variable-assignment,short-circuiting
I'm trying to write a script that takes flags as parameters, so I want to be able to handle them being passed in any order. This is what I have so far: #!/bin/sh numargs=$# echo $numargs check_param () { if [ "$1" = "$2" ]; then return 1 else return...

Property returns string from base class while member returns string from inherited class?

c#,variables,inheritance,variable-assignment
Here is the program: public class Program { static void Main() { MyInheritedClass InheritInstance = new MyInheritedClass(); Console.WriteLine(InheritInstance.name); // the name field } } public class MyClass { public string name= "I am the Base"; // the name field public string Name // the Name property { get { return...

how to assign values into a 2D vector like a 2D array

c++,arrays,c++11,vector,variable-assignment
Is there anyway to do it? Currently I use like this: for( i=0;i<PU_number;i++) { for( j=0;j<=time_slots;j++) myMatrix.tempVec.push_back(0.0); myMatrix.value.push_back(myMatrix.tempVec); myMatrix.tempVec.clear(); } However, it is not useful for me. Sometimes I need to change a particular adress in this vector. like myMatrix.tempVec[1][4]. When I do it like this: myMatrix.value[i][j]=value; it corrupts memory,...

Using conditions in variable assignments in Python

python,variable-assignment
I want to use conditions in variable assignment in Python like how I do it in C#. myLang = lang=='en' ? 'en' : lang=='ger' ? 'de' : 'fa'; I found this question which says Python has this kind of assigments. num1 = (20 if someBoolValue else num1) But I can't...

Side effect/ changing global varaibles that pass into a function

javascript,arrays,global-variables,variable-assignment
Forgive me if this question has been asked, but I can't seem to find it. I am attempting to create an array and reverse it (without using reverse) This bit of code works perfect: function reverseArrayInPlace(array) { for (var i = 0; i < Math.floor(array.length / 2); i++) { var...

How can I read inputs from user and create a 2-D List?

python,list,python-3.x,variable-assignment
I have created a 2-dimensional array like: >>> a = [[0 for col in range(3)] for row in range(3)] then >>> for i in range(3): ... for j in range(3): ... a[i][j]=input() ... 1 2 3 4 5 6 7 8 9 but it doesn't success,python think '1 2 3'...

C++ - Error: Expression must be a modifiable lvalue

c++,variables,syntax-error,variable-assignment
I'm creating a C++ application and I have a class which contains a char array variable, like this: class MyClass { public: // The constructor MyClass(char[]); private: // The variable char myVariable[]; } And I try to set this variable in a constructor like this: // The constructor MyClass::MyClass(char myVariable[])...

c# class being overidden and can not be assigned

c#,class,reference,variable-assignment,memberwiseclone
I am having a code like this [System.Serializable] public class class1 { [System.Serializable] public class class2 { public int var1, var2; public string var3; public class2 () {} public class2 (int v1, int v2, string v3) { var1 = v1; var2 = v2; var3 = v3; } } public class2[]...

Bash assign string to variable and print

string,bash,variable-assignment
This has been driving me mad for the past hour or so. I have four variables, $A, $B, $C, and $D. For simplicity's sake, let's assume that the values in each of those variables is their corresponding letter. I have tried to create a variable to hold a string I'd...

execute if statement in variable value assignement powershell

powershell,if-statement,variable-assignment
Sometimes I need to check if a pathname ends with "\" adding it if necessary, the code is pretty simple, something like this if ($destFolder[-1] -ne '\') { $destFolder += '\'; } Is there a way to evaluate an if statement inside () so that I can use it in...

Data table assignment not working

r,data.table,variable-assignment
Ok so I am cleaning a large dataset and trying to speed things up by changing data frame code to data table. I'm having trouble with conditional assigment of missing value codes. Toy example: X = data.table(grp=c("a","a","b","b","b","c","c","d","d","d","d"), foo=c(1:4,NA,6:7,NA,8:10)) setkey(X,grp) err.code <-"1111" row.select <- row.names(X)[X$grp=="b" & is.na(X$foo)] # Replace missing value...

Java assignment operator

java,variable-assignment,equality,convention
The following blockquote is taken from http://www.oracle.com/technetwork/java/javase/documentation/codeconventions-137265.html Do not use the assignment operator in a place where it can be easily confused with the equality operator. Example: if (c++ = d++) { // AVOID! (Java disallows) ... } should be written as if ((c++ = d++) != 0) { ......

Multiple differing views of the same list [duplicate]

java,variable-assignment,comparator,knapsack-problem,genetic
This question already has an answer here: How do I make 2 comparable methods in only one class? 3 answers I'm trying to make iterators for a class called Ship. This is for a genetic algorithm example. The two key attributes of Ship are weight and volume (knapsack problem)....

How to randomly create and assign variables and shorten an if-else statement (Java android)

java,android,variable-assignment
I was wondering how to shorten my code by automatically creating and assigning variables for TextViews. Also, how do you shorten these if-else statements? I have looked at other threads, but they haven't fulfilled my needs. I am using Android Studio for this. Here is my Java code: package com.example.ani.testproject;...

Can someone help me assign multiple string arrays into one 2d string array?

c#,arrays,string,multidimensional-array,variable-assignment
In C#, can someone help me assign multiple string arrays to a 2d string array? Here is my code: string[] test1 = new string[5] { "one", "two", "three", "four", "five" }; string[] test2 = new string[5] { "one", "two", "three", "four", "five" }; string[] test3 = new string[5] { "one",...

Assigning variable in for loop to the x coordinate of each point in an arraylist

android,for-loop,arraylist,coordinates,variable-assignment
I'm trying to assign each x and y coordinate in my ArrayList to a variable as each coordinate will be compared to the coordinates of the point a user will click on the screen. // the coordinates of each point Point p1 = new Point(100, 100); Point p2 = new...

Interpret formulae/operators as functions

r,function,variable-assignment,formula,evaluation
Is it possible in R to assign custom functions to mathematical operators (eg. *, +) or interpret the formulae supplied with as.formula() as a directive to evaluate? Specifically, I would like * to be interpretted as intersect(), and + as c(), so R would evaluate the expression (a * (b...

Assignment of all-zeroes to a nested struct in C (GCC versions < 5)

c,struct,variable-assignment
I have a nested struct in C99 (I'm using GCC 4.8.3 with -std=gnu99 -Wall). struct X { struct { int p; int q; } a; struct { int m; int n; } b; int c, d, e; }; I want to define a "default value" for it which is all-zeroes....

double-type Assignment Error, C++

c++,variable-assignment
I preempt my question with the fact that I started using C++ two days ago. I get this error: "a value of type "double (*)()" cannot be assigned to an entity of type "double"" My pertinent code: #include "stdafx.h" #include <iostream> #include <string> using namespace std; double getInput() { double...

C++ - Why does 2 local references to the same object stay in sync?

c++,pointers,syntax,reference,variable-assignment
I would like to understand what's going on here. Obviously, there's some aspect of references or assignment operators that I am not getting right. Objective: Within a function, I want to work with 2 local reference variables to various elements of the same list: one is the iterated over and...

Unexpected return value in ruby

arrays,ruby,variable-assignment
def gen_path_locations(start, destination) initial_dest = destination last_dest = destination path_locations = [] loop do last_dest[0] -= 1 if initial_dest[0] > start[0] last_dest[0] += 1 if initial_dest[0] < start[0] last_dest[1] -= 1 if initial_dest[1] > start[0] last_dest[1] += 1 if initial_dest[1] < start[0] break if last_dest == start path_locations << last_dest...

What is the efficient way of boolean value assignment in java?

java,boolean,variable-assignment
We can assign boolean value in three ways boolean isDone; isDone = true; isDone = Boolean.valueOf(true); isDone = Boolean.TRUE; so which assignment is more efficient? ...

Is there a way to assign multiple variables a same value or attribute?

python,variable-assignment,typing
In Python, is there a way to make a, b, c, d, e = 'dog' so that a = 'dog' b = 'dog' #etc. or a, b, c, d, e = list() so that type(a through e) returns type 'list' ...

python3.4.2 how to assign a string with texts and variables

string,python-3.x,variable-assignment
I want to assign string in the format of two words followed by their corresponding variables like: "newstring = 'length', length, 'slope', slope" And I will use this in a text function like text = Text(point1, newstring) is there a way to achieve this?...

How can I create an array assignment from HEREDOC text using PHP?

php,arrays,eval,variable-assignment,heredoc
I have a list of strings I need to convert into an array assignment eg lets say I have a set of lines like this: ctools_export_ui_list_form masquerade_block_1 switchtheme_switch_form backup_migrate_ui_manual_backup_load_profile_form backup_migrate_ui_manual_backup_form I need to create a variable assignment like this: $conf['journal_form_ids'] = array( 'ctools_export_ui_list_form' => 0, 'masquerade_block_1' => 0, 'switchtheme_switch_form' =>...

Asked to simulate CMOS N_Type and P_Type transistors. No Idea

java,variable-assignment
I first want to apologize as this is a very specific question that may not help anyone else. Anyways, I was asked: "Overview Write simulations of the CMOS N_Type and P_Type transistors. Use your simulated transistors to implement the common logic gates." I have read about transistors online and even...

Array assignment only works with intermediate variable in C++

c++,arrays,gcc,variable-assignment,stdvector
I have a weird problem where an array assignment only works if I use an intermediate variable. Here's the setup of the program: struct A { int values[4]; }; std::vector<A> items; The items vector is inside a class, defined in its header file. The vector is filled with 'A' structs...

C++ Can I assign an int by using string::at?

c++,string,int,variable-assignment
In my code I have this: int enemyNumber = numberType.at(0); numberType is a string. The first character in string numberType is '1'. But int enemyNumber instead becomes 48 after that assignment. What is going on and how do I get enemyNumber to become '1'?...

matlab: filling matrix diagonalwise [duplicate]

matlab,matrix,variable-assignment,diagonal
This question already has an answer here: adding values to diagonals of matrix using element-wise addition in matlab 3 answers I have an (2n-1)-by-1 vector with certain values and I want to obtain an n-n matrix with the diagonals filled using the same value. Eg. if I have a...

PHP - Extends class modify protect parent

php,class,variable-assignment,extends
I created an extended class in order to modify a protected var for particular purpose. However I don't understand how I can modify a parent class protected var from a child class and use it everywhere in the parent functions. For example: class parent { protected $data; public function __construct()...

parallel assignment variable from python to java (Pi algorithm)

java,python,algorithm,variable-assignment,pi
I would like to translate a python algorithm to Java, I have this source code (using parallel asignment variable (doesn't exist in Java :( ) # -*- coding: cp1252 -*- #! /usr/bin/env python import sys def main(): k, a, b, a1, b1 = 2L, 4L, 1L, 12L, 4L while 1:...

The assignment to variable [Something] has no effect

java,variable-assignment
this.name = name; this.bind = bind; this.category = category; It says "The assignment to variable (One of the 3) has no effect. I don't know why this error is ocurring, please help. I am using Eclipse, Java. The Full code is below: public class Module { private String name; private...

pandas multiindex assignment from another dataframe

python,pandas,variable-assignment,multi-index
I am trying to understand pandas MultiIndex DataFrames and how to assign data to them. Specifically I'm interested in assigning entire blocks that match another smaller data frame. ix = pd.MultiIndex.from_product([['A', 'B'], ['a', 'b', 'c', 'd']]) df = pd.DataFrame(index=ix, columns=['1st', '2nd', '3rd'], dtype=np.float64) df_ = pd.DataFrame(index=['a', 'b', 'c', 'd'], columns=['1st',...

Behaviour of assign_attributes with nested forms

ruby-on-rails,variable-assignment,nested-forms
assign_attributes doesn't seem to recognise when I delete nested objects. I have a model called Order: class Order < ActiveRecord::Base has_many :deliveries, :dependent => :destroy accepts_nested_attributes_for :deliveries, :allow_destroy => true end Say I create an order with two deliveries. Then I open the 'edit order' form (which is a nested...

Objective-C struct definition and modification gives error 'Expression not assignable'?

ios,objective-c,struct,variable-assignment
I have been reading other similar questions but those solutions either don't fit our don't solve the problem I have in my hand. My code is actually quite simple, I don't know how I should do what I want. Ok: In .h file I have: struct MyState{ float quantizer; BOOL...

.NET use IIF to assign value to different variables

.net,vb.net,conditional,variable-assignment,iif
Could I (and if so how) do the following in .NET language (more specifically VB.NET): Dim a,b as Integer if(somecondition=1,a,b) = 12345 Or any variant with IIF would be fine by me. Basically I'm always assign the same value but never to the same variable.....

Does the following chained assignment cause Undefined behavior?

c,variable-assignment,language-lawyer,undefined-behavior
Does the following code invoke undefined behavior in C? int a = 1, b = 2; a = b = (a + 1); I know that the following does invoke UB: a = b = a++; The reason is that it violates the following clause from the standard: Between the...

What does this if assignment/statement mean in C++

c++,if-statement,condition,variable-assignment,conditional-statements
Our professor gave us this code. It assigns a value to a char[] depending on the value of the first index in the array. He said it was an if statement but I've never seen one like this. I'm new to c++ temp.byte[0] = byte[0] == '0' ? '1' :...

Why does the compiler complain about the assignment?

c,variable-assignment
While compiling the following code, the compiler produces the warning: assignment discards ‘const’ qualifier from pointer target type #include<stdio.h> int main(void) { char * cp; const char *ccp; cp = ccp; } And this code is ok(no warning).Why? #include<stdio.h> int main(void) { char * cp; const char *ccp; ccp =...

How to use functions to assign variables in MATLAB?

matlab,function,variable-assignment
I want to create a structure and then use functions to assign various attributes. For example, I have the following code: global car function f1(x) car.color = x; end function f2(x) car.make = x; end Why doesn't this work? I don't need the functions to return anything, I just need...

Is there a Python 'shortcut' to define a class variable equal to a string version of its own name?

python,string,variable-assignment
This is a bit of a silly thing, but I want to know if there is concise way in Python to define class variables that contain string representations of their own names. For example, one can define: class foo(object): bar = 'bar' baz = 'baz' baf = 'baf' Probably a...

C assign string from argv[] to char array

c,arrays,expression,variable-assignment,argv
I have the following code which reads an file name from the command line and opens this file: #include <stdio.h> #include <stdlib.h> int main(int argc, char **argv){ FILE *datei; char filename[255]; //filename = argv[1]; //datei=fopen(filename, "r"); datei=fopen(argv[1], "r"); if(datei != NULL) printf("File opened"); else{ printf("Fehler beim öffnen von %s\n", filename);...

What does Java object assignment mean?

java,object,variable-assignment
I have the following 2 classes : class Animal { public static void staticMethod(int i) { System.out.println("Animal : static -- " + i); } public void instanceMethod(int i) { System.out.println("Animal : instance -- " + i); } } class Cat extends Animal { public static void staticMethod(int i) { System.out.println("Cat...

Interview: practical uses of assign-by-reference (as opposed to pass-by-reference)

c++,reference,variable-assignment,assignment-operator,assign
I once landed an interview and was asked what the purpose of assigning a variable by reference would be (as in the following case): int i = 0; int &j = i; My answer was that C++ references work like C pointers, but cannot assume the NULL value, they must...

Is it possible to have multi line assignment in Python?

python,line,variable-assignment
Example of nasty assignment using __ setitem __: self.outer_scopes[self.children.item(i).getNodeName()][self.children.item(i).item(j).getNodeName()] = self.children.item(i).item(j).getTextContent() Is it possible to do something like this? self.outer_scopes[self.children.item(i).getNodeName()][self.children.item(i).item(j).getNodeName()] = self.children.item(i).item(j).getTextContent() I mean, to split the assignment, not the strings after it with \ or whatever....

Coalescing Swift operator for an empty non-nil string

string,swift,variable-assignment,empty-string
I have a string variable in Swift: let foo = "bar" But it can also be any other arbitrary string. Now I want to do the following: let bar = ... // either the value of foo, or if foo is "", it will be "default" I looked up "coalescing...

Assigning a value in exception handling in R

r,exception-handling,variable-assignment,rcurl
while(bo!=10){ x = tryCatch(getURLContent(Site, verbose = F, curl = handle), error = function(e) { cat("ERROR1: ", e$message, "\n") Sys.sleep(1) print("reconntecting...") bo <- bo+1 print(bo) }) print(bo) if(bo==0) bo=10 } I wanted to try reconnecting each second after the connection failed. But the new assignment of the bo value is...

Can't assign a value to a variable in a case statement in bash

bash,unix,variable-assignment
I just ran into a problem while I was trying to assign a value to a variable inside a case statement, here is my code: #!/bin/bash while getopts ":m:n:::" opt; do case $opt in n) echo "-n was triggered, Parameter: $OPTARG " >&2 case $OPTARG in t) echo threads r=threads...

Getting Input from a Function - c++ [duplicate]

c++,function,variable-assignment,temporary
This question already has an answer here: When I change a parameter inside a function, does it change for the caller, too? 4 answers I've been having a problem in c++ where I call a function which assigns some values to things, but those assignments are lost after the...

How to assign the echo statement from a function call to a variable?

php,function,variable-assignment,output-buffering
I am trying to get the echo of a function and add the value into a variable. So this is what I've done. function myfunction() { echo 'myvar'; } Then I want to get it into a variable like this: $myVariable = myfunction(); I thought this would work but I...

Is it ok to replace std::thread objects?

c++,variable-assignment,stdthread
From what I could gather in C++ online documentation, assigning to a joined std::thread object should call its destructor and represents a legitimate operation. Is this the case? Here some example to show what I mean: #include <thread> #include <vector> using namespace std; int main() { vector<thread> tvec; for(int =...

Working T-SQL query gives error when values assigned to variables

sql-server,syntax,variable-assignment
The following query works. However, when I uncomment the commented lines in order to assign query variables to my locally-defined variables, I get a syntax error at the final ";". DECLARE @tmp_total_ct int = 0; DECLARE @tmp_closed_ct int = 0; --SELECT @tmp_total_ct = tot_ct, @tmp_closed_ct = cls_ct -- FROM (...