SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Pivot in multiple inner joins

  this is my query, which gives me the complains details SELECT * FROM CI_TD_ENTRY TE INNER JOIN CI_T…

  aznabeel

  3 replies

  5 years, 5 months ago

  By: drew.allen

• Unix Timestamp to Datetime Conversion

  Hi, I have a table with one of the column [last seen] nvarchar datatype and data imported from .csv…

  vamshi.sql

  1 replies

  5 years, 5 months ago

  By: Neil Burton

• Help with SQL query

  Hi Guys, Here is my "Sample" source data. ID,DKey,SKey,InvType ,PID,PAmount,CAmount,AAmount 1 ,123 …

  rocky_498

  2 replies

  5 years, 5 months ago

  By: Steve Collins

• group by ignore null value

  Hi, I am not actually a programming but my job did need to write a bit of sql queries. Hope someone…

  hpares

  2 replies

  5 years, 5 months ago

  By: Grant Fritchey

• Theoretical Question regarding Orphaned data in a Parent-Child table Relation

  I am providing DDL to re-create the parent and child tables involved and the DDL is a representatio…

  YSLGuru

  16 replies

  5 years, 5 months ago

  By: YSLGuru

• How to Select Headers dynamically from another table

  Hi, From the following script, I am able to choose one column rows from #TableB to columns Headers …

  Sangeeth Raj

  4 replies

  5 years, 5 months ago

  By: Grant Fritchey

• Understanding global variables

  On some website, I came across this: "Global variable names begin with a @@ prefix. You do not need…

  michael.leach2015

  3 replies

  5 years, 5 months ago

  By: Grant Fritchey

• Difference between a command and a statement

  What is the difference between a command and a statement? Also, what is the difference between a ba…

  michael.leach2015

  1 replies

  5 years, 5 months ago

  By: Grant Fritchey

• Transactions Committed vs. Uncommitted Data

  I am trying to understand how committed data works in a transaction.  I have 4 screenshots attached…

  michael.leach2015

  2 replies

  5 years, 5 months ago

  By: michael.leach2015

• Trigger for Update

  Hi,   I am working on update trigger. Whenever the json value is changed for the latest date t…

  Papil

  1 replies

  5 years, 5 months ago

  By: Papil

• Explicit Transaction not working

  I am testing how to use explicit transactions.  In my table, there is no employee with an ID of 200…

  michael.leach2015

  3 replies

  5 years, 5 months ago

  By: michael.leach2015

• Need Help

  I want to get output as X hours and x minutes ( 1 hours and 30 minutes) how do I get output from be…

  Nita Reddy

  2 replies

  5 years, 5 months ago

  By: Nita Reddy

• Does TSQL support natural and EQUI joins?

  I am trying to find some information on this, but it seems like TSQL doesn't support natural joins …

  michael.leach2015

  1 replies

  5 years, 5 months ago

  By: Michael L John

• SQL to present data in parallel

  Hi there, I have a sql question wondering your sql expertise. My data as follows pasted in the scre…

  Data9

  1 replies

  5 years, 5 months ago

  By: Jo Pattyn

• Using SUM and Distinct in innner join

  Table - CI_BSEG_READ Table -  CI_BSEG_SQ I want to sum the  MSR_QTY where BSEG ID is same in "CI_…

  aznabeel

  1 replies

  5 years, 5 months ago

  By: Ant-Green