Say I create a DateTimeOffset value like this: var dt = DateTimeOffset.UtcNow; And I want to store this value in SQL Server using EF Core code-first. How do I
I am trying to do a 12 month rolling calculation, but I get a syntax error at "rows", here is what I have so far: (SUM(YTDValue) OVER (ORDER BY PerformanceDate
I need to create a VIEW/Select statement that will take a start date, and create 3 different rows for each date. One row calculates 30 days, from the start date
I am working on a query that tries to count from an exact date to an exact date. Today is 2/16/2022. Between 6/30/2020 and 2/16/2022 19 months have gone by. My
I am auditing values in 2 identical structure tables. The T-SQL EXCEPT statement is ignoring the trailing space on a value in one table, so the values don't mat
I'm looking for how to track changes from a view in MS Sql-Server 2012. And, the role of the log-in user is Public. So, it's hard to do it. For example, Assumi
Like the below trigger but I need to add update insert and delete all three. for update trigger columns dynamically getting is not able to code CREATE TRIGGER d
WCF service returns timeout error as below. The request channel timed out while waiting for a reply after XX:XX: XX increases the send timeout value on binding.
I have two physical tables: notTempBaseLine with 50k records (index on Version, SrcDimension2_) notTempTrans with 400k records (index on BaseLineVersion, Dimens
VS2017, Deploy to SS2016. Package runs without any errors from VS. Project deployment to a server that previously had package deployments only - we're moving to
Is it possible to define an array in the vars section and use it inside the SQL syntax of a model? Something like this dbt_project.yml: vars: active_country_c
I'm looking for a way to speed up the following process: I have a SSIS package that loads data from Excel files on a weekly basis to SQL Server. There are 3 fi
I have a pipeline that copies data from source (dynamics) to SQL server datawarehouse. There is a ForEach activity which iterates over the list of all the table
I am trying to import a SQL Server database into prisma using to prisma db pull command. I created a new DB user with proper rights (that I can log in to SQL Se
I'm new to SQL Database C# projects and I have a problem with connecting to my database in a windows form application which is a single user app and I want to u
I worked on a screen from which we can save the backup directory (C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Backup) to be able to perform
I have a very simple query that looks like this SELECT Username ,FORMAT(Timestamp, 'MM/dd/yyyy') as Date ,FORMAT(Timestamp, 'hh:mm tt') as Time FROM
I took a backup of the database on a disk from a server that I do not have online access to. Trying to restore the database on my local machine using: RESTORE
How do I send output from a database query executed in mssql-cli (the Microsoft SQL command line interface application) on a Linux machine to a text file on tha
I am working on an SSRS report and a part of my sql query is like WHERE SuperVisorId IN (@SupervisorIDs) AND CreatedDate> @StartDate where the @SupervisorID