Topics
Started by
Posts
Last post
Hi everyone My SQL query is close to 1000 lines with 17 separate calcs (ie sub-queries). The enti…
25 replies
Ok, need someone to talk me off the cursor ledge on this one. I have some train stop data that I ne…
10 replies
Apologies for the title, I'll explain more clearly. I have two tables and each has a trigger applie…
5 replies
I've noticed in one of our applications a cursor uses operation 40 and that operation is very slow.…
1 replies
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/ or low…
8 replies
Hi, I am looking for some help with two queries using the following table/data. It would be great t…
7 replies
I have established a Service Broker configuration based on Eitan Blumin's excellent example. https:…
6 replies
By: andyewx
Short story, I needed to convert a table insert/update trigger to a Service Broker task. That's not…
2 replies
I am trying to find an easy way to vertically arrange numerous columns in a select statement using …
11 replies
Hello, I have a situation. I am trying to show each distinct event category, event …
4 replies
Hello, I am working on one of the SQL Logic, i need help to build core logic to do the rest, below …
4 replies
I have an SSIS package which uses SQL Server Configurations. This uses an expression-based, project…
1 replies
Hi all, I'm wondering if someone can help me with this, I have a table (very simple) CREATE TABLE […
2 replies
Hello All, Below is the my existing table structure from which I need to insert records to a ne…
7 replies
We recently migrated our SQL platform from a server running SQL 2016 to a new one running SQL 2019.…
3 replies
Viewing 15 topics - 1 through 15 (of 1,361 total)
You must be logged in to create new topics.