Forum Replies Created

Viewing 15 posts - 12,721 through 12,735 (of 13,460 total)

  • RE: xp_cmdshell can''''t execute VBS

    to run a vbs file dont you need xp_cmdshell 'wscript.exe c:\Name.vbs' as the command?

    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 9, 2007 at 7:29 am

    #688826

  • RE: Split function input be column of a table

    function not supported by sql 2000....so you'll write your own function...um...that is also not supported?

    I think you mean simply not explicitly written by microsoft...technically all stored procs, functions, views, or...

    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 9, 2007 at 7:21 am

    #688821

  • RE: Split function input be column of a table

    curses on cursors! I am appropriately humbled. Thanks for putting me back on the path of enlightenment, Robert; I just couldn't "see" the subselect; nice solution.

    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 9, 2007 at 4:37 am

    #688773

  • RE: Split function input be column of a table

    eek I'm gonna say the words " only a cursor can solve this"; while I know cursor is the antithesis to all things SSC, sometimes you have to use 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 8, 2007 at 2:29 pm

    #688674

  • RE: Consolidating Multiple Stored Procedure Results

    i'm assuming the procedures return the same number of rows? or it's the same proc with different paramters, or that they return a single value?

    Hopefully this will get you started...

    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 8, 2007 at 2:13 pm

    #688670

  • RE: Find all fields with null values in table

    more than one way to do it, and lots of quick answers; that's why i love this site.

    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 8, 2007 at 2:04 pm

    #688668

  • RE: How do I isolate an SP''''s parameter values inside the SP generically? Please read

    remember that a stored proc is really just a formula, just like A2 + B2 = C2;

    A,B and C would have a datatype you can discover, but they do not...

    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 8, 2007 at 1:59 pm

    #688666

  • RE: Find all fields with null values in table

    here's a procedure that you pass the tablename...it cursors thru every column in the table, and if any column is null, adds it to the results table, and finally returns...

    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 8, 2007 at 1:45 pm

    #688659

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

    also, check the actual values:

    If rsLogin("UserType") = "user" OR rsLogin("UserType") = "cust" Then %>

    if rsLogin("UserType")  is NULL, an error would occur. check the table that contains the column UserType and...

    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 8, 2007 at 6:03 am

    #688520

  • RE: Problem calling a Non-Deterministic UDF in a Select Statement

    based on the error messge, it sounds like the function is calling a sotred proc in it's body; if you want to send me a priv message witht eh function...

    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 7, 2007 at 12:17 pm

    #688368

  • RE: Linked servers SQL 2000 to SQL 2000

    I think it's because your server name has single quotes in it, which is invalid. i know you can use double quotes, but not single.

    bad:  DRIVER={SQL Server};SERVER='ISERVER';UID=sql_dba_link;PWD=MyPwd;Initial Catalog=SQL_DBA

    good:  DRIVER={SQL...

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

    #688355

  • RE: Problem calling a Non-Deterministic UDF in a Select Statement

    does this return a value? this should do the same thing you did when assigning it to the @x variable.

    SELECT dbo.fnCalcBusHours( 1, 1, '8/31/2004 10:18:30 PM'

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

    #688349

  • RE: Show tables which use a data file?

    this might help: it shows each table, and what filegroup a table belongs to. if you only have ONE datafile per filegroup, then the table is contained in that datafile.

    if...

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

    #688347

  • RE: Date Checking

    i believe xdate1 is creation date, while xdate2 is last changed date?

    this would list all users that havne't changed their pass in >60 days i think. yould probalby use this...

    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 7, 2007 at 9:49 am

    #688328

  • RE: Problem calling a Non-Deterministic UDF in a Select Statement

    pretty much all functions have to be preceeded by the owner (usually dbo.)

    this will work:

    select Incident_Number, dbo.fnCalcBusHours(Cust_Id, Service_Id, open_time, close_time)

    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 7, 2007 at 6:31 am

    #688267

Viewing 15 posts - 12,721 through 12,735 (of 13,460 total)