Topics
Started by
Posts
Last post
I am in a project where information is being pulled from a database then put into a web page in a m…
1 replies
select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus …
5 replies
Hi i have 3 table that need to find out which id missing two tables TABLES: Main,table1 and table2 …
4 replies
SELECT CASE WHEN EXISTS ( SELECT name,enabled FROM msdb.dbo.sysjobs WHERE name = 'Myjob' ) THEN 'Ex…
1 replies
Hello all, trying to return the time in minutes between the Date1 and Time1 columns and the Date2 a…
3 replies
Hi Guys, Has anyone used windows task scheduler with SQL Agent? I have a FTP which needs to be impo…
4 replies
how do I calculate db sizes of all databases across all servers from cms declare @dbsizes TABLE (se…
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
Dear Experts Please help me to convert below oracle unique index to Sql Server. CREAT…
2 replies
I tried looking up a comparable function in SQL to the DLOOKUP in ACCESS. I had this working in A…
5 replies
By: sgmunson
I have an incoming set of string values which need to be checked so they can be formatted as Decima…
3 replies
Hi I have a broken hierarchy where I need, for each row, to create a string that contains all poss…
7 replies
Hi Guys, I have a table, around 320 fields. I am trying to use a simple Insert statement. Insert in…
5 replies
Viewing 15 topics - 1 through 15 (of 320 total)
You must be logged in to create new topics.