Movatterモバイル変換

[0]ホーム
URL:

Sorry, we no longer support your browser
Please upgrade toMicrosoft Edge,Google Chrome, orFirefox. Learn more about ourbrowser support.
Skip to main content

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities includingStack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Loading…
Code Review

Questions tagged [t-sql]

Ask Question

Transact-SQL (TSQL) is the extended SQL dialect used in Microsoft SQL Server and Sybase. Please also tag with either [sql-server] or [sybase].

222 questions
Filter by
Sorted by
Tagged with
4votes
1answer
73views

I've got the following SQL that I need to update by adding a new parameter:...
jp2code's user avatar
1vote
1answer
50views

dbfiddleGoalWithout repetition in the code, I want to filterBikeValuationList to only give theBikePriceId of the latest ...
J. Mini's user avatar
3votes
2answers
136views

I have a transaction table let's call it Offers Table. Please don't read too much into the business but let's say a customer wants to buy a car and the customer searches variety of websites but at the ...
Cody's user avatar
2votes
1answer
74views

This query selects the number of SO questions, the number of views and the number of unanswered questions for each tag (the list of the tags is the user input). It works fine when it works, but it ...
3votes
1answer
109views

ContextI was proud of this code for a little while, but the repetition wounds me. I know that the function name sucks, but the name and interface to this function are not under my control. ...
J. Mini's user avatar
2votes
2answers
144views

ContextI was proud of this code for a little while, but the repetition wounds me. I know that the function name sucks, but the name and interface to this function are not under my control. ...
J. Mini's user avatar
1vote
1answer
172views

The QuestionWhat is the percentage of customers who increase their closing balance by more than 5%?Source CodeThe database and all details can be found here.ERDMy Proposed Solution...
Mike's user avatar
  • 113
0votes
1answer
138views

I have this stored Procedure that is passed in the data below that will building the SQL select that will get EXEC. The data that can be passed in can me null so I have three ...
Jefferson's user avatar
1vote
1answer
93views

I'm playing with data from a Time Use survey as a beginner SQL user.Gender is represented as 1's (Male) and 2's (Female), and the age of each participant is listed. I would like to divide them into ...
Erik's user avatar
  • 303
0votes
1answer
213views

Given the following example data:idusernamegroupunitdepartmentteamstatus1user1g1u1d1t1active2user2g1u1d1t2active3user3g1u1d1t3inactive4user4g3u6d12t30active5user5...
pileup's user avatar
-2votes
1answer
92views

I'm in need to optimize the following TRANSACT SQL statement :...
Simone Spagna's user avatar
3votes
0answers
62views

I am working on SQL Server I have sample data like this in a table.CustIdBankcityratingdaternk1DeutscheDelhi510/10/202211BOAPune610/10/202221UBSMumbai710/10/202231SBI...
user3580341's user avatar
0votes
1answer
79views

I have transaction tables calledMaterialRequest andMaterialRequestDetails.What I want to check my query and review that it's ...
Basit Sarguroh's user avatar
5votes
0answers
78views

Today, I've got a smallFlowLogger for you to review. The idea is not to log pure messages, but focus on the flow of the app that might contain such items as:<...
0votes
1answer
78views

The problem I have solved is as follows:Consider a table of dogs,DOGGIES, that records on each row theID of a doggy, one ...
J. Mini's user avatar

153050per page
1
2345
…
15

Hot Network Questions

more hot questions
Newest t-sql questions feed
[8]ページ先頭
©2009-2025 Movatter.jp