Topics
Started by
Posts
Last post
I need to change the numeric format into 'AM/PM' format in CONCAT function (I use SSMS v 18.5.1) He…
8 replies
I'm writing a view that is expressing cumulative data between a parent table and child table where …
2 replies
Does DTC estimate cardinality when Joining tables from 2 different servers so that the work is even…
1 replies
I am attempting to run a simple Powershell command through SSIS. The caveat is that I am using Posh…
3 replies
HI All I have a huge table with 20M records with around 70 columns. I need to check if a combinatio…
3 replies
Hi there I am trying to reference a table in dynamic sql using a CTE Now this code works outside of…
5 replies
Hi Expert, I am expecting enddate column from startdate -1 CREATE TABLE [dbo].[Table3]( [Testid] [n…
11 replies
Hi there I was wondering if anyone knew of debugging toools that work with SQL Server Express 2019 …
5 replies
Good day In my current contract, I have been tasked with writing queries to extract data from an au…
6 replies
I have the following declare @X nvarchar(max) set @X='[ { "a": "", "b": "", "c": "", "e": ""…
5 replies
I maintain a database of medical claims for about a dozen clients. The vast majority of my tables …
6 replies
Grouping by date? Am I missing something? 2020-08-03 13:21 = 1 2020-08-03 14:45 = 2 &…
2 replies
Hi Experts, Please may I know how to fix this? I tired this COALESCE( R.VendorName, T.ContractorNam…
3 replies
I'd like to take this XML sample <Root> <M-Introduction to school> <m1>…
14 replies
I have such a situation. I need to create a subquery and set to Type = 1. While I have a left join …
1 replies
Viewing 15 topics - 1,006 through 1,020 (of 1,816 total)
You must be logged in to create new topics.