Topics
Started by
Posts
Last post
I'm trying to write a query to calculate my inventory ageing but am struggling to get it to work. A…
4 replies
I have inherited a DB where a specific report is created using a view, which in turn calls a functi…
5 replies
Hi Team, I have data like below. CREATE TABLE #Table(osid INT,Date &nbs…
9 replies
In dbo.sysjobhistory table, we get list of all the jobs and step execution history. But how do we g…
3 replies
I am working on a function to remove/ replace special characters from a string from a column named …
1 replies
HiThis is all very new to me but despite trying to search, I am not sure what I am even asking to b…
5 replies
Hello everyone… I have an interesting problem and, while I can think of a couple of horrible…
5 replies
Two tables each with 6.4 million records in SQL Server 2012. Let's say A and B. I have to join two …
3 replies
Here is the basic schema of tableCREATE TABLE Test (ID INT, ProductCode VARCHAR(50), Quantity INT) …
7 replies
In a nutshell, my goal is to transfer encrypted string of messages between one SQL Server database …
3 replies
Hi,We have an integration query running at 5am - simple view on 3 tables (2 tables have 4-6m rows) …
9 replies
Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8…
32 replies
Hi all, I have a question , I was trying to get a result based on 2 different conditions that I hav…
3 replies
If a database table does not have a last modified date time column is there a way to determine…
2 replies
sir , i am stuck in one problem . USING LAG() AND LEAD() FUNCTIONStrying to filter the data as per …
9 replies
Viewing 15 topics - 1,021 through 1,035 (of 4,984 total)
You must be logged in to create new topics.