Viewing 15 posts - 21,691 through 21,705 (of 22,195 total)
If I understand the problem correctly, what about:
CREATE PROCEDURE x
(@ParamList XML)
AS
DECLARE @iDoc int
EXEC dbo.sp_xml_preparedocument @iDoc OUTPUT, @ParmList
INSERT INTO dbo.MyTable
(Id, Value)
SELECT
(Id, Value)
FROM OPENXML(@iDoc, '/MyParameterList',1)
WITH(Id int '@Id',
Value varchar(50) '@Value')
EXEC dbo.sp_xml_removedocument @iDoc
GO
That will...
October 9, 2007 at 11:41 am
Please don't cross-post the same question.
http://www.sqlservercentral.com/Forums/Topic408403-338-1.aspx
And I agree with the initial response.
October 9, 2007 at 7:38 am
Maybe I'm confused by the question, but are you looking for a SELECT statement? Something like:
SELECT o.OrderId
,o.Custermer
,d.ProductId
...
October 9, 2007 at 7:37 am
Most systems do some form of option #2. The main reason being, reporting. Your basic report engine just isn't going to be able to figure out the bit mask the...
October 9, 2007 at 7:22 am
You should look at the number of scans and reads each one is doing. Time is nice & all, but for most queries, reducing scans or reads leads to reductions...
October 9, 2007 at 6:58 am
It is possible, but as Colin has noted, it's definitely not the right approach. If you were to try it, the trick would be to only use a single parameter,...
October 9, 2007 at 6:55 am
What data type is the BadPasswordTime inside the database?
October 9, 2007 at 6:40 am
What about using sqlcmd to control the execution & output of the script?
There are not TSQL commands that take control of Management Studio and its behavior.
October 5, 2007 at 11:41 am
Please repost over in the 2000 forum to get 2000 specific help.
October 5, 2007 at 11:39 am
Everyone's favorite answer: it depends. If you have an inline function that is returing a table value, it effectively works like a view and the query processor blows out the...
October 5, 2007 at 7:11 am
I'm not sure it's a secret, but I can click on the Object Explorer window, say on the "Tables" folder within a database and there it is.
October 5, 2007 at 6:05 am
You got it? Cool. It's a neat little trick that I learned from a Microsoft Consultant. It's good to see other people find it useful too.
October 4, 2007 at 12:00 pm
Yeah. I put it that way in case, like us, you have a compound PK.
October 4, 2007 at 9:47 am
I'd stay away from table valued functions unless performance is completely not a concern.
The cross apply should only return a single value such that you'd get more than one row,...
October 4, 2007 at 9:17 am
Hmmm. Not an easy one. I looked through the code, I generated the query. Everything looks ok, assuming the data types in the tables are as presented, with one possible...
October 4, 2007 at 9:00 am
Viewing 15 posts - 21,691 through 21,705 (of 22,195 total)