kbaisch
Last Activity: Aug 29 '08, 06:34 PM
Joined: Mar 10 '07
Location:
-
Thank you very much, that works. -
This formula is to be added to the check5 box “check box” on lost focus in the properties. If the box is check then I want todays date to appear in the received_date box, if it’s not checked then I want received_date to be blank with no date. So the check box comes first then the date box.Leave a comment:
-
In other words, if the check box isn’t checked then I don’t want a date in the received_date field, if the check box is checked then I do want todays date in the received date_field.Leave a comment:
-
I am trying to say, if check box, Check5, is not checked then the field "recieved_d ate" is null else todays date. Am I totally doing this wrong? Does this help you?Leave a comment:
-
Help on Access Expression
Can someone tell me why this expression doesn't work in the build function of a form? Can a date be null? Check5 is a check box.
Thank you for the help.Code:=IIf([Check5]=0,[received_date]=Null,Date())
-
MS Project 2007 SQL Server Enterprise
Does anyone know MS Project 2007 Enterprise?
Some of my projects won't check-in or delete, they just hang there. I
would like to go into the sql server db and run a delete query. Does
anyone know where I could get a schematic of the table relationships
so I know which tables have the info I need. Is this a terrible idea,
if so, how do I get the projects to un-hang?
I'm sorry in advance if... -
Filtering, sorting, summing
Can someone help me with the syntax? I want to sum the hrs for each dept, name & ppe. Any help given will be much appreciated.
Thanks in advance.
Dept_# Name PPE Hrs
533 Empl Name 4/15/2006 0
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
533 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
522 Empl Name 4/15/2006 8
540 Empl Name 4/30/2006 8
540 Empl Name... -
I'm sorry, I'm not very good at explaining. I'll try again....
I want to add more script to this procedure telling it to save this as a "certain file" ie, xls, doc, etc. and telling it where to save it on a server in a folder. I don't know how to write that. Can you help me with that?
Thank you for your help.Leave a comment:
-
this is the stored procedure I have to run the query on the deh05 server. Now i need to send this information to a folder in my deh02 server.
/*
Name: Testmovetofolde rs
Description: Move queries to folders on deh02
Author: Kim Baisch
Modification Log:
Description Date Changed By
Created procedure 06/14/07
*/
CREATE PROCEDURE .[Testmovetofolde rs]...Leave a comment:
-
Syntax for storing query results from one server to another server
Can someone help me?
I'm executing a stored procedure that runs a query. That works fine.
I need the syntax to tell the stored procedure to save it to another server in a folder. Any help would be much appreciated.
Thanks in advance. -
SQL Code for todays date -90 days
I have this code set up but I know the 3rd line is wrong. Could someone please help me on the code for pulling all entries for todays date -90 days? I would really appreciate it and thanks for helping.
SELECT *
from view1_4t
where DOB_ = (getdate()-90)
GO -
Importing views from one server to another server
I imported tables and views from one server to another server. The views imported as tables. I want the views to import as views. Can someone explain to me what I did wrong? -
Delete Time out of Date/Time column
I have a column with smalldatetime data type. When I run a query, it shows date and time, I only want the date adn to delete the time. It looks like this:
1979-04-25 00:00:00
What is the script to just get the date?
Thanks -
It WORKS!! I can't thank you enough!...Leave a comment:
-
Remove spaces in a column
I have a column in a table in an SQL server that has unwanted spaces. I have tried this code and it doesn't work.
UPDATE Petersburg_ SET Residence_ = REPLACE(Residen ce_,',',',');
Column data looks like this:
AKIAK, AK
PETERSBURG,AK
I don't want any spaces in front, between or end.
Can someone help me? Please? -
By "temp table" do you mean a table in SQL? It won't load in SQL, that's my problem. It just hangs up and does nothing, status staying at 0. Any suggestions? Thanks for your help....Leave a comment:
-
Importing a notepad txt file into SQL 2000 Server
I have been trying to import a notepad txt file into my SQL server. I go through the routine of importing it, either through table or DTS and it just hangs up, nothing happens. Do I need to parse the text file first? If I need to parse it, how do I do that? Does anyone have any idea on why it won't import? Thanks for helping. -
Thanks Bergy, I'll give it a try....Leave a comment:
-
SQL 2000 renaming columns in tables
This code works in query analyzer to rename one column in a table, can someone please give me the script to rename more than one column in a table and along with that, I need to change the data type (length) while I'm at it.
sp_rename 'medicaid.col00 1', 'id', 'COLUMN'
No activity results to display
Leave a comment: