Jan 11, 2016 · Query Logic. foreach(var a in (select id from table1)) { insert into table2 values(a,DateTime.Now) } I need the same above logic needs to be done in SQL server. Any …

Apr 2, 2012 · Then parse it into a table using one of many open-source SQL user functions:-- @designations = 'developer,tester,techlead' select text_val from …

Sep 15, 2015 · I have a table [dbo].[product]: [id] [component] [quantity] 01-----A-----2 02-----A-----6 03-----A-----8 04-----B-----1 05-----B-...

Feb 7, 2013 · and want to write a query for them where Location and UnitNo are same but Sector is different means I have sectors in different locations where UnitNo is same. I wrote this one …

Feb 22, 2012 · I am using SSMS 2008 and am trying to write a TSQL statement to return only records with multiple "intake_dt" values per "people_id".

Jul 30, 2013 · SQL Managment studio is meant for designing proc's and accessing the SQL Server Database for it's object creation directly. SSRS is meant to return data connections, …

Mar 29, 2014 · select @sql = 'insert into lookuptable (policynum, limit, deduct, premium) ' + @sql exec (@sql) To fine tune, add indexes where appropriate. Also, this solution will break after …

Apr 5, 2013 · My requirement is how to write a query for multiple columns in select and in group by only 1 column. In this multiple columns of select, the first column i have used distinct. But I …

Apr 28, 2012 · How would you write a query to select the rooms which are booked between 2012-05-1 and 2012-11-01 from a booking database?

Aug 8, 2012 · I have a Query that's supposed to run like this - If(var = xyz) SELECT col1, col2 ELSE IF(var = zyx) SELECT col2, col3 ELSE SELECT col7,col8 FROM . . . How do I achieve …