Search results for query: *

Lisa, Thanks....I was able to run the SP by using: Exec Rpt_ActsAndFore 'Jan 1 2002 12:00AM' The connection type is in fact ODBC, and I'm utilizing SQL Server 6.5......do you think I need to make a change within Crystal Reports somewhere? The date/time structure seen above is used in other...

Lisa, Thanks for your response....I actually set it up that way at first, but I kept getting the following message: Syntax error converting DATETIME from character string. Additionally, when I tried to execute the stored procdure by itself in SQL server, I received: Procedure Rpt_ActsAndFore...

...= MIN (Actual_Calendar.Actual_Calendar_Date ) FROM Actual_Calendar WHERE Actual_Calendar.Actual_Calendar_Closed = 0 SELECT * FROM Rpt_ActFor1 Where Date <= @date_val AND DatePart(yy,Date) = DatePart(yy,@date_val) UNION ALL SELECT * FROM Rpt_ActFor2...

That's it.....I checked the table, and it does have a trigger! I don't know how I overlooked that. Thanks guys!

Hi....I'm trying to delete a record from a table, but I get the following message: Attempt to insert the value NULL into column 'Employee_Type_ID', table 'staftrak.dbo.Outlook_Total'; column does not allow nulls. UPDATE fails. Command has been aborted. The column 'Employee_Type_ID' is an...

...I can't call the Stored Procedure.....why can't I do this? Here's my code: CREATE PROCEDURE Rpt_ActForp @date_val varchar(10) AS BEGIN SELECT * FROM Rpt_UnderAlloc Where Date <= @date_val AND DatePart(yy,Date) = DatePart(yy,@date_val) UNION ALL SELECT * FROM...

Hi.....I've got a stored procedure in which the following code exists: SELECT * FROM Rpt_ActForp1 Where Date <= @date_val AND DatePart(yy,Date) = DatePart(yy,@date_val) UNION ALL SELECT * FROM Rpt_ActForp2 Where Date > @date_val AND DatePart(yy,Date) =...

Hi....I'm looking at a VB project that has a form with a TabStrip object......there are 3 tabs (Employee, Team, and Status) associated with the TabStrip object. Each of these tabs appears to be associated w/ a PictureBox (picOptions(0), picOptions(1), and picOptions(2)). By default, when...

Hi....has anyone encountered this problem? I want to modify the SQL Query (which can be accessed by clicking on 'Database' on the Tool Bar, and then by selecting 'Show SQL Query'). I'm able to modify the FROM and WHERE clauses, but the SELECT clause doesn't get updated.....why is that? It...

You guys are awesome....thanks for all your help.....I ended up throwing all the data I needed into a table, then executed a view out of Crystal Reports which read the table.....kind of like what MalcolmW suggested.....and it worked, so thanks again for all of your suggestions!

BP, I'm confused as to why you'd want me to remove the Union section....I did that, and the report runs fine, but I need the info from the Rpt_Actuals_MA view, hence the Union. Maybe I'm misubderstanding what you're saying? Thanks for the reply though! The Rpt_Actuals_MA view utilizes 11...

That's where I'm confused.....I am able to run the entire query successfully in the query analyzer, but it bombs when I try to create the report. Any ideas?

...Staffing_Pools.Staffing_Pools_ID, Projects.Project_ID, Employees_1.Employee_ID, Task.PIV_ID, Task.Task_ID, Employees.Division_ID, Employees.Group_ID, Employees.Team_ID, Employees.Job_Code_ID, Employees.Employee_ID, Totals.Hours Union All SELECT * FROM dbo.Rpt_Actuals_MA

Thanks guys....I used the: SELECT DISTINCT Job_Code, SUM(Hours) FROM #Temp_Table7 GROUP BY Job_Code and that worked.

Here's a problem that I thought would be simple, but I can't seem to get it to work.......I've got a temporary table with 2 columns. The first column is Job Code, the second column is Hours billed to that Job Code. There are only 8 different Job Codes, but my table has about 900 rows. I...

excellent.......thanks, the: SELECT * INTO #Temp_Table FROM Rpt_ActPrjEm worked!

...Actuals_Percent_Allocated, Project_Description, Actuals_Date, Manager_Last_Name, Manager_First_Name, Job_Code_Description) SELECT * FROM Rpt_ActPrjEm I thought I needed to use a pound sign, but I get an 'Invalid object name #Temp_Table'. I also tried the above without the pound sign and...

Well, I did cut and paste it into a SQL query window, and it worked! That's why this is confusing.....something within Crystal Reports is preventing me from doing a UNION.....some property or condition has been set to prevent it as far as I can tell.....what that is, I have no idea, or no idea...

Hi.....not sure if someone can help me or not....I made some changes to an SQL Query within Crystal Reports, specifically performing a UNION.....however, I get the following message: (SQL Server)All queries in an SQL statement containing a UNION operator must have an equal number of expressions...

Thanks guys....that worked!