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...
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...
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!
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.