Hi, Roji. Thank you so much! I knew I should be able to use COUNT(*), but could not figure out how to include COUNT in the query. I really...
Hi, all. I am having trouble developing an SQL query. I have a table that may contain only one row or multiple rows for a single vendor ID because...
Hi, all. Okay, I think I've got it figured out. I am using the REPLICATE function in my SQL query so I say something like: SELECT REPLICATE('0',...
Hi, all. Is there a way using DTS when you export data to a comma-delimited file to pad a column value with zeroes? For example, if the...
Hi, Adriann and Cemuney. Thank you for your replies. I see what is happening now. The result set containing rows where the Product Name is NULL...
Hi, all. I have been experimenting with the CUBE function, but have only been able to generate a valid result set with the following very basic...
Hi, Adriaan. Thank you for the very quick response. The first query is easier to follow - I will give this one a try. As I gain experience with...
Hi, all. I'm stuck on yet another SQL query. I have two tables: UserExpSubj with the following columns: UserId, Year, ExpSeq, SubjId and...
Hi, Madhivanan. That query worked. I added a WHERE condition to the inside SELECT and got what I wanted. Thanks for your help. - Sue
Hi, Merrill. Thanks for your reply. I tried the inner join and got over 8,000 records. It seems like it should work, but for some reason it...
This is an update. This query yields 128 records: SELECT * FROM TableB WHERE DeptId = '0862' AND Yr = '2006' AND UserId IN (SELECT UserId FROM...
Well, I'm stuck on another SQL query... TableA has UserID TableB has UserID I want to find all the UserIDs in TableB (including duplicates - some...
Hi, Robert. Thank you for your reply. I just want to make sure I understand the query. You are saying the result set will be these columns:...
Hi, Madhivanin. Thanks for the quick reply. Unfortunately, I won't be searching on just one LogUserID. I need a query that will find ALL the...
Hi, I'm having trouble coming up with the correct SQL query. I must find all the users in a table who have logged on with the incorrect password...
Well, duh. I think I got it: CREATE PROCEDURE [dbo].[sp_Add_AgencyGoal] (@AgencyCd [varchar](10), @AttrCd [varchar](10), @GoalPct [decimal],...
Hi, all. I can't seem to get this SQL query correct (I've tested lots of variations in SQL Analyzer). I have a table with four columns and two...
Hi, ranjitjain! Thanks for your reply and additional info. All the responses are really helping me learn more about DTS packages and certainly...
Hello, all. Thanks for all the good information. Well, it must have just been "dumb luck" that I ever got this working before, so I'm back with...
Hello, Argyle. Thanks for the tip - I see the job now. I have been creating and scheduling both the packages and jobs independently because I did...
Separate names with a comma.
