Topics
Started by
Posts
Last post
Compose a SQL query to retrieve all products with its most recent two orders? Products that haven’t…
9 replies
Hello, On SQL Server 2017 I have an indexed view with aggregation referencing two tables (inner joi…
8 replies
I need to once in a while replace a string of about 200 characters in each text file (~ 2 Mb each) …
7 replies
Thanks. This topic was modified 5 years, 8 months ago by smattiko83.
2 replies
I have to import a text file to build a table and all of the date fields currently are in integer f…
7 replies
Hi, I might be asking too much here (in terms of code) but I need to find duplicates but dynamicall…
16 replies
I am doing a POC on something performance analysis related, and i need to demo a very heavy resourc…
9 replies
This is a bit of an odd one for me.. I have a query that returns: Response_ID UNIQUEIDENTIFIER, Ali…
6 replies
Good Morning everyone, I'm attempting to Merge a couple of stored procedures into one. I need to b…
8 replies
Hi. I was wanting to know how do I save an import query in SQL Server Management Studio v18.4 so th…
1 replies
Dear Experts I am trying to merge two Dimensions (from a DWH) into a new one. I think I've figured …
2 replies
At work, I am often asked to do some queries for a vendor database, for example to generate some cs…
4 replies
Hi, I have a small business which uses Zoho recruit- its a kind of CRM / database for recruitment i…
15 replies
Hi SSC, I have the following Function CREATE FUNCTION [dbo].[fCompareDO] ( @DealerNew IN…
8 replies
Hi, I am trying to update the Type column to NULL when the following column value matches-id,age,ca…
4 replies
Viewing 15 topics - 616 through 630 (of 1,544 total)
You must be logged in to create new topics.