Topics
Started by
Posts
Last post
INSERT INTO #ttSELECT DISTINCT dr.terr_grp_id,dr.terry_cd,dl.deal_line,dl.revs_no FROM deal_right d…
7 replies
So I have a query that's basically SELECT column FROM DB1.Schema.View. The view is a bit of a…
15 replies
This is a fun one. I need to run the same query against every db on the database and aggregate the …
3 replies
Hello, I have 2 native compiled stored procedures.The first one has a call for the second one, and …
2 replies
We've created a trigger as below to audit DDL events and now it is causing us frustrations as the f…
15 replies
Hello all,I have sql server 2000 🙁 and i have a view that query sql server 2016 via linked ser…
6 replies
I have a linked server connection set up to our active directory domain controller. I also ha…
3 replies
Hi All,I have a statement returning data from today up to 28 days ahead, but it is including weeken…
12 replies
Hi all, I have just started a new gig as a contractor, and the DB architect here insists that we sh…
8 replies
Hi. I've been at it for hours (if not days) now, but I just don't understand how to create somethin…
1 replies
CREATE TABLE #tblContacts(ContactID int,Contact varchar(100)) GO INSERT INTO #tblContacts (Contact…
25 replies
Below is some example data. First, I pull everything from the table person. Then, I need to check i…
6 replies
Hello, I captured a trace into an SQL table with SQL Profiler and template TSQL_Replay. I replay no…
1 replies
I have quite a task to do. Using an old Northwind database, I need to create a trading balance for …
4 replies
I have three tables with user data in them. The formatting might be off but hopefully below should …
7 replies
Viewing 15 topics - 2,086 through 2,100 (of 3,091 total)
You must be logged in to create new topics.