Using SQL Server 2000, I want to trigger an email anytime a particular table is appended. I already know the SQL language which will trigger an email, but I need to know something more: Is there a way to add a value from one of the appended row's columns to the email? If so, how would you go...more >>

I have a SQL query like: "Select CityName From Student" The current result is like below: AACityA BBCityA BBCityB BBCityC BBCityD CCCityA CCCityB DDCityA .... Now I'd like to order the result to show the records that contain "BB" first, that is, my desired result should be like ...more >>

I used to work on sql server 2005 on hosted on virtual pc 2004 with windows 2000 server as guest operating system on windows xp professional as host operating system. No matter how much ram I threw at it, it was very slow. I decided to wipe out the notebook and install windows 2000 with s...more >>

I'm trying to figure out how to sort the below results in Northwind by the month and year. Because my Date is text type, SQL is ordering it incorrect. Anyone know a workaround? I need a solution that will sort the m-yyyy format, but I may even need to sort a Dec - 2005 format. MY CODE: ...more >>

Hi, i was thinking about a way to rewrite the procedure i'm going to explain, to improve performance and take down the whole duration. I have a table with about 5.000.000 rows: TABLE1: ID bigint, ID_PM bigint, DATE datetime, ...other fields... and another table with abount 5.0...more >>

My example code (CODE 1) returns quarter counts for several fields in Northwind (I'm using Northwind to simulate my actual data). It returns code that looks like FIGURE 1. Can my sql be modified so the Field names are the GROUPED BY and run down the 1st column while forcing the Quarters to...more >>

Hi Reader, I'm fairly new to SQL and am struggling with this query. Can someone help me out? I have three tables, Employee, Sale and EmployeeSale. >From these tables I want to be able to monitor employee performance by calculating the value of sales each of my staff has made in a qtr and ...more >>

hi guys, I have a text file contains about 1 million rows, I tried to import to a table but I received data conversion errors for some rows, however, the row number is like 504500 for example, I want to troubleshoot this row but the only way I know is to open the text file (300MB) which ...more >>

In the following function a JobId is passed in that the user wants to disable. The function then retrieves the job collection, finds the correct job, sets the IsEnabled to false and then tries to update the job. This results in this error: Alter failed for Job <job.name> Does anyone have...more >>

Our database utilizes some custom functions and .dll's to perform IRR calcuations. The IRR calculation takes two steps. 1. The first step is to create a view which preps the cash flows and pulls out what you want to analyze. ("Ad Hoc Query") 2. The second step is to create a stored procedure ...more >>

select 717306 * 3000 Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. What's the story with this? ...more >>

Hi I do have a question about a query on update. I appreciate if anyone could help me. Here is the table I have: Emp ID Lname Fname OfficeID 1 A Bobo 1 2 B Coco 2 3 C Jojo 1 Office ...more >>

I have 200 tables that have data entered into the daily. I need to identify all dates that are missing from the tables. for example: date column1 column2 1/1/2005 5 20 2/1/2005 67 35 4/1/2005 3 17 5/1/2005 9 ...more >>

Hi, I have two tables Table1 and Table2. I need to join Table2 on Table1_SID to get name for SID Column of Table1. But I need all rows of Table1. I can use a Left Outer Join to achieve this. Now I have a problem. There are rows in table2 and table1 where Table1_SID and SID have -1 v...more >>