Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).
3
votes
2answers
67 views
Role-based access control query
I use SQL Server, and though not pertinent here, Railo's CFML engine.
I'm not great at SQL Joins, but I worked through this one and got the result set that I want. This particular SQL will only ever ...
0
votes
2answers
139 views
6
votes
2answers
146 views
Follow up to Top Active Answerers on Stack Exchange site
This is a follow up to Top Active Answerers on a Stack Exchange site
Actual SEDE Query --> Top Active Answerers on site
Do I have a good understanding of the ...
3
votes
2answers
259 views
Top Active Answerers on a Stack Exchange site
I created this query back in January to find the top active answerers on Code Review and thought that it might be a good idea to get other opinions on my SQL coding using a database that we can all ...
3
votes
1answer
24 views
SQL update statement
I have a SQL update statement which does what it's supposed to. However, I have a feeling that the way I wrote it isn't the best. I am not highly experienced in SQL so any pointers or hints on how can ...
2
votes
3answers
198 views
Rewriting SQL IN statement with long list of parameters
These IDs seem like they should be a table as, there are several queries that use the same list of IDs. The following needs to be refactored.
...
7
votes
2answers
90 views
Query for your Answer Progress
I was inspired to write a query that produced a graph mapping the perceived quality of your Stack Exchange answers over time.... in other words, "Are your answers getting better, or worse?"
Because ...
3
votes
1answer
33 views
Basic T-SQL to compare two same length strings
I've come up with the following T-SQL to compare similar same length strings.
Example usage would be:
OCR returns a value which is expected to be in the database.
PATINDEX is used to check the ...
3
votes
1answer
56 views
Query for combining two SELECTs to get active users and 1 inactive user
What this query does:
Gets multiple users with the first select in the union; those are the active users.
But when a user is ...
2
votes
1answer
21 views
Optimizing sales report stored procedure
I need to optimize the following stored proc. Please let me know of any techniques or modifications that I can make to optimize this piece of code.
The procedure is for a report that needs to run ...
5
votes
2answers
63 views
DateTime internal representation to FILETIME
Here is a routine I put together to convert SQL Server's internal DateTime representation (BINARY(8)) to a ...
1
vote
1answer
30 views
Too many parentheses to format a percentage in SELECT
This query seems to have way too many parentheses.
...
3
votes
1answer
39 views
Monthly change query with SQL Server 2012
I'm new to SQL and working on a monthly change calculation. I want to calculate the change between this months balance and the previous months balance.
This query is working for me but does not ...
3
votes
2answers
98 views
Similar statements need duplication removed
How would you refactor this?
ExpensiveQuery must only run when necessary.
...
4
votes
1answer
67 views
Unduplicated counts over various dimensions
I'm working with some data on college students, which has a unique key of SSN, Campus, ...
3
votes
3answers
264 views
Get and display employee time clock data
I have been making a web page in PHP and JavaScript to take employees clock times and do some things with them so I can display them. Everything is currently working quite well, but the code looks ...
6
votes
5answers
369 views
Transaction handling for multiple SQL statements
In this code I update two tables called Payment and SalaryTrans. First I insert records (Salary payments) to ...
5
votes
3answers
193 views
Legacy Data and Current System Data Merged together in a single SQL Database
There was a lot going on in this Database that I couldn't change, a lot of bad practices because the data was originally being pulled from an old mainframe database and then transformed by a horrible ...
3
votes
2answers
123 views
Efficient way to extract the first row in a Group By group
I have a large Sql Server view with this schema:
[archive_ID] (int, not null)
[archive_date] (datetime, not null)
[archdata_path_ID] (varchar(50), not null)
[archdata_value] (int not null)
I need ...
5
votes
3answers
80 views
Relational schema and query for multiplayer tabletop game
As an exercise, I was asked to design a database schema (for MS SQL Server) for a tabletop game. The requirements were simple: players compete in matches and there are specific match types (e.g. 1v1 ...
2
votes
1answer
32 views
Reusing select statement
I am checking if there are any rows in a table with some conditions. If there are more than 1 row, it should filter again with some more conditions.
...
3
votes
1answer
27 views
Optimize mass import of XML to SQLServer in Ruby
I have the following Ruby code that's designed to update item, price and stock data for items in a MSSQL database. It's running on a Ruby 1.8.6/Rails 1.2.3 installation, in its own controller (for ...
4
votes
2answers
217 views
SQL percentage calculation
I have created a query in which there is a column that calculates a percentage:
...
4
votes
1answer
85 views
Batch of SQL statements in a single query
I'm using the following query for multiple transactions. This is the scenario.
Generate Salary (this is not in the scope of the query)
I have employee attendance in ...
6
votes
2answers
264 views
Multiple SQL statements in a single transaction
Using the following query I'm doing transactions with two tables
...
4
votes
2answers
120 views
Delete from multiple tables using temp table variable
I'm previewing the data I'm about to delete, but this SQL looks a little redundant. Is there a better way to write this?
...
17
votes
1answer
206 views
Executing large SQL script file with GO statements using ADO
I wrote a small component (still in the works but working) which takes a large SQL script file, splits it into different "blocks" based on GO statements, and executes them one by one.
The only major ...
2
votes
1answer
100 views
Is there better way to shorten this Lambda expression's result selector?
I'm new in LINQ and Lambda expression. I'm not sure is there a way to shorten the result on this o.z.cust.cust.cust.bintAccountNo. As you can see below, the more ...
6
votes
3answers
83 views
SQL Stored Procedure Get Distinct and Update
The idea is to show how many times a user (by EmployeeID) is in the TblTableList and then update the ...
12
votes
2answers
326 views
6
votes
3answers
109 views
Sorting three Decimal values
I have been given three values. @lLength, @lWidth, @lHeight. I need to take these ...
10
votes
1answer
73 views
Loading Data Warehouse with Dynamic SQL
For a data warehousing project I ran into the following:
Custom fields that users can create, modify and delete, that should be loaded into the data warehouse as they are when the ETL happens.
On ...
3
votes
1answer
38 views
Printing simple SQL comparsion
I'm comparing two variables which I'd like to be printed to the console like so:
==Full Ex Vat==
true
Currently the code to do this is:
...
2
votes
2answers
43 views
Using Common Table Expression and Outer queries
In following query I'm use both Common Table Expression and Outer queries. Apparently both looks same to me.
If I summarize my requirement, I have employees in ...
5
votes
2answers
62 views
Better way of calculating a time in a time zone from multiple dates in SQL?
I'm trying to calculate what time a certain time in a time zone is today, so I can schedule something to happen at that time in that time zone.
I've got a table with what I have termed the Nominal ...
10
votes
3answers
323 views
Is there any way to speed up this stored procedure?
Is there any way to optimize this stored procedure? Maybe something instead of so many joins?
It takes some time to execute. Maybe there are other options that I could look into?
...
5
votes
1answer
59 views
EF query for calculating monthly trends
My application has a fairly important query that is used in a lot of places. Unfortunately it takes about 14 seconds to run, so I'd like to find a way of possibly improving it.
The application ...
11
votes
2answers
270 views
Find records with duplicate serial number
I was tasked today with cleaning up data from a SSRS report put together by a DB programmer. The original report was to find duplicate serial number sales within a user-defined period of time. I was ...
2
votes
1answer
105 views
7
votes
1answer
220 views
Fluent Nhibernate, is the mapping correct?
I'm very new to NHibernate and DB. I have three tables which are connected with many to many relationship.
Here are the tables creation Script:
...
3
votes
1answer
76 views
Insert an SQL Server Table rows into a Bigquery table in one bloc
I want to insert all rows of an SQL server Table into a Bigquery Table having the same schema.
The streaming insert row by row is very slow: to insert 1000 rows ...
2
votes
2answers
116 views
5
votes
1answer
465 views
Can I populate this table faster?
I have the following SQL query which takes ~3 seconds to run, maybe ~4. This populates a consultants table with their expected payments for the month.
Unfortunately, the page only loads when this ...
2
votes
1answer
200 views
Stored Procedure calculating employee earnings
I have following stored procedure in a C# win forms application which calculates employee earnings based on attendance as follows.
Note that a shift is 12 hours and employees mark attendance for in ...
1
vote
0answers
106 views
Insert all SQL Server table rows in a Google BigQuery Table
I am coding in Coldfusion. I want to know the best way (best performance and reaction time) to insert all rows of an SQL table into a Google Bigquery Table.
Actually I am looping over a query result ...
1
vote
2answers
72 views
Text file searching using SQL
I have the need to search a directory containing 1000+ files on remote servers where I only have access to SQL Server Management Studio and Explorer. I have written the below SQL statement which does ...
6
votes
1answer
112 views
7
votes
2answers
902 views
VB.Net Database Access Class
I've recently been asked to make some emergency changes to a legacy application written in VB.Net. I come from a C# background so am not overly familiar with this language, though there are enough ...
4
votes
1answer
44 views
SEDE query to find users with exactly one post in a particular tag
I'm doing some research for a meta post on Gardening.SE (where I'm a pro tempore moderator). I'm using the Stack Exchange Data Explorer (SEDE) to find information about first time users who post ...
3
votes
2answers
48 views
Calculating percentage of 3 test forms
Please help me to simplify the script below. It has a lot of variables and a lot of values are getting assigned to them. Can I make it simpler?
It has to calculate the percentage of 3 test forms: ...
