Viewing 15 posts - 1,936 through 1,950 (of 3,221 total)
From Jeff's article:
Last but not least, I currently only have SQL Server 2000 and 2005 installed. I indicate which rev each section of code will run on in parenthesis
Emphasis added...
May 11, 2010 at 4:27 pm
Rebecca
I need to take the 1:many lead sources per account and return those as columns in my query so it will look like account, leadsource1, leadsource2, leadsource4, etc.
I suggest...
May 11, 2010 at 3:55 pm
vmrao
Your would most likely get more assistance if you posted your table definition and sample data as described in the first link of my signature block ... and with...
May 11, 2010 at 2:00 pm
First Excell 2007 uses a different ODBC driver than does previous versions of OFFICE products:
Dowload and install above:
Then to call Excel use:
'Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;'
Instead of:
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;'
Note: Not...
May 8, 2010 at 2:37 pm
May 7, 2010 at 9:58 am
ColdCoffee
First Excell 2007 uses a different ODBC driver than does previous versions of OFFICE products:
Download and install the above, then alter your OPENROWSET statement to:
Create the Excel workbook (Book1.xlsx) save...
May 5, 2010 at 12:49 pm
If this is a one time export ... believe the following link will assist you
http://www.sql-server-performance.com/articles/biz/How_to_Export_Data_to_Excel_2007_p1.aspx
May 3, 2010 at 5:21 pm
TRACEY-320982
--==Extracted segments only for Illustration purposes
DECLARE @L VARCHAR(10)
SET @L = 'Location'
CHARINDEX(@L,S) AS 'LocA',
,CHARINDEX(@L,REPLACE(S,'SITE ','SITE1')) AS 'LocB'
Please note. The parameter @L is only used to determine the position of...
April 25, 2010 at 9:33 am
DECLARE @L VARCHAR(10)
SET @L = 'Location'
SELECT id, S, CHARINDEX(@L,S) AS 'LocA', REPLACE(S,'SITE ','SITE1') aS 'Modified'
,CHARINDEX(@L,REPLACE(S,'SITE ','SITE1')) AS 'LocB'
--== notice blank (space) ^
FROM #Table
DROP TABLE #Table
/* Result:
idS...
April 24, 2010 at 8:47 pm
SELECT * FROM sys.all_objects ]
- will return information for all these database objects .. AGGREGATE_FUNCTION
CHECK_CONSTRAINT
DEFAULT_CONSTRAINT
FOREIGN_KEY_CONSTRAINT
PRIMARY_KEY_CONSTRAINT
SQL_STORED_PROCEDURE
CLR_STORED_PROCEDURE
SQL_SCALAR_FUNCTION
CLR_SCALAR_FUNCTION
CLR_TABLE_VALUED_FUNCTION
RULE
REPLICATION_FILTER_PROCEDURE
SYSTEM_TABLE
SYNONYM
SERVICE_QUEUE
CLR_TRIGGER
SQL_TRIGGER
SQL_INLINE_TABLE_VALUED_FUNCTION
SQL_TABLE_VALUED_FUNCTION
USER_TABLE
UNIQUE_CONSTRAINT
VIEW
EXTENDED_STORED_PROCEDURE
INTERNAL_TABLE
--------------
but as far as I know and as Lowell has stated it will not identify invalid...
April 22, 2010 at 6:05 pm
Your boss ,truly, has only one recourse. Hire a contract lawyer, and consult with that individual, and then decide how to proceed.
April 21, 2010 at 1:47 pm
rik gretzinger
The following is just to give you an idea of how the
problem could be solved, it is NOT the fastest way,
and if your parts and subparts tables...
April 20, 2010 at 3:40 pm
Viewing 15 posts - 1,936 through 1,950 (of 3,221 total)