Topics
Started by
Posts
Last post
I have a Calendar table that need to be displaying Fiscal Start and End Date as in below: The Cale…
4 replies
Hi I have 2 tables Table A JoiningID, MainID 1010619, 646703 991840, 238649 991840, 577578 991840, …
17 replies
I have a table that contains data only to Financial Year/FY 2024: CREATE TABLE [Prod].[IMETA - Cale…
8 replies
I have a scalar function used on a sql server 2016. I have created a database role using the user l…
5 replies
How to optimize below Query, Could you Please guide me. SELECT selected_sfs.sfName…
7 replies
Don't know if this is the right place for this topic. I have an internal azure sql server managed i…
2 replies
Hi All, I have a data in column A in where in need to achieve the count which I have mentioned in c…
6 replies
I am working on a small test script on SQL server 2022 using python module. The module does the s…
4 replies
select Colum1 , Colum2 from table 1 Union All select Colum1 , Colum2 from table 2 Union All…
6 replies
i got the login failed error for user sa, but not always so I went to server properties - security …
2 replies
Hello, we are migrating our SQL Server database and one of the tasks is to stop using Filestream. …
29 replies
CASE WHEN ( Table1.Column IN (@Parameter1) OR b.cat3 = 1 OR (Table1.Column='XXXX' AND SV.Column IN …
1 replies
(SELECT Column1 FROM Table1) as --5 Table1_1 ON table3.Column1 = Table1_1.Column1 LEFT JOIN (SELE…
2 replies
Good Morning, how to assign query one results to query 2 student id, each record should have…
8 replies
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and Pre requisites…
4 replies
Viewing 15 topics - 61 through 75 (of 308 total)
You must be logged in to create new topics.