Viewing 15 posts - 5,791 through 5,805 (of 7,164 total)
Jeremy-475548 (6/28/2011)
Just curious:Is the except statement just syntactic sugar for "Where Not IN" or is there some additional optimization magic that goes on behind the scenes?
It's quite different from WHERE...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 2:10 pm
One other option...from this forum post:
4 If you dont want to create an EXCEL file in advance and want to export data to it, use
EXEC sp_makewebtask
@outputfile = 'd:\testing.xls',
@query...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 2:06 pm
anjali3386 (6/28/2011)
Have another question...
I want to insert results from sp_depends into a table
SET @sql = 'USE '+@db_name+' EXEC sp_depends '+ @table_name
insert into ##tmp
EXEC (@sql)
But with that I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 1:38 pm
Ninja's_RGR'us (6/28/2011)
How much faster is it?
Depending on the use case it can be pretty significant, but it depends on the use case and the data of course. The UDA outperformed...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 11:35 am
Here is one other option that seems a bit more intuitive to me but that requires the use of SQLCLR.
This:
with CTE as
(
select name,nameid
from #names
)
SELECT
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 11:08 am
praveensc2003 (6/28/2011)
I have around 1 lakh data stored in Excel.Is it possible to insert this data in to SQL SERVER using Bulk Insert Task?
To clarify, no, you will not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 10:51 am
lk-681111 (6/28/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 10:37 am
Thanks for posting back. I bet you could have cut that time in half, at least, if you had used T-SQL (as bitbucket-25253 suggested) instead of SSIS.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 10:21 am
SQLRNNR (6/28/2011)
Here's an article discussing the steps referenced by opc.threehttp://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx
Thanks Jason, I will keep this one to pass along, at least until Jeff publishes his article on how to manage...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 9:41 am
Is xp_CmdShell enabled on the instance? Have you setup the proxy?
If I may ask, what's the goal of granting exec permissions to xp_CmdShell? Maybe there is a cleaner way...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 9:29 am
k.thanigaivel (6/28/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 7:35 am
Nadrek (6/28/2011)
opc.three (6/27/2011)
Like I said, not arguing anything you said. Compliance was not the issue at hand in my scenario.
Setting compliance aside, is even broaching the subject of ancient software...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 7:14 am
k.thanigaivel (6/27/2011)
Dear opc.three,sorry, my result same as your result. I need with out change as '<tst>1>0</tst>'
Sorry, you cannot, the > is a reserved character in XML for use as part...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 6:57 am
Jeff Moden (6/27/2011)
opc.three (6/27/2011)
SELECT jc.OrderNum,
dbo.GROUP_CONCAT(DISTINCT OrdCountry) AS OrdCountries
FROM ...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 6:49 am
Jeff Moden (6/27/2011)
opc.three (6/27/2011)
stormsentinelcammy (6/27/2011)
Please post how to select the tables belonging to a certain schema 🙂
Please start a new thread 🙂 The OP wanted to know if it was...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 28, 2011 at 6:39 am
Viewing 15 posts - 5,791 through 5,805 (of 7,164 total)