Topics
Started by
Posts
Last post
I want to know what are the customers having missing month data based on the following data pattern…
16 replies
Hi, I have this special requirement as a query result, and I wonder if SQL PIVOT can be used to ach…
10 replies
. This topic was modified 4 years, 10 months ago by David.Toews 95002. Reason: Would like t…
3 replies
how do I calculate db sizes of all databases across all servers from cms declare @dbsizes TABLE (se…
6 replies
I am in a project where information is being pulled from a database then put into a web page in a m…
33 replies
select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus …
20 replies
Hi i have 3 table that need to find out which id missing two tables TABLES: Main,table1 and table2 …
5 replies
Something I've been playing around with lately is the UTF8 functionality in 2019, and it dawned on …
15 replies
I want all these description in different row. TIA Example descriptions 0|Home 1|Office|Fals…
4 replies
SELECT CASE WHEN EXISTS ( SELECT name,enabled FROM msdb.dbo.sysjobs WHERE name = 'Myjob' ) THEN 'Ex…
2 replies
Hi Guys, Has anyone used windows task scheduler with SQL Agent? I have a FTP which needs to be impo…
5 replies
Hello all, trying to return the time in minutes between the Date1 and Time1 columns and the Date2 a…
3 replies
Is DBMS_DATA_MINING available in SQL Server 2019? This is error: 'DBMS_DATA_MINING' is not a recogn…
1 replies
Hi guys, I am trying to update a large table in small batches. Within the update statement, I am se…
2 replies
Hi Guys, I'm hoping for a little advice and please delete if this is not relevant here. I've been …
2 replies
Viewing 15 topics - 1,471 through 1,485 (of 1,784 total)
You must be logged in to create new topics.