Topics
Started by
Posts
Last post
SELECT count(*) ,DATENAME(dw, [myDateTime]) as DOW FROM [myDatabase].[dbo].[myTable] group by DATEN…
11 replies
Hello, I want to create a Extended Event that logs all queries from a specific user or every user e…
3 replies
Can someone help me figure out how to turn this string: ' ;T41,Vending,9000011;T42,Laundry,9000012;…
6 replies
Hi, I've been using OPENQUERY to select from a MySQL db via a linked server and trying to use the f…
1 replies
Hi, I want to check the view usage within a database. I want to analyze whether a view is currently…
5 replies
I have a table with 3 columns Entity,Description, and a TotAmt. I want to create html email with en…
33 replies
I am trying to avoid using while loop but OK with it... We are talking about 500K source data... Or…
2 replies
I was wondering if anyone can offer any insight on this: I have four stored procs: proc 1&nbs…
7 replies
Please delete post, I was looking at the goal of the query totally wrong. This topic…
2 replies
I need to pull the last 30 minutes of activity from a table that has a field defined and stored in …
17 replies
Hello, I have 2 update queries relatively simple but acting on around 10 million rows hence the per…
7 replies
This SP updates prices and now I need to add an additional check coming from the MTD_INV_LINE_ITEM …
9 replies
dear experts, I need to to design “Customer Management” with the following modules: 1. Customer…
2 replies
Hello everyone, We have a HAG with 3 nodes. A query that normally runs in seconds on the primary re…
7 replies
I have a MERGE stored procedure that I need to modify to check for the MATCH based on five fields b…
8 replies
Viewing 15 topics - 91 through 105 (of 4,982 total)
You must be logged in to create new topics.