I need to find customers that have a sum of credit transactions greater than or equal to a threshold amount and a sum of debit transactions less than or equal to the inverse of that same threshold amount. I also want to return the transactions whose aggregate transaction amount satisfies the credit and debit …
Tag: sql-server
Did this SQL update statement delete records? [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 2 years ago. Improve this question I ran an update statement like this, last night. where it is joining local…
Filter a case in a where clause
I want to filter on a case statement in my where clause for example: Select name, address, case when code in (50000-8113, 512388-8114) then ‘M345’ else ‘N/A’ end as Mucode Where mucode = ‘…
Arabic text in sp_sqlexec insert return question mark
Records are imported into table #FileRecords and ##TableInsert are dynamic tables, it can be table A, table B(which justify the reason of using exec sp_sqlexec). When Arabic wording going through sp_sqlexec, it will insert ??? instead of the Arabic wording. Is there anything I am not aware of, beside of encod…
Use multiple but identical aggregate function
I’m trying to use two identical aggregate function is SQL Server, where I use COUNT(A) with some condition and COUNT(A) with another condition. For example I want to count all students enrolled in the course ABC, and the second count I want to count all students who have grade A and have enrolled in the…
Microsoft SMSS – Joining tables on t2.primary key = t1.foreign_key
I need to join two tables together to create a table with columns for employee id, employee name and their boss’ name. The ‘hier’ table The ’employees’ table The query I wrote is almost working, putting an employee name in the right spot, but not the right employee: Which outputs…
Returning Records by Week
I’m trying to come up with a way to return a result set from the below data without a loop that shows the number of records by Team for a particular date range by week. I’ve got a Date table (https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/) th…
Get all dates of a Year based on Day Name [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 1 year ago. Improve this question I want to take all Dates of an year based on Day Name. For example If I pas…
SQL Server – Add a linked server to AWS RDS instance
From this AWS link it explains how to add a linked server: https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/ Specifically these commands The main problem is it seems to be a mix of ‘, `, and ” I get syntax errors, and I assume that’s why…
SQL agent job creation error: Job ‘XXX’ is already targeted at server ‘YYY’
I am trying to create and SQL agent job on SQL Server 2016. Here is the use of sp_add_job. EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N’TEST_RUN_A_JOB_STEP’, @enabled=1, @…