Topics
Started by
Posts
Last post
Hi, Is there a reason that the following query doesn't error? select * from sys.objects where paren…
3 replies
I have this query to create a summary of donations SELECT [DonorId], SUM([DonationAmount]) AS Total…
5 replies
Hi there I have the following string which is comma seperated but within each item, they are sepera…
7 replies
I'm using an CLR which I've used plenty of times in the past and have running fine on SQL 2017. I'v…
2 replies
I am trying to return all values from the lookup table to columns on the same row for the Diagnosis…
7 replies
Hi, As I'm developing for client that require show all information in same row to ID. For example t…
3 replies
Hello comunity, recently I needed to create a trigger in SQL for Insert, update and delete and I us…
2 replies
I have two CTEs. From one UDT_CKB_SNAPSHOT I am taking Event Names, from the 2nd CTE called …
2 replies
Hi I have table that I want to make sub tables for. Below is an example of how it would work. Cons…
9 replies
Hello, Currently have a stored procedure that processes an XML Doc stored in a table. Uses: EXEC sp…
7 replies
I have a table like below, I would reset the values in the table with some fake addresses. I have a…
7 replies
I have such a situation. I have a table UDT_CKB_SNAPSHOT where we have different events (promotions…
1 replies
I have a 120gig database. I want to analyse it with Power BI. (It's way to Large) This is data from…
3 replies
Hi everyone I have two stored procedures that update two tables. If one of the updates fails then …
8 replies
I would like to extract a street address to separate columns. For example, I have street fake data …
3 replies
Viewing 15 topics - 1,021 through 1,035 (of 1,800 total)
You must be logged in to create new topics.