Topics
Started by
Posts
Last post
Hi all - I've been tasked with de-duplicating some customer data and am having difficultly getting …
6 replies
Hi All, I'm testing a stored proc to restore a database snapshot and not able to trap the first err…
1 replies
Is their a best practice for re-coding this ? (this predicate is being applied to a 500 M row ta…
4 replies
I have 2 tables: TableA TableB TableA contains 2 columns: EmployeeID and Code (plus a handful of ot…
3 replies
I want to write a SQL job that generates an excel file containing the result of DBCC SQLPERF(LOGSPA…
5 replies
Good Day All First of all am new here not really familiar with IFCode Shortcuts but will try my bes…
4 replies
Hi I hope someone can help I am relativley new to using sql so i apoligise before hand if this is a…
8 replies
I have 2 databases, DB A and DB B. I have stored Procedures on DB A and I need to find which ones a…
7 replies
Hi there, Is it possible to use group by in a way that it uses a specified range rather than the di…
4 replies
Hi Is it possible to have a query to return top 10 items from each division. Example Table columns:…
13 replies
Hi, I currently have a view with 5 columns. I want to create a 6th that has an average of number of…
5 replies
The more I read on Isolation levels the more I get confused Connection 1: BEGIN TRANSACTION; SELEC…
18 replies
A nonclustered index is analogous to an index in a textbook. The data is stored in one place, the i…
7 replies
The price sum should be the sum of all the OrderNo records but it's wrong. SELECT A.[OrderNo] ,…
12 replies
Can I use multiple print statement in stored procedure? I use it for troubleshooting purpose. For e…
21 replies
Viewing 15 topics - 6,151 through 6,165 (of 10,635 total)
You must be logged in to create new topics.