Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tempo1
  • Content: Threads
  • Order by date
  1. tempo1

    sql server 2000, executing dynamic sql within a function

    Hi everyone, I have a procedure within whice i execute a function as follows:SELECT 'bbb', DBO.statusecond ('%aaa%', '20070801') COMMIT and a function that runs dynamic sqlexec(@dynamic). When it comes to running that dynamic sql i get the following error message: . Why is that ? Must i...
  2. tempo1

    sql server 2000 dynamic sql, concatenating with int param

    Hi everyone, I try to form a dynamic-sql command where an "int" param is involved and i dont know how to do it. My code is: /*EXEC statusecond 'aaa', '20070801'*/ ALTER PROCEDURE statusecond @stat_param VARCHAR(50), @date_param SMALLDATETIME AS BEGIN TRANSACTION DECLARE @year_stat INT SET...
  3. tempo1

    beginner's simple question-select image source

    Hi everyone, I want to load an image. At the "select image source" the "relative to" box, i'm required to choose either"document" or "site root" and i dont understand the implication of each selection. Can anyone explain me that ? Thanks
  4. tempo1

    word-page numbers, new page, contents

    Hi everyone, I'm accustomed to add page numbers to my "Word" documents. I tried to add "page numbers" from "Insert" menu item + "page number" but the "page number" menu item is dimmed and i cant do that. I use to make a "new page entry" pressing "shift+enter" keys but it is not working. I have a...
  5. tempo1

    sql server 2000, how much a table weighs ?

    Hi everyone In order to free disk space i need to identify tables and databases on the disk. Can i know a table's size (in bytes, not rows !) and database's size through system files in the SQL SERVER ? Any other resource to learn about my databases size ? Can anyone tell me what is the...
  6. tempo1

    sql server 2000 i'm looking for a function that returns

    a number showing the position of a certain character. Hi everyone, In my select query i want to display the position of the character '-'. My query goes like: select position(phone,'-') to show where the '-' of each phone number i situated. can anyone tell me what i should replace with ? Thanks...
  7. tempo1

    SQL SERVER 2000 adding a new user

    Hi everyone, My question is as simple as that: I want to add a new user for a particular database. That user should be working freely on that particular database (createing db, editing tables, removing tables) but he shouldn't have access to any other database and shouldn't have maste's...
  8. tempo1

    sql server2000, i need help with "xp_sendmail"

    Hi everyone, i run the following code (xp_sendmail)CREATE TABLE ##texttab (c1 text) INSERT ##texttab values ('Put your long message here.') DECLARE @cmd varchar(56) SET @cmd = 'SELECT c1 FROM ##texttab' EXEC master.dbo.xp_sendmail 'robertk', @query = @cmd, @no_header= 'TRUE' DROP TABLE...
  9. tempo1

    sql server 2000 sending mails

    Hi everyone, My table contains 2 columns:1. mame 2. email address. Is there a way to write a script that will mail a message to the whole list without me sending the message to each mail address separately? Thanks
  10. tempo1

    HTML - delivering a file using <form

    Hi everyone, I added a "FORM" in my html page to enable the user send me a file via mail. The code is: <html> <head> <title> send_me_a_file </title> </head> <body> <form action="mailto:mymail@mail.com?subject="myfile" enctype="text/plain" name="regiser" method="post">...
  11. tempo1

    mailing list

    Hi everyone, I have a table (sql server 2000) that contains 20000 email addresses. I need to send a message to each mail address and i wouldnt want to do it separately for each address. Is there a way to do it automatically through the outlook express ? sql server ? "excel? Thanks
  12. tempo1

    SQL-crystal reports

    hi everyone, I'm facing all kind of difficulties creating my SQL reports into Excel sheets. Is it worthwhile changing into "Crystal reports" ? The fact is, I have no idea what "Crystal reports" is. Is it a package i have to buy ? Is it part of the SQL SERVER 2000? Is it just a code ? Is there a...
  13. tempo1

    sql server 2000 problem in inserting varchar value into a varchar colu

    hi everyone, i created a table with a varchar column and when i tried to insert value into it as follows: declare @xxx table ( aaa varchar ) INSERT INTO @xxx ( aaa ) SELECT cast(333 as varchar) i recieved the following error message: can anyone tell me why ? thanks.
  14. tempo1

    sql server2000 looking for an &quot;alltrim&quot; function

    Hi everyone, My table contains a 300 width column but i dont want to show that width in my query so i'm looking for a function to "cut" empty spaces from that column. For example, if my column width was of 10 characters and contained something like "a", i'd like it to be "a" and not "...
  15. tempo1

    sql server2000 size of a column

    Hi everyone, I'd like to display sizes of a table using a query such as: SELECT SIZEOF(col1), SIZEOF(col2) FROM mytable can anyone tell me the keyword i should write instead of "sizeof" ? Thanks
  16. tempo1

    form-can i add a background picture ?

    hi everyone, i add a form to my page but i dont want it to have a flat white appearance. i'd like to add to the <form> label a backgroun picture something like:<code> <form bachground="mypic.jpg"> thanks.
  17. tempo1

    how do i backup outlook ?

    Hi everyone, I want to transfer messages, time table and lists from my outlook to another computer. How do i copy all that ? Where do i find (which folder) those files on the disk? Thanks !
  18. tempo1

    sql server 2000 a parametet inside dynamic sql

    Hi everyone i write a dynamic sql query in which a parameter is involoved:/*drop table table1*/ DECLARE @param1 VARCHAR(10) SET @param1='aa' DECLARE @dynamic VARCHAR(1000) SET @dynamic= ' SELECT ' + '@param1' + ' "param" INTO table1 ' print(@dynamic) exec(@dynamic) go and i dont know how to get...
  19. tempo1

    html-a table beneath another table

    Hi everyone, I'd like to create a page where there are 2 tables. The lower table should be beneath the upper table. My code: <html> <head> <title> his family </title> </head> <body background="../simpsons/1_1.jpg"> <p> <table align="left" width="45%" height="100"...
  20. tempo1

    SQL SERVER 2000 Dynamic sql is not working

    Hi everyone The code i wrote is: DECLARE @dynamic VARCHAR(1000) SET @dynamic= ' SELECT accountno "accountno" FROM fiftyplus..contact1 ' print @dynamic exec @dynamic not working ! I get an error message saying: And i cant figure out why ! Can anyone tell me whats wrong with it ? Thanks

Part and Inventory Search

Back
Top