Viewing 15 posts - 2,971 through 2,985 (of 3,232 total)
SELECT *
FROM Table1
INNER JOIN Table2
ON Table1.Date = Table2.Date
WHERE CONVERT(varchar(10), Table1.Date, 101) = '03/24/2006'
March 24, 2006 at 3:48 pm
You would need to do it as part of the insert. I don't know of a way for an update statement to work as SQL Server will have difficulty converting...
March 24, 2006 at 3:41 pm
Take the double quotes off of "| GSL Account Search". Use single quotes. Also, you have multiple stray commas in your insert statements. If you include the column name in...
March 24, 2006 at 1:30 pm
March 24, 2006 at 1:23 pm
You cannot schedule a job to run more often than 1 minute. What are you trying to do that needs done every 3 seconds?
What is the error message that you...
March 24, 2006 at 1:13 pm
You usually want to start your performance monitoring at a high level using only the basic counters for monitoring CPU, Disk I/O, and Memory. If you find out that either...
March 24, 2006 at 9:50 am
If your drives become unavailable or full, SQL Server will mark your database as suspect, so if your database is available, the drives that hold your database files are also available. ...
March 24, 2006 at 9:38 am
Go into the SQL Agent>>Jobs view and look at the job properties. Who is set as the owner? Whomever it is needs to have permissions on your development server, so...
March 23, 2006 at 3:59 pm
I do not know how you could accomplish this with a standard t-sql script. I would say that you either need to create a vb script to check in your...
March 23, 2006 at 3:17 pm
Is there a reason why you cannot just use the host name?
March 23, 2006 at 9:39 am
What are you trying to connect with, EM, QA, ODBC? Are you getting any sort of message back? Can you ping the IP?
March 23, 2006 at 9:03 am
From an optimization standpoint, you may get better performance from your while loop due to the overhead that a cursor adds when allocating/deallocating, but then again, you may not. I...
March 17, 2006 at 4:08 pm
The only way you will be able to significantly reduce the amount of time this takes is to re-engineer this SP to get away from row-by-row processing. Removing the cursor...
March 16, 2006 at 3:59 pm
Depending on how many tables you are talking about and how complex the data, I would look into creating a DTS package that can do your data pump and schedule...
March 14, 2006 at 3:51 pm
How often, every day, every hour, real time? How much data? Can you give a more detailed description of what you want to accomplish?
March 14, 2006 at 2:33 pm
Viewing 15 posts - 2,971 through 2,985 (of 3,232 total)