Forum Replies Created

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

  • RE: Bulk insert does nothing

    what is the source of the file...i had an issue before where the source was UNIX based text files, so the terminator is not \n, but another...\r (just Cr) ?...

    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 19, 2007 at 11:03 am

    #690527

  • 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

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