Topics
Started by
Posts
Last post
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
I am asking and I am not a 100% sure it is achievable but I will appreciate if someone can help. I …
1 replies
Hi everyone I started another thread on downloading CSV file from web. I have come across a proble…
11 replies
Here is the situation, I want to return the results of the following: A customer may purchase any n…
4 replies
I've got a table with about 60,000 records that contain data that relates to eachother using a Hier…
9 replies
hi everyone My SSIS power query task is broken. Looks like the data provider changed the format fo…
4 replies
Viewing 15 topics - 976 through 990 (of 1,784 total)
You must be logged in to create new topics.