Recent questions tagged Sqlsql-server

0 votes

Q: T-SQL: join columns & indicate type i other column

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 7, 2022 in Education by JackTerrance

0 votes

Q: Query times out from web app but runs fine from management studio

This is a question I asked on another forum which received some decent answers, but I wanted to see ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 24, 2022 in Education by JackTerrance

0 votes

Q: View Temporary Table Created from Stored Procedure

I have a stored procedure in SQL 2005. The Stored Procedure is actually creating temporary tables in the ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 19, 2022 in Education by JackTerrance

0 votes

Q: View Temporary Table Created from Stored Procedure

I have a stored procedure in SQL 2005. The Stored Procedure is actually creating temporary tables in the ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 18, 2022 in Education by JackTerrance

0 votes

Q: View Temporary Table Created from Stored Procedure

I have a stored procedure in SQL 2005. The Stored Procedure is actually creating temporary tables in the ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 18, 2022 in Education by JackTerrance

0 votes

Q: Find two consecutive rows

I'm trying to write a query that will pull back the two most recent rows from the Bill table ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 17, 2022 in Education by JackTerrance

0 votes

Q: AVG and COUNT in SQL Server

I have a rating system in which any person may review other. Each person can be judged by one person more than once. For the ... SQL? Person 1 rates Person 2 with 5 on 1.2.2011...

asked Feb 21, 2022 in Education by JackTerrance

0 votes

Q: AVG and COUNT in SQL Server

I have a rating system in which any person may review other. Each person can be judged by one person more than once. For the ... SQL? Person 1 rates Person 2 with 5 on 1.2.2011...

asked Feb 18, 2022 in Education by JackTerrance

0 votes

Q: add +- 1 year in SQL Server

I try to select the Products that has a yearmodel between +1 and -1 the current year. And I only ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Feb 16, 2022 in Education by JackTerrance

0 votes

Q: add +- 1 year in SQL Server

I try to select the Products that has a yearmodel between +1 and -1 the current year. And I only ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Feb 16, 2022 in Education by JackTerrance