Viewing 15 posts - 2,506 through 2,520 (of 3,221 total)
Like the majority of answers "It depends" I would suggest reading
1. http://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx
which discusses new features in SQL 2008. You can then select those features which directly...
July 12, 2009 at 9:08 am
eslam.amgad
The User can only run any storedprocedure which can only make select,delete,insert or update
Have you considered utilizing the T-SQL statement Execute AS ....?
From Books On Line
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/613b8271-7f7d-4378-b7a2-5a7698551dbd.htm
Sets the execution context...
July 12, 2009 at 7:36 am
RBarryYoung
Condition, definitely. Not quite as sure what condition, but I *think* it is the condition of being 75 (and older?).
Now now, having been born in 1932, I find longer...
July 11, 2009 at 7:00 am
This is a duplicate posting -- see
http://www.sqlservercentral.com/Forums/Topic748825-149-1.aspx
July 7, 2009 at 1:39 pm
A payroll system (in the U.S.A.) would normally contain columns for an array of payroll deductions. For example
1. Number of dependents declared
2. Filing jointly or as...
July 6, 2009 at 2:41 pm
I believe you might find the code, or something similiar enough to be adapted so that you can format the particular column as mumeric rather than text in this article.
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
July 3, 2009 at 7:02 pm
Try this and see if it works:
'In project references you MUST select
' Microsoft OLE DB Service Component 1.0 Type Library
' This in turn loads oledb32.dll into...
July 3, 2009 at 3:55 pm
Is this what you are looking for:
SELECT XCUSNR,SDGAC,SUM(CAST(SDSVAL01 AS INT)) FROM supoff_gac_LY
GROUP BY XCUSNR,SDGAC
Which returns:
XCUSNR SDGAC Total...
July 3, 2009 at 10:33 am
douglascfast
Try executing this command:
SELECT ASCII(SUBSTRING(ColB,1,1))AS 'Character Code', DATALENGTH(ColB) AS 'Length' FROM #MyTable
The character code for a blank character is an integer 32. Note that what you are really...
July 2, 2009 at 2:32 pm
shree dhavale
It would help those who will be attempting to help you if you provided the table structure, sample data and the T-SQL statement that you have attempted to utilize....
June 27, 2009 at 3:14 pm
May I request someone to help this OP .. I do not have SQL 2000 on any machine that has Excel 2007 and having a devil of a time with...
June 26, 2009 at 12:27 pm
If you have not yet discovered the reason for the reported error,
can you paste your connection string, and the exact error message and error number and I will attempt to...
June 25, 2009 at 1:58 pm
Hope this might help.... Excel 2007 uses a different dll. I have used it in OPENROWSET to export data.. Can you search your export wizard for:
Microsoft.ACE.OLEDB.12.0
Also you...
June 25, 2009 at 9:49 am
Suggest you examine the T-SQL function DATEDIFF in Books On Line (BOL)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5cb7105e-c68b-43c2-ab2d-80e525526e27.htm
Here is a very, very simple bit of T-SQL that will demonstrate the use of the function
DECLARE @StartDate as...
June 22, 2009 at 9:46 am
If you are using a stored procedure to input the data you could use:'INSERT INTO dbo.Patient(Patientid,fullname,flag)
VALUES(1002,'my full name is',UPPER('f'))
If using a stored procedure to extract the data and pass it...
June 20, 2009 at 11:47 am
Viewing 15 posts - 2,506 through 2,520 (of 3,221 total)