Programming SQL

Wrapping tables by views
I'm working on a legacy small-enterprise system that has a single database hosted by SQL Server 2005 and a bunch of client applications. The main client (used by all users) is an interactive MS Access 2003 application (ADP), and other clients include various VB/VBA applications like Excel add-ins and command-line u... 3 Jul 2008 04:18

Comparing execution plans - is there any kind of DIFF for this task?
Hi, Let's say I have two SQL queries (SELECT statements) and I need to compare their execution plans. Can anybody recommend any tool or technique that would work better than doing visual comparison in Management Studio? Of course, I am most concerned about cases when the queries are complex enough to produce ... 3 Jul 2008 05:20

Compare Data In Two Tables
I have two tables in two different databases. One has Production data the other has production data + Archive data. to determine which is the archive data so I want to select only the archive data from the database. Both tables have a composite key. How to I select only the archive data and count the number of ... 2 Jul 2008 23:13

Dynamic SQL , Discussion about Erland's Article
Bassam (egbas(a)yahoo.com) writes: The solution he offers thru sp_executesql is very complicated in many situations , like , if we have 10 parameter options for the user to choose from in the client , its not just ' = ' that the user can select for the parameter , it can be > , < , = , Like , Not Like , Betw... 3 Jul 2008 11:29

How to Create a Parameterised GROUP BY Without Using Dynamic-SQL
Hi all I have read Erland's treatise on dynamic-SQL, and now I want to avoid it like the plague. But one of the areas that still seems problematic is the GROUP BY clause. Depending on the parameters passed into my sproc, I want to group on different columns. What is the neatest way to do this without dynami... 3 Jul 2008 11:29

Formatted Text
I have a varchar column which has formatted text in it...bullets, tabs, hard returns, etc.. If I write a SQL script against this table, it will not paste these edits into Excel. However, if I Open the Table in SSMS and copy from SSMS and paste into Excel row by row, the edits are there. If I just copy the Open... 3 Jul 2008 13:33

Connecting to subscriber instance via business logic handler...
Hello, I have a customer resolver for replication where I am trying to open up a connection to the subscriber to execute stored procedures when synchronizing the data. This seems to work well with a LAN configuration, but when it is configured for a web synchronization, the Open fails for the database connect... 2 Jul 2008 16:02

Outer Join newbe question
Hi all, Pretty new to this so I would be very glad if any of you could point me in the right direction. I have three tables (see below) and I'm trying to get this result: DepID DepName FirstName LastName 1 Dep1 Andy Ason 2 Dep2 Dave Dson 4 Dep4 Null Null I do not get the last row. It is the "4 Dep4 Null... 3 Jul 2008 05:20

run a job under job agent
I need to run a job under a specific ID and password so it can read a file on a shared drive. When I change the owner to this ID the job still fails, how can I use a specific ID and password that has access to this shared drive on the network? ... 2 Jul 2008 18:05

executing an SQL Stored procedure from within a function
I want to execute an existing SQL Server 2000 stored procedure from within a user defined function. I am using this function within a view. The stored procedure I want to execute returns a numeric value that ultimately I want the function to return when it is called. I have been unable to find anything on the... 9 Jul 2008 12:41