I have a procedure that pushes data from my local SQL Server 2005 database into a table in an Azure DB which is set up as a linked server. The basic data flow is create a #staging table, fill the #...

I have a table dates with a column SENTDATE where each row has a varying number of dates in it, separated by a semi colon (;). The dates are currently in the format YYYYMMDD - for example: 20240529;...

I'm currently working with a stored procedure that executes an INSERT statement using EXEC sp_executesql. The procedure takes several parameters, including @TRANSACTIONNUM, @CUSTOMERNUM, @VALUE, and @...

I want to know how to pass symmetric key to SQL query as parameter. I'm usually hardcoding it within the query as follows: OPEN SYMMETRIC KEY SymKey DECRYPTION BY CERTIFICATE CertiFi; SELECT * FROM ...

I've been given the unenviable task documenting the catalogue ingest process of our data warehouse. All was going well until the end where I came across the use of a conditional split inside of an ...

Values in the column Name_Orig look something like this: **Ang-Stl-A36-6X4X.5**Angle,A36*,4X6X1/2**** I want First occurrence of ** to be replaced by Xx_ Second occurrence of ** to be replaced by a_ ...

Result Set of MSrepl_commands I want to infer that whether its a insert/update/delete command . We need to check at day end the amount of data replicated per article by the transactional replication. ...

This is not just a simple extraction. I have two tables. I take the values from one table and then use one column from this table to find a corresponding value in another table and then extract all ...

When I make a new migration (Add-Migration Example) , and then I try to get all the migrations (Get-Migration) I find that the "applied" field is "True" without even using (Update-...

My table structures are shown here: Table1 Col1 10 20 20 20 30 30 40 Table2 Col1 10 20 30 40 My expected result is this: Col1 Col2 10 Matched 20 Matched 20 Not Matched 20 Not Matched 30 Matched 30 Not ...

Using SQL Server, I have multiple tables: Assignments aID, acID, clientID, userID, pos, dateOn AssignmentCarriers acID, clientID, cName, isAssignment Users userID, fName Clients ...

We are trying to save a DataFrame in SQL Server (V2005) using the following method: df_cards.write.jdbc(url=conn_str, table=tablename, mode='append', properties=properties) However, we encountered ...

From a certain column I need the following type of data: Value is 6 characters long and is numerical “L” is any letter followed by 5 numerical characters, for example L12345 the L needs to be turned ...

Sometimes, when there is no load on the server, the size of the MS SQL database tempdb log file (templog.ldf) starts increasing. As a result, the available space on the C drive decreases. To resolve ...

I have a column Amount which I want to get its sum by month within each year. I have tried the following query and it works well for year but month is summing up incorrectly. For instance in this May, ...