Search results for query: *

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...

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...

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...

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...

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...

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...