The t-sql tag has no wiki summary.
1
vote
1answer
45 views
Generic PHP function for making a struct out of multiple resultsets from a stored procedure call
The stored procedures must return their first resultset in the form:
(
[index] int,
[id] varchar(50)
)
where
[index] is 0,1,2,3,... and
[id] is the name of the struct.
As long as ...
0
votes
1answer
62 views
Data Structure for Categories and SubCategories
I have this relationship:
Many Objects to One Category
One Category to Many SubCategories
I am looking for the best way to store this in my Relational Database? Here were some of the ways I was ...
3
votes
1answer
123 views
Getting rows from several tables where one table doesn't include the rows from the next tables
I have some entity that is spread across three tables.
I have to get in a single result the following values:
All the values that are in the first table but not on the second nor the third.
All ...
5
votes
1answer
152 views
Conditional Create: must be the only statement in the batch
I only want to create this SQL function if the dependent Assembly exists.
I can do it using dynamic SQL, but it seems messy and I lose syntax checking (in
management studio). This function's ...
1
vote
1answer
104 views
List of students with their classname in current year
I have 3 tables: students and classes and years. In a forth table called StudentsInClass, I'm saving students classes in each year . Now I want to show a list of students with their className in ...
2
votes
1answer
94 views
Refactor my simple SQL Statement
I have the following SQL statement that I think could be improved in areas (I believe there may be a way to use where over having, but I'm not sure how and I'm sure there's a way to reference the last ...
3
votes
1answer
57 views
output parameter and exists condition
I want to return title of a record if exists or the word 'invalid' if not.
@ID int ,
@Title nvarchar(50) output
...
if exists(select * from MyTable where ID=@ID)
select @Title = ...
1
vote
1answer
100 views
query to get number of related records in 2 child tables
I have a category table ( brands ) and 2 other tables ( Pens and pencils ) that have parent-child relation with this table through a field "CatID" . now I want to get a list of Brands and number of ...
2
votes
1answer
62 views
Critique my SQL
Table Structure
ApprovalOrder int
EntityCode varchar
CostCentre varchar
DelegationCode varchar
ProjectCode varchar
RoleGroup varchar
Position varchar
...
1
vote
3answers
148 views
How can I improve this sorting algorithm?
I have a table in a SQL Server database, which holds information of some images, and the relevant gallery of them. The columns are like:
ImageId, GalleryId, Order
I have a unique key on ...
1
vote
2answers
115 views
SQL - Refactoring - How can this be done better?
I've been working on a semi-awkward query in that it uses a very high number of functions given its relatively small size and scope. I was hoping to get some feedback on any ways I could format or ...
2
votes
2answers
154 views
SQL - How's my formatting?
I'm somewhat new to SQL (using it in the past but only being exposed to it heavily in my current role). Unfortunately nobody at my current company has really given me any advice on formatting. How can ...
4
votes
4answers
149 views
I'm looking for comments (good or bad) and suggestions (good only) on a T-SQL statement to breakdown UserAgent information
I have a table that contains the UserAgent string and a Count of how many times its seen. the T-SQL below is used to give a breakdown of what browsers are seen and how often then are seen.
SELECT
...
3
votes
4answers
152 views
T-SQL transaction
Can someone help me refactor this code so in case of an error nothing gets persisted to the db? this doesn't work when an error occurs.
use mydb
Begin Transaction
SET IDENTITY_INSERT table1 On
...
1
vote
0answers
160 views
TSQL - Insert into “TableA” from “TableB” if “TableA” doesn't have “TableB” row
I'm trying to improve a query that i'm using on a project. I'm going to show an example of the tables simplified:
TBL_FORMATION: a table for formations
TBL_TEAM: a table with the information for ...
