Forum Replies Created

Viewing 15 posts - 12,691 through 12,705 (of 13,459 total)

  • RE: SQL Server 2000, Query Results To Text File question??

    here's an example i had handy: filename is build with a combination of variables and current time/date.

    replace your query  where the query in red is below.

    declare @outfile    varchar(250),

            @strCommand...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 16, 2007 at 2:35 pm

    #690333

  • RE: Updating a field automatically when keying in one field

    hehe... same example, but i beat your post by a whole minute!

    great minds and all that.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 16, 2007 at 2:01 pm

    #690327

  • RE: Updating a field automatically when keying in one field

    in sql server , you can use a calculated column; (not available in oracle...you'd have to create a trigger to do the same thing); note i added logic to watch...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 16, 2007 at 1:56 pm

    #690324

  • RE: DLL''''s function results into SQL server.

    Eddie thanks; you pointed me on the right track; by using the sp_Oa procs, and  a bit of minor modifications to my test dll, i was able to read any...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 16, 2007 at 9:11 am

    #690261

  • RE: Access 97 and SQL 2000

    could it be something as simple as statistics or something?

    I had a situation where a developer turned off automatic statistics in his test database, and over time his machine...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 16, 2007 at 5:09 am

    #690172

  • RE: Outputting Image Data to a File

    check out this recent post:

    there's no native way I know of to use TSQL to create the image...the image data is usually handled by an object that can handle a...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 16, 2007 at 4:51 am

    #690167

  • RE: How to check All Table Name used in the sp without using Sp_depends

    check out this recent thread on the same subject:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=333827

    a few different examples were given on how to search syscomments, especially how to avoid the rare situation where a tablename...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 16, 2007 at 4:43 am

    #690166

  • RE: matching pattern

    search for the Split function in the scripts section of SSC; there are several that will do this.

    searching for Split in the forums will get you loads of ewxamples as...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 15, 2007 at 11:10 am

    #690030

  • RE: Trace modifications to SQL objects

    someone has posted something similar in the script submissions as well:

    http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1584

    Notification of schema changes - Advanced

    Script Rating

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 15, 2007 at 6:17 am

    #689919

  • RE: ADODB.Recordset error ''''800a0cc1'''' .Item cannot be found in the collection.

    somewhere in the report, it is referencing a column that does not exist in the SQL statement returned into the recordset. a valid  recordset was returned, and has rows, otherwise...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 15, 2007 at 4:39 am

    #689900

  • RE: Query Help

    you typically use ORDER BY new_id() to randomize results:

    SELECT top 5 CATEGORY_NAME ,ASSETS_NEEDED_FOR_ASSIGNMENT FROM MYTABLE ORDER BY NEW_ID()

     

    run it multiple times, and you'll see the data is random.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 14, 2007 at 12:55 pm

    #689804

  • RE: what is the formula to get the table given hex figure..

    you should be able to use the object_name function without translating to decimal:

    select object_name(0x4319E038)

    select object_name(0x60FC61CA)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 14, 2007 at 11:29 am

    #689785

  • RE: create a table on a 2nd SQL server via linked server

    ok how about this: can you do this to the linked server? using the SELECT ...INTO feature, but make sure the where statement returns no rows, so it creates the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 14, 2007 at 9:51 am

    #689749

  • RE: DLL''''s function results into SQL server.

    I think that's my next step.... I was looking for an easy sleazy way to get results from any old DLL, but I think I'll have to slap together an...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 14, 2007 at 9:43 am

    #689741

  • RE: HELP with error ''''80020009''''

    you didn't post any changes, so I'm assuming you are still not checking for nulls.

    add this function to the page:

    Private Function tnull(s) As String

        If IsNull(s) Or IsEmpty(s)...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 14, 2007 at 9:00 am

    #689727

Viewing 15 posts - 12,691 through 12,705 (of 13,459 total)