Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
How to get the transaction mode of a spid. - Hi All, Which DMV will tell me the transaction mode of a SPID? I did check MSDN but couldn't get the answer. https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-session-transactions-transact-sql?view=sql-server-ver16 - Autocommit transaction - Implicit transaction - Explicit transaction - Batch-scoped transaction - Distributed transaction Regards, Sam |
SQL Server 2016 - Development and T-SQL |
Prompt user for input value - Hey folks. I need to be able to have a little box or similar pop up so a user can enter a value, that will be part of the SELECT statement. I have looked everywhere and have had no luck. Oracle has this option I believe with the &. This works in Oracle: this […] |
SQL 2012 - General |
query results of last full month's data - Thanks in advance for any help. I've found similar topics but not quite sure how to do this one. I need at any given time to return the results of the last full month's data regardless of how many days are in that month, e.g. today is February 20, 2023 and I want to return […] |
Arithmetic overflow error converting expression to data type smallint. The state - hi, I have started getting this message, from a stored procedure, which is not repeating, it comes after now and then, or sometimes it does not come at all. (while testing: I kept stored procedure and parameter same). Msg 8115, Level 16, State 2, Procedure uspMS, Line 11 [Batch Start Line 0] Arithmetic overflow error […] |
SQL Server 2019 - Development |
Us the DECRYPTBYPASSPHRASE function - I have a T-SQL script which encrypts the SSN using the ENCRYPTBYPASSPHRASE function with a pass phrase. ENCRYPTBYPASSPHRASE('Key', CAST(e.ssn AS nvarchar(100))) The ENCRYPT and DECRYPT function works fine when performed on the same server, which is SQL 2019. But, when I perform the ENCRYPT on server "A" . Then write the result set to server […] |
SQL Server 2008 - General |
Login Failed. The login is from an untrusted domain and error 18452 - Hello People, I found information over the internet and went step by step to check each setting but i surrender myself and decided to post here regarding this issue which i am facing. Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication. Microsoft SQL Server, Error: 18452 The […] |
T-SQL (SS2K8) |
BULK INSERT PROBLEM for CAV file - Hello SQL Server Community, I'm not new to T-SQL but I have a simple problem that I have not been able to solve after several hours of research. I have several CSV files that I want to import into SQL Server (v2008 R2) I have created a temp table. CREATE TABLE DataTMP ( Col1 varchar(255) […] |
BULK INSERT PROBLEM for CAV file - Hello SQL Server Community, I'm not new to T-SQL but I have a simple problem that I have not been able to solve after several hours of research. I have several CSV files that I want to import into SQL Server (v2008 R2) I have created a temp table. CREATE TABLE DataTMP ( Col1 varchar(255) […] |
SQL Azure - Development |
Advanced grouping for gaps and islands - Hi, I'm trying to figure out how to group a set of data based on how many days a person is sick. The problem is a gaps and island issue combined with running streak, with a twist. The records are either of type Work or Sick and are only saved on it's registered date. So […] |
Azure Data Factory |
Best Course to prepare for GCP Cloud Security Engineer certification? - Hey there, I want to get GCP Cloud Security Engineer certification, but I'm a bit overwhelmed by the number of courses offered by various web academies. Can you recommend some top picks? |
Reporting Services |
SSRS query builder, generated SELECT statement causing error - I'm working on a mysql query using the Visual Studio tableAdapter Query Builder, so far i'm getting this message (see image). Although the Query Builder executes the data given but cannot generate the columns needed in my dataset. I want to know what i'm doing wrong when my query works fine on my code. I'm […] |
General |
Informatica SQL generating basic statement - I'm newbie using Informatica Data Quality Analyst and am unable to create a basic SQL statement. The Sql query is being created against a mapping specification of a table that was imported as a flat file originally. The statement is as follows: Select ColumnA, ColumnB FROM Table1 WHERE Table1.ColumnA = 'S' That SELECT.... FROM part […] |
SQL Server 2022 - Development |
Schedule a PowerBI dataset refresh on the "quarter" hour ??? - Hi all, I know very little about Power BI, but I am hopeful that someone here has enough knowledge to know whether or not it is even possible to schedule a dataset refresh on the quarter-hour instead of merely on the half-hour or top of the hour. I know that with SSRS, I can use […] |
Hints for searching text? - I've got a table with like 6-7 million rows. Sometimes I'd like to search for certain text in a few columns. I can't index those columns because of text-length so I've to figure something out (because right now I can go on a really long coffebreak while doing a search). Searching using EQUAL is okay: […] |
Query - Dear All My table contains the following records create table #ProductDetails(ProductID int , PurchaceDate datetime ,LicenceQty Int) insert into #ProductDetails values (1,getdate()-5,10) insert into #ProductDetails values (1,getdate()-4,25) insert into #ProductDetails values (2,getdate()-4,25) insert into #ProductDetails values (6,getdate()-3,100) insert into #ProductDetails values (6,getdate()-4,20) insert into #ProductDetails values (6,getdate()-5,20) select * from #ProductDetails In the above table, […] |