sql server joining two set of data
I have the following simple (i think) requirement:
Have one value lets say '1', then I have a table with one column which has more than one row.
What is the SQL required so that I return two columns, the first column having all values of '1', the second column being the values from the table.
select 1 as yourValue, yourField from yourTable
Even more, if it's a value coming as parameter (in a variable) you could do the same
select @yourVariable as yourValue, yourField from yourTable