Topics
Started by
Posts
Last post
as it was said in the title, which we should pay attention to when optimizing insert?delete?update …
7 replies
I want to test a condition during an insert or an update and only permit the insert or update if th…
5 replies
Hi, I have a query as below: ;With P As (Select ProductID --Query that returns around 600 rows ) S…
11 replies
I use one table (call first table) field's value to update another another table (call second table…
11 replies
I have two tables called SubAccounts and AccountCategories. Table definitions are as follows: CREAT…
2 replies
I'm not sure why my other topic was removed (maybe too much code in the post) so I'll try again. I …
3 replies
select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus from msd…
1 replies
Good day, I need some advice about cursors: SP1 SP2 …
7 replies
Can someone tell me why the code below returns 5.0 instead of 5.2 please? declare @age decimal(10,1…
5 replies
I found a pair of two identical indexes, containing the same column - one is clustered primary key…
5 replies
Hi, I found the code below SELECT STUFF( (SELECT CHAR(13),CONCAT(tel_type.Name, ': ', tel.[Phone Nu…
12 replies
Hello, Sorry I couldn't think if a descriptive title. I found this on the internet and really it wo…
16 replies
Hi, I'm using a recursive CTE to build a family tree. All works fine but instead of having a row fo…
4 replies
Hi everyone, Working with a stored procedure that is used in an application of ours. This procedure…
9 replies
Hi, I am reviewing some code that runs in 26 sec but I think it's poorly written. I have provided …
1 replies
Viewing 15 topics - 286 through 300 (of 3,067 total)
You must be logged in to create new topics.