Search results for query: *

Thank you ECAR, I'm gonna try this. "Beyond ideas of right and wrong, there is a field. I'll meet you there." Rumi

Hi everybody, I’m doing some reports in coldfusion with sql server backend. I’m trying to create a template for displaying the reports. What I want to do is that when I write the queries in sql server count the number of fields in the select statement and use that for the number of columns and...

sorry, there were some mistakes in that. Here is the sp alter procedure CalculateDuration As SELECT TOP 100 PERCENT lp.LastName AS ResolverLastName, ti.[tiIdNumber] AS tiIDNum, ti.[tiStatus] AS TicketStatus, ti.[tiAssignDate] AS AssignDate, ti.[tiStartDate] AS cketStartDate...

Thank you jshurst, but I think I need to be more clear about this, I need to show the result in terms of hours,minutes and seconds,so at the recordset level when I'm doing the select statement and doing the datediff, how do I read the hours and minutes into variables? I don't know if I'm...

Hi every body, I'm writing a stored procedure. I have a few dates in a table,1.Request_date 2.assigned_date,3.start_date,4.end_date I need to perform some calculation to figure out the difference between dates, and see how many hours or minute or seconds where spent working on a project and...

Thank you for your answers guys. The reason I wanted to do that is I need to create metadata off of a stored procedure with one IN Parameter in WebFocus and it would not let me do that.As long as there is no parameter coming in or out it's fine but it goes crazy with parameters. So I thought...

Hi everybody, I was wondering if you can call a stored procedure that has one IN parameter in a view. And if yes what is the syntax for that? Thank you!

I think I figured it out. It was another filter I was using that was causing the problem. Thanks again

Thank you so much,gmmastros. I was doing that but I was not getting any rows back. I guess I'm doing something else wrong. thanks again

hi, I'm not sure how i can join to a lookup table. I have two tables:applications and status.Now if I want applications that have a particular status how do I select that? the application table has a "status id" column and the status table has status id and status description. Thank you

I needed to delete the posts and the moderator was kind enough and understanding to do it for me. Thanks again everybody.

Hi, Thank you so much for responding. I just tried red flaging. I'll let you know if it works.

Hi how do I edit or delete a previous post of mine?