Custom Job schedule - every first Friday after 15 of the month - is it possible?
Good morning, Is it possible to create a job that runs only on first Friday after 15th of each month? I'm trying the following but the option seems to imply it would run every 15th month, not on the first Friday after day 15th:
Temp file not shrinking
I have a temp DB file that is not shrinking. Temp DB has 6 mdf files but one is large and not shrinking after multiple attempts. Any idea on how to resolve this? Thanks
SQL Statement taking long to execute
I have two SQL Databases that is on the same SQL server but on one database it only takes 4 seconds to complete the SQL statement but on the other SQL database it takes 25 minutes to complete. Both databases uses the same SQL elastic pool and I don't see…
How to create 12-months projection query in SQL
Hi Team, Have requirement as bellow, need to write query to get next 12 months projection data include current month. Could you please help me. Please find-out bellow example input outputs. SQL QUERY: CREATE TABLE [dbo].[Projection]( [YearMonth]…
Transaction replication is getting failed for creating snapshot with message as "Prefetch objects failed for Database"
This issue "Message: Prefetch objects failed for Database " has been happening everytime I run the snapshot after 96% completed I was getting this issue (I need to wait for 5 hours for this). What ever .bcp files got created in storage account…
Error the datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large.
i work on sql server 2019 i face issue when run query to get queries run on server i get error Msg 535, Level 16, State 0, Line 1 The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too…
How to figure out the total number of doses within a time span given to a client as dose are being added and stopped.?
If the cadence values are different, even if the dates overlap the records must be separate. If an order for the same dose and cadence value (including nulls) starts on the same day or the next day (+or-1 day) the record should continue. outlook of…
unable to convert unique identifier
Hi Team, unable to convert this value as an unique identifier and getting null values SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid
left and right join
Hi, table 1 Table 2 select A.* from table1a LEFT join table2 b on a.col1=b.col1 output: which is correct but on right join it shows above results how to calculate this join and how it will react on NULL and blank
Select alternate rows basis on pattern.
I have a table like below I want the result like below Please help on this. Thanks in advance.
SQL with bunch of or clauses
Trying to get the result with a bunch of or clauses. SELECT * FROM SA15B WHERE PoNo In…
SSIS : Decimal Places not loading from Excel Source to SQL table
Hi Team - I have an excel file with few columns but the issue is with one of the column, Lets say Column A. Column A : FY20 Work Extra Feb 4 4,401,0089 3,81,68182.01 27,381.59 - 42590062.77 99.8% Few of the numeric values above are rounding off in…
updare dateid in table
HI, Hw to update date datatype into integer column to varchar column create table table1(dateid date,dateid1 int,dateid2 varchar(23) ) dateid --------------------- dateid1 -------------dateid2 2024-01-01…
email not been send to all in the ssrs report subscription
HI there I have a very bizarre situation in production environment of my work space where not all of the emails are been sent when the ssrs report is been published to go out. For example i have three emails(not real emails) like…
Error while installing SQL Server 2022(Express Edition)
Kindly need help with SQL 2022 installation process. This is my summary.txt file, Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068774911 Exit facility code: …
Cannot insert the value NULL into column and column does not allow nulls
HI Team i have build a physical table with some columns, where i have an identity column in my table [ProdID] [int] IDENTITY(1,1) NOT NULL I am trying to insert the records into this prod table using the destination table values ,insert fails…
unique column in table
HI, merging table1 in table2 merge into table2 using table1 on table.col1=table2.col1 when not match then insert how to add unique column with auto increament number and not null in table like uniquenumner; Name;' 001 Test1 003 …
Training database PUBS
Dear friends, I'm looking for a description of the tables and fields of the Pubs training database. Can you help me please? Thank you very much, Anna
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Sporadic INSERT EXEC failed because the stored procedure altered the schema of the target table
Hi everybody, We're getting this error sporadically. The outer stored procedure has a table variable and it also has a temporary table called #Results which is used to hold results of another stored procedure, e.g. DROP TABLE IF EXISTS…