Viewing 15 posts - 2,221 through 2,235 (of 3,221 total)
It appears that you are attempting to create a facility that already exists in SQL Server 2008 .... might I suggest that you use Books On Line (SQL help file)...
January 7, 2010 at 1:00 pm
You have posted your question in a SQL 2000 forum ... CROSS APPLY WAS introduced in SQL Server 2005 ...
For SQL 2000 CROSS JOINS exist and they exist in...
January 7, 2010 at 12:46 pm
As one who has been beaten from pillar to post during the discussion of QOD's that I have submitted and which where published ... I am sorry to say that...
January 7, 2010 at 6:46 am
jyoti_bhatt
Name Address Phone Age
aaa bbb 20
aaa bbb 40
ccc ddd 50
Is the above actually what is in your CSV file or is it:
Name Address Phone Age something something
aaa,bbb,20,,xxx,, -- where...
January 5, 2010 at 9:59 am
May I suggest reading the following
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
It has all that you want to know about interfacing with EXCEL and more, great sample code.
January 5, 2010 at 9:46 am
kaspencer
I suggest that before allowing a question to be used, the submitter must ensure that all assumptions and pre-conditions for the question be stated clearly. These assumptions would include...
January 5, 2010 at 8:23 am
ndixit
In order to receive help we need you to help us help you.
Please read the first article in my signature block and post the information accordingly. That is...
December 29, 2009 at 12:53 pm
dallas13
Sorry, but I am rather dense, and do not understand your amplified explanation. Some items is question:
1. Does user pass in a single parameter value?
2. If...
December 28, 2009 at 4:20 pm
Is this what you are looking for?
select @visa = @visa + @year --note removed '
Print @visa
SET @visa1985 = 'select '''+@visa+''''
PRINT @Visa1985
Returns:
561985
select '561985'
December 28, 2009 at 3:47 pm
yacov-1006505
Thank you for your feed back ....
December 28, 2009 at 3:23 pm
QML
Can you clarify your definition of size. Want to know the defined size, or the actual amount of data stored in a particular column or columns?
That said you...
December 27, 2009 at 12:38 pm
yacov-1006505
Please check the database properties, using SSMS, and see if the Auto Close open is set to "YES" or "No".
Do you measure performance in SSMS when you click the Execute...
December 26, 2009 at 9:01 am
Read this article, pay attention to the discussion of the undocumented stored procedure
SP_MSForEachTable
sp_msforeachtable is very similar to sp_msforeachdb, except executing the command against every table in the database....
December 18, 2009 at 4:48 pm
Not being an Excel expert, have you looked at background checking and its rules.
In Excel
Click your way down the Menu Bar:
Menu Bar
Tools
...
December 18, 2009 at 10:59 am
Viewing 15 posts - 2,221 through 2,235 (of 3,221 total)