ThomasH

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 362 total)

RE: Saving stored procedure result to a variable

If you are not calling the UDF in a loop (for perfomance reasons), something like ...
SELECT * FROM OpenRowset('SQLOLEDB', 'Server=(local);Trusted_Connection=yes',
'SET fmtonly OFF
exec master..xp_logininfo ') A
WHERE [Account Name] = 'BUILTIN\Administrators'
inside your UDF....

February 18, 2004 at 7:17 am

#494509
RE: Saving stored procedure result to a variable

I am sure there is a solution to what you want. Can you provide a bit more specific information? Are you trying to call an SP that retruns a result...

February 18, 2004 at 6:47 am

#494504
RE: Syncronizing SQL Servers in t-sql code

If you do not need indexes, just table structures, you could, while the target is current and the tables do not yet exist on the target...
SELECT * INTO TableName FROM...

February 18, 2004 at 6:44 am

#494503
RE: Set SINGLE_USER in a scheduled job

If you look at the "step details" of your job history, does it indicate any errors?

February 18, 2004 at 6:28 am

#494502
RE: "Disappearing" Table. Why?

I tried Mike's suggestion of using ODBC instead, and the "disappearing table" symptom is no loger there. i.e. Its "fixed" now . Thanks.

February 17, 2004 at 12:32 pm

#494423
RE: An Introduction to Database Models

Frank, nice to see you back. I've also been gone a couple of weeks (not voluntarily - on the road/busy).
Thank you Frank and to all of you for making interesting...

February 17, 2004 at 12:11 pm

#494420
RE: Temp Tables in SQL Server

What is the reason the article states:
When creating temporary tables, do not use SELECT INTO statements, Instead of SELECT INTO statements, create the table using DDL statement and use...

February 16, 2004 at 3:21 pm

RE: SQL on Win2003 does not recognize unc path

I seem to remember a similar issue I had even with SQL2K. To get around the problem, I performed a simple "dummy" EXEC xp_cmdShell 'DIR \\PCName\Sharename' to "kick" SQL Srv into...

February 16, 2004 at 2:46 pm

#494260

RE: Can I stop this from Table scanning ?

What is the range of @yesterday_from and @yesterday_to?

What is the range / distribution of dates in c.datetime?

If the optimizer thinks that just a...

February 16, 2004 at 2:40 pm

#494258

RE: Complex Design

Is the data actually just plain old readable text like a book? and you just want the potential user to navigate through some sort of "Tree View" representing a Table...

February 16, 2004 at 2:34 pm

#494256

RE: Can some one suggest

And maybe CREATE TRIGGER ... INSTEAD OF INSERT ....

for inserting into the partitioned view while having new records going to correct uderlying table.

February 16, 2004 at 2:29 pm

#494254

RE: Q about using functions in select statements

I agree with the above comments. Also, I've found using a UDF instead of "inline" calculation is almost always slower (I have not found it to be faster, ever... but who...

February 16, 2004 at 2:26 pm

#494253