Topics
Started by
Posts
Last post
I have the following request and I'm not sure how to achieve it SQL. Let's say we have three tables…
11 replies
Good afternoon all, Hopefully you can help, I will admit firstly however that I know barely nothing…
9 replies
i have table please see the screen shot I want the CHAR_TYPE_CD "CNSMP " which ever is the l…
5 replies
Hello, I have this loop which creates a bunch of matrices based on the month_nbr (in this case 1-36…
7 replies
this is my query, which gives me the complains details SELECT * FROM CI_TD_ENTRY TE INNER JOIN CI_T…
3 replies
Hi, I have a table with one of the column [last seen] nvarchar datatype and data imported from .csv…
1 replies
Hi Guys, Here is my "Sample" source data. ID,DKey,SKey,InvType ,PID,PAmount,CAmount,AAmount 1 ,123 …
2 replies
Hi, I am not actually a programming but my job did need to write a bit of sql queries. Hope someone…
2 replies
I am providing DDL to re-create the parent and child tables involved and the DDL is a representatio…
16 replies
Hi, From the following script, I am able to choose one column rows from #TableB to columns Headers …
4 replies
On some website, I came across this: "Global variable names begin with a @@ prefix. You do not need…
3 replies
What is the difference between a command and a statement? Also, what is the difference between a ba…
1 replies
I am trying to understand how committed data works in a transaction. I have 4 screenshots attached…
2 replies
Hi, I am working on update trigger. Whenever the json value is changed for the latest date t…
1 replies
I am testing how to use explicit transactions. In my table, there is no employee with an ID of 200…
3 replies
Viewing 15 topics - 1,741 through 1,755 (of 1,784 total)
You must be logged in to create new topics.