I am creating a stored procedure to do a search through a table. I have many different search fields, all of which are optional. Is there a way to create a stored procedure that will handle this? Let’s say I have a table with four fields: ID, FirstName, LastName and Title. I could do something … Read more
I have a piece of dynamic SQL I need to execute, I then need to store the result into a variable. I know I can use sp_executesql but can’t find clear examples around about how to do this. 10 Answers 10
I have two variables, one is called PaidThisMonth, and the other is called OwedPast. They are both results of some subqueries in SQL. How can I select the smaller of the two and return it as a value titled PaidForPast? The MIN function works on columns, not variables. 11 Answers 11
I wrote a T-SQL Statement similar like this (the original one looks different but I want to give an easy example here): SELECT first_name + CASE last_name WHEN null THEN ‘Max’ ELSE ‘Peter’ END AS Name FROM dbo.person This Statement does not have any syntax errors but the case-clause always chooses the ELSE-part – also … Read more
I would like to replace (or remove) a newline character in a TSQL-string. Any Ideas? The obvious REPLACE(@string, CHAR(13), ”) just won’t do it… 13 Answers 13 Actually a new line in a SQL command or script string can be any of CR, LF or CR+LF. To get them all, you need something like this: … Read more
Scenario: Let’s say I have two tables, TableA and TableB. TableB’s primary key is a single column (BId), and is a foreign key column in TableA. In my situation, I want to remove all rows in TableA that are linked with specific rows in TableB: Can I do that through joins? Delete all rows that … Read more
