All Questions
Tagged with t-sql not sql-server
47 questions
4
votes
1
answer
73
views
Better Microsoft SQL update
I've got the following SQL that I need to update by adding a new parameter:
...
- 328
2
votes
1
answer
74
views
SEDE query to count questions, views and unanswered for a set of tags
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 ...
- 645
5
votes
0
answers
78
views
Message-free flow-oriented logger
Today, I've got a small FlowLogger 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:
<...
- 44.7k
3
votes
0
answers
49
views
SEDE query calculating user reputation averages
I've created the following SEDE query which calculates the reputation averages of users on a particular site. It also optionally excludes "new" users (users with rep of 1 or 101 so note 100% ...
- 623
1
vote
1
answer
71
views
MSSQL database structure and stored procedure performance
I build database called MessageBoard and created StoredProcedure GetHomeView that return data for HomeView. I am completely new ...
- 19
2
votes
2
answers
429
views
Build WHERE clause for search conditions [closed]
Here is a set of classes that are used to build where clause for SQL Server and Oracle for different field types e.g. text, <...
- 257
1
vote
2
answers
132
views
Combining two queries in one
What I want is getting all names (first, middle, last) of the users along with each of their total hours of work which will be calculated by the SQL statement: ...
4
votes
1
answer
263
views
SQL query to count loans issued during each week
Calculate the number of loans issued by the Regional offices for each business week in the period from 38 to 40 business week of 2011 inclusive. Sort by name of the regional unit, business week.
...
- 193
1
vote
1
answer
159
views
Initialize various commands for the SqlDataAdapter
This is my code for my SqlDataAdapter which is similar to the code example given in the docs:
...
- 245
0
votes
1
answer
96
views
Filtering query by date built from integers
I am trying to make a stored procedure and pass some parameters for filtering. As soon as filtering is in horizon, code has to be as generic as possible with as few as possible ...
- 286
4
votes
0
answers
82
views
Insert a page definition in the right order
I have a table SlideList that defines all available slides that can be put into a PowerPoint presentation. I have a table ...
- 1,300
4
votes
2
answers
142
views
Simple locale loader
I have a class that loads locales from a database. I'm not sure if locale is the right word. It's basically loading texts for a game, generic sayings like alerts and error messages.
I'm also not sure ...
- 1,355
3
votes
1
answer
97
views
Simple script to insert data
This is a simple script which inserts data into a couple of tables. I'm very new to SQL so any feeback, of any kind, would be much appreciated!
...
- 341
4
votes
1
answer
48
views
Parse numbers from text based on relative position to certain substrings
The input is a product code. I want to pull out the "percentage" portion of that code. For example, if the code contains the substring BIO, I want all the numbers that follow it until I hit another ...
- 468
2
votes
3
answers
122
views
