Forum Replies Created
Viewing 15 posts - 31 through 45 (of 363 total)
-
RE: Remote user defind functions
Yes, in my exper. also... you need to...
select * from dbo.MyFn('value1', NULL) --- at the very least
Oh well, SQL's 1st time with UDFs,...
Once you understand the BITs, all the pieces come together
-
RE: Remote user defind functions
Off the top, I think both SPs and UDF can have default values, but UDFs require at least a NULL in each params.
Once you understand the BITs, all the pieces come together -
RE: Remote user defind functions
You can always insert into a #Temp table using either OpenQuery or Server.DB.dbo.sp_Execute ...,
then JOIN the #Temp table. This may be better for the optimizer to deal with anyway.
Once you understand the BITs, all the pieces come together -
RE: Remote user defind functions
Seems 4 part UDF naming conventions are NOT supported in SQL2K.
see http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319138
Once you understand the BITs, all the pieces come together -
RE: Remote user defind functions
Interesting...
It doesn't work with a param unless you use dynamic SQL, but here's something to start with...
select * from openquery(Server, 'Select * From db.dbo.fnMyFunctionName()' ) T1
Once you understand the BITs, all the pieces come together -
RE: How to get out EXEC(T-SQL) data?
Thanks Mith
I'm kind of interested in actual timed results with a number of records that would realy make a difference... maybe 500K rows down to a couple or few.
And... what...
Once you understand the BITs, all the pieces come together -
RE: Slow SQL Server 2000 Performance
SQL Server "Profiler" is the generic answer to your generic question. I'd much rather see you target very specific areas of performance concerns... particular query, particular procedure, application connection time, application...
Once you understand the BITs, all the pieces come together -
RE: How to get out EXEC(T-SQL) data?
I understand
I know you can "edit" your post. Noel, can you try to "delete" 2 of the 3 posts? or maybe at least...
Once you understand the BITs, all the pieces come together -
RE: Select Statement
Sagar, check out some of the "script" resources on this site at http://www.sqlservercentral.com/scripts/categories.asp?groupname=SQL%20Server%207.0/2000&groupid=1 either Misc. or TSQL aids, search for "pivot" etc.
Please post back to this thread if (or not)...
Once you understand the BITs, all the pieces come together -
RE: How to get out EXEC(T-SQL) data?
Ok Noel, we get the point... what happened a "triple-click" ?
Once you understand the BITs, all the pieces come together -
RE: Count and Update?
Hitek, a few questions...
1. Make sure I understand...
1, 40, 'M', 'Bob', 'Mr', ''
1, 40, 'M', 'John', 'Mr', ''
1, 40, 'F', 'Betty', 'Mrs', ''
1, 40, 'F', 'Jane', 'Mrs', ''
Becomes
1, 40, 'M',...
Once you understand the BITs, all the pieces come together -
RE: How to get out EXEC(T-SQL) data?
Interesting point Mith...
Can you post what the estimated execution plan shows when using Jack's syntax? Does it show anything? because OPENQUERY just shows "Remote Scan" which is useless to...
Once you understand the BITs, all the pieces come together -
RE: To View or not to View
I think what srankin is saying, is that if you have a SELECT that JOINS and aggregates your data, and then you create a VIEW based on that SELECT (less the WHERE clause...
Once you understand the BITs, all the pieces come together -
RE: SQL statement help needed (2)
I just like posting into threads with Frank
. I did not mean Rob specifically either, at least Rob posted that "a solution...
Once you understand the BITs, all the pieces come together -
RE: store stored proc results into table
Also...
Do NOT use this in a loop or Scalar UDF. This method adds overhead, and should be used as a "last resort". Do not use this method just for...
Once you understand the BITs, all the pieces come together
Viewing 15 posts - 31 through 45 (of 363 total)