I have a process that uses SqlAgent jobs to process data coming from many sources, and I'm seeing p…
2 days, 1 hour ago
,DATENAME(dw, [myDateTime]) as DOW
group by DATEN…
4 days, 5 hours ago
I want to create a Extended Event that logs all queries from a specific user or every user e…
2 weeks, 1 day ago
By: Grant Fritchey
Can someone help me figure out how to turn this string:
2 weeks, 4 days ago
By: Jeffrey Williams
I've been using OPENQUERY to select from a MySQL db via a linked server
and trying to use the f…
3 weeks ago
By: Mr. Brian Gale
I want to check the view usage within a database.
I want to analyze whether a view is currently…
3 weeks, 2 days ago
I have a table with 3 columns Entity,Description, and a TotAmt. I want to create html email with en…
1 month ago
I am trying to avoid using while loop but OK with it...
We are talking about 500K source data...
By: Steve Collins
I was wondering if anyone can offer any insight on this:
I have four stored procs:
1 month, 1 week ago
Please delete post, I was looking at the goal of the query totally wrong.
By: Jeff Moden
I need to pull the last 30 minutes of activity from a table that has a field defined and stored in …
1 month, 2 weeks ago
Looking for some suggestions.
Currently, In our system we have GUIDs are primary keys and…
I have 2 update queries relatively simple but acting on around 10 million rows hence the per…
By: Jonathan AC Roberts
This SP updates prices and now I need to add an additional check coming from the MTD_INV_LINE_ITEM …
1 month, 3 weeks ago
I need to to design “Customer Management” with the following modules:
2 months ago
Viewing 15 topics - 1 through 15 (of 4,906 total)
You must be logged in to create new topics.