Please suggest practice on SQL Server RLS
On the database level, defined users with different permi…
5 months, 3 weeks ago
I have a simple question: having a table where I have multiple orders for any number of ven…
By: Jeff Moden
I want to align a Date column (datetime2(7)) with the same full resolution date of SysStartTime col…
By: Ken McKelvey
I have two table called TableA and TableB. Here I need to match the TableB records from Tab…
By: Dennis Jensen
I am importing from a csv file into a table.
Everything works fine.
One filed is im…
Hope this message finds you well
I am now moving into a Master Data position and my experien…
5 months, 4 weeks ago
I have the column of data in SQL Server. Here I need to group the letters of first word i…
6 months ago
I want to extract the string before and after the given characters.
This is the Data
ID ----- Date From ------ Date To -------
2 ----- 2020-01-01 ----- 20…
6 months, 1 week ago
Is there a performance difference between a unique clustered index and a primary key clustered inde…
How could I partially match the columns from two different table. I have attached the excel…
I'm working on a Holiday Leave system (for typically several hundred or more personnel). Currentl…
I want to rewrite the below query using the Case and When statement
We have a SQL project to be deployed to an Azure SQL server. We are looking for s specific …
6 months, 2 weeks ago
I want to extract first two words from the string. Example
ABC Property Management Inc.
Viewing 15 topics - 61 through 75 (of 116 total)
You must be logged in to create new topics.