Search results for query: *

Hello All, The roles were working perfectly, my CSS was the one on the fritz, had to move the <ul>s outside of the logingview declaration. Thanks :)

Hello All, I have a menu in which items within it should display depending on the role assigned. In the code below all roles should see the "Forms" option, and then, depending on the role, they should see "Admission", "Service", "Treatment", or "Discharge", only the Administrator should see ALL...

Oops, sorry, didn't see the second home grouping, that will teach me to read more carefully before I post.

Hello SELECT MIN (Date) AS StartDate, MAX (Date) AS EndDate, Place FROM YOURTABLE GROUP BY Place Hope this helps :)

Thanks for your input, I will look into your suggestions :) Luis Torres

Hi All, We have installed Sql Server 2005 with a 5 CAL user licenses (we are a relatively small company). We are developing a website that will allow users to query one of our databases. The website uses in it's connection string only one User Name that was specifically created in SQL Server...

Here is an idea of how to do it, every query could be run as a sub query of the next one, but I kind of wanted you to see what is going on on the process. Hope this helps SELECT id AS Last_ID, MAX (record_date) AS Last_Date INTO #TEMPO FROM Your_Table GROUP...

SELECT Address, KepMap, CASE VACANT WHEN 1 THEN 'VACANT' ELSE 'OCCUPIED' END FROM PROPERTY WHERE CITY = 'Dallas'

Thanks for the suggestions :)

Hi experts :) I'm creating a little website to train our employees, it goes a little like this: - Employee logs in (Done) - A list of available presentations is shown (Done) - Employee selects presentation and goes through it (Done) - Employee takes a test and gets scored (Partly Done...

Thanks for the suggestions :)

Hi all, I've been requested to develop an intranet training web site in which the employees: Step 1.- Log into main page and get a list of training videos they have access to. (Done) Step 2.- Choose video, play to completion, print certificate. (Incomplete) Step 3.- Update...

No prob, glad I could help :)

How about this? UPDATE Master_Data_Vehicle SET Actual_Annual_KM = (MilageTemp.Mileage / (DATEDIFF (day, First_Registration, MilageTemp.RepairDate) / 365.0)) FROM MileageTemp INNER JOIN Master_Data_Vehicle ON Master_Data_Vehicle.Chassis_Number = MileageTemp.ChassisNo WHERE...

thanks for your response :)

Hi all, I have a little site that generates reports (using Crystal) and displays the results in either pdf format or excel format (2003). For excel I use the next code: Response.ClearContent() Response.ClearHeaders() Response.ContentType ="application/vnd.ms-excel"...

Hello, your select will return a table with an x number or rows for EAR_LOB and Controller, you are trying to create a function that returns a single varchar(10) value. Please explain a little more of what you are trying to do.

Hi, you can try: INSERT INTO Your_Second_Table SELECT ConNum, Year1, 1 FROM Your_First_Table WHERE Value > 0 UNION ALL SELECT ConNum, Year2, 2 FROM Your_First_Table WHERE Value > 0 : : : -- For All The Different Years Hope this helps

gmmastros: shouldn't the value of beginAt be always greater than the last endAt?

My method is basically the same as vongrunt's, I just left a bunch of columns so you could see the logic behind it, if you select distinct trackid then it should just give you track 2 and 3