Viewing 15 posts - 2,041 through 2,055 (of 3,221 total)
Heh... I thought drinking was mandatory!
--Jeff Moden
Only when it is NOT the server that has payroll data for the entire staff.
March 6, 2010 at 1:20 pm
This is an Excel problem not a SQL problem.
Search Technet for excel 2000 2007 differences and you will find about 2,400 articles ... explaining the different formats / how formulas...
March 6, 2010 at 6:02 am
Looked today at 6:16 PM USA East Coast Daylight Savnings Time
2005 Devloper - new 43.63 used CD 38.47
2008 Developer - new 43.63 used CD - none listed
March 5, 2010 at 4:18 pm
Lynn Pettis Posted Today @ 10:36 AM
I'll give you one right now as i have already seen it posted in other threads: Wait a day, the next days email newsletter...
March 5, 2010 at 9:12 am
kaspencer (3/5/2010)
then one must be careful to ensure that the questions are properly phrased, in correct English
May I point out that the SSC community includes members from countries world wide,...
March 5, 2010 at 8:02 am
When running the sp_helprotect @username = 'public' take careful note of all those commands that can be EXECUTED by the public role... be sure you want to allow...
March 4, 2010 at 4:47 pm
rhfishman
Can you give me a clue how to get optional selecting and sorting?
Use and IF ELSE statement (From Books On Line)
IF Boolean_expression
{...
March 4, 2010 at 4:38 pm
bitbucket-25253 (3/4/2010)
--------------------------------------------------------------------------------
When a DB is backed up ... tables are backed up in their entirety. Not just changed/added rows.
Sorry about that ... just assumed (and you know what that means...
March 4, 2010 at 2:02 pm
When a DB is backed up ... tables are backed up in their entirety. Not just changed/added rows.
Would examining the logfile violate the ERP's support?
Can you run a Trace...
March 4, 2010 at 1:15 pm
Jonathan Turlington
Not knowing your actual table structure / indexes etc., etc. My temp table did not have an index, so my code would run using a table scan...
March 4, 2010 at 12:54 pm
rhfishman
To receive assistance ... please read the first link in my signature box so that those who want to assist you can do so with a tested solution.
March 4, 2010 at 12:34 pm
I need to know when a CSR rep adds or changes one of these address in the last 24 hours.
How does the CSR add/change an address i.e., through...
March 4, 2010 at 12:15 pm
Is this what you are looking for
CREATE TABLE #Installers(id INT,daysWorked INT)
INSERT INTO #Installers
SELECT 1,5 UNION ALL
SELECT 2,4 UNION ALL
SELECT 3,3 UNION ALL
SELECT 4,0
SELECT id, CASE
WHEN (daysWorked...
March 4, 2010 at 10:08 am
Might I suggest that your read:
How to convert an Access database to SQL Server
http://support.microsoft.com/kb/237980
and/or
SQL Server Migration Assistant 2008 for Access V4.0
March 3, 2010 at 8:20 am
Viewing 15 posts - 2,041 through 2,055 (of 3,221 total)