Search results for query: *

I have a field in a table the has leading spaces. How can I change the fields to remove any leading spaces? I was thinking of something like below, but I dont think its correct. --- update tableOne set name = (select ltrim(name) from tableOne) --- Any thoughts on how I should do this? Thanks.

Hello everyone, I have a Windows 2000 andvanced server running, with windows2000 and windows ME clients. My boss wants me to set up a company calander, so everybody can see where eveyone is that day, possibly to also share the contact list. Looked into net folders, but he didn't like that...

I have been woking with SQL Server 7.0 and I need to produce a report of questions that are answered by users: User A_1 A_2 A_3 A_n 101 0,0,0,0 1 1 0 22 1,2,3,4 5 3 1 3110 0,1,2,1 7 <NULL> 1 A_1 is a string...

I need to run a job twice a week to gather users that have joined since the previous run date? I want to run the job every Tuesday morning at 3:00am and every Friday at 3:00am. on TblAnswers with the datetime field being Ans_AnsweredTime [code] So I need to run: Friday 05/04/2001 and collect...

Hello everyone, I've got another strange one for you.(using SQL Server 7.0) Is it possible to break apart a string that is delimited by comma's? User Fred --> Ans_String_Val = '0,1,2,3,4' User Wilma --> Ans_String_Val = '6,5,1,2,0' A)I want to put the values in between the commas into...

I'm sure that this is more than JavaScript, but: Can anybody lead me in the direction on how to learn how to code a way to create either: 1)Drop-Down Menu (File, Edit, View, Ect.) 2)Icon(Print, Refresh button) into a users WebBrowser. Michael

Hello All, Is there a function to create a pop-up box that has three items: 1) Yes Button 2) No Button 3) Checkbox to ask if they want to see this Box again. Thanks for your help, Michael

Hi again, First off, let me state that I've been told(and agree) that there should be some re-design of dBase, but: I need a count of Married/Single/divorced Users who have ordered Product X, and all of the info is in one table: TblAnswers(No Primary Key) Ans_QuestionnaireID |----->Question...

The Dbase is running on SQL Server 7.0. I have a field that is broken into subset's of data seperated by comma's. table looks like: tblAnswers Ans_QuestionnaireID = Relates to Product Ans_Question = Relates to Question Number Ans_String_Val(varChar1024)= Is the answer to the...

A simple one for the Guru's: tblUsers Usr_CreatedOn = Datetime Field I need to count when users singed up by date, but the field is a datetime so the following won't work: SELECT Usr_CreatedOn as Reg_Date, COUNT(Usr_CreatedON) as Total FROM tblUsers GROUP BY USr_CreatedON; it counts the...

Hello All, I'm using SQL Server7.0 and having trouble using COUNT(). tblAddresses Add_referenceID = USER ID Add_Region = STATE tblContacts Cnt_referenceID = USER ID Cnt_Gender = 'M' or 'F' What I want to do is get a count of Female Users and a count of Male users per state...

I have a field that is broken into subset's of data seperated by comma's. table looks like: tblAnswers Ans_QuestProdID = Relates to Product Ans_Quest = Relates to Question Number Ans_String_Val = Is the answer to the Question Ans_UserID = User ID This is a Data...

How do I produce the report were columns are group into Ans_String_Val for specific Ans_Quest tblAnswers Ans_QuestProdID = Relates to Product Ans_Quest = Relates to Question Number Ans_String_Val = Is the answer to the Question Ans_UserID = User ID If...