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 Chriss Miller 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: *

  1. jegaby

    What would be a database efficient approach?

    One more thought to consider. If you want to put everything in a single table, without having to update existing queries/screens, you could do this: 1) Let's say your table is now called SatisfiedComments. Add a column to distiguish between satisfied and dissatisfied entries and then rename the...
  2. jegaby

    GetDate conversion

    Take a close look at the error message. It says you are trying to insert a charter string into a datetime column. What you want to do is insert a datetime into the datetime column. So simply remove the conversion: ... convert(int,replace("intran ttl adjd",',','')), "fcst stk si qty", "fcst cs...
  3. jegaby

    Update Telephone Numbers Format Change

    I assume that your problem is in dealing with the fields with two numbers, not in the formatting itself... You could use something like this.. SELECT CASE WHEN CHARINDEX(' ',LTRIM(RTRIM(telephone1))) = 0 THEN --put conversion for a single number here ELSE...
  4. jegaby

    User Control Issue

    I have had a similar problem. I work for a University and we have standard header/footer controls (user controls) that we use on each page so that all of our web pages are somewhat uniform. I am not sure the below is exactly right - but this is how I remember it. The problem has happend when I...
  5. jegaby

    Can you iterate through fields in a table?

    Here's a suggestion. I use a tool called TOAD. It was originally developed as an Oracle tool, but this year the vendor (Quest Software) has created a SQL Server version. This tool has lots of neat features, but one thing it allows you to do is select tables and export them as script files - you...
  6. jegaby

    Error when executing Proc with non default parameters

    This is a guess... Your #Missing table is a local temporary table, which is only accessible to your connection. xp_sendmail uses a bound connection to execute the query - which may mean that the local temporary table is not accessible within xp_sendmail. Try using a global temporary table...

Part and Inventory Search

Back
Top