Programming SQL

SQLjobvis 3.0 (free) - Visualize your SQL agent job histories...
SQLsoft is pleased to announce the official release of version 3 of SQLjobvis - a totally free tool for SQL Server 2005 and above. SQLjobvis displays your SQL agent job run history in a timeline, making it easy to identify long-running, failed or clashing jobs. Check it out today at http://www.sqlsoft.co.uk/s... 3 Mar 2010 20:55

TSQL Transpose
Hi All! I'm trying to create a query that does a real transpose similar to Excel function - it is slightly different from Pivot/Unpivot functionality of SQL Server. Basically, I have a date dimension table and I need to list corresponding dates, separated by coma for each month. So, for January 2010, my re... 3 Mar 2010 23:07

Tom and Plamen...
Guys, Both of your suggestions worked beautifully, and after a quick ORDER BY, both gave the exact same resulting dataset. I'd like to thank you both for providing me with valuable practical examples in problem-solving (with two different approaches, to boot) with SQL. You guys rock! Thanks again. Al... 3 Mar 2010 19:49

Not allow multiples in same month
I have a stored procedure where I want to not allow an ActivityCode = 64 more than once in a month for any one person (PeopleLinkID). Below is my IF condition that is not working correctly. Also, I think it is sometimes returning an error "Subquery returned more than 1 value. This is not permitted when the su... 4 Mar 2010 14:41

Help with duplicate fields
Hi All, Supose I have a Products table with code and description fields: cod description --- ----------- 001 hamburger 002 cheesburger 003 hotdog In this particular case, duplicate codes are not a problem since the code is not a primary key,and similar items stocked at various facilities will have the sa... 3 Mar 2010 17:34

delete rows from a large table with text column
hi guys, I need to remove old data on regular basis from a big table (over 50 million) with a large text column. That column has average around 3000 charaters. The deletion is painful. It takes a minute or more to delete just 5000 rows. Since there should be no down time for production, all I can do now is to d... 3 Mar 2010 17:34

Whoever posted this
Exactly what I was looking for! You are the sexiest man/women alive, you exude nerdness. Thanks again... inf wrote: Re: Retrieve Service Account Login Information from t-SQL 17-Dec-08 On Dec 15, 12:33=A0pm, i...(a)onlyhd.tv wrote: DECLARE @serviceaccount varchar(100) EXECUTE master.dbo.xp_instance_re... 3 Mar 2010 11:51

Returning ID's with broken series
Table 'TEST' has information on 4 staff members. For Staff_ids 1 and 4 there is no missing (brake) year while for staff_id 2 and 3 there is brake in years. Can someone help me with a query to return only the staff_ids for which one or more years are missing in between. CREATE TABLE [dbo].[TEST]( [Staff_id] ... 3 Mar 2010 11:51

Am I supposed to see the OUTPUT parameter's value in SQL Mgmt Stud
Hi, I have a stored procedure with an OUTPUT parameter. When I execute the procedure in SQL Server Mgmt Studio, am I supposed to see the OUTPUT parameter's value? I'm troubleshooting an issue and at this point I'm not sure if it's the application code or the stored procedure. When I execute the stored pro... 3 Mar 2010 11:51

Drop time conditionally
I have an SQL SELECT (see below) that I want to have the column named ActivityDate display as either a date and time or just a date. For example, if the time is anything other than 12:00 AM then I want to show the date and time, otherwise, just the date. Thanks. SELECT [ActivityID], [PeopleLinkID], [Ac... 3 Mar 2010 09:33