Forum Replies Created

Viewing 15 posts - 9,976 through 9,990 (of 13,460 total)

  • RE: strange query to get data

    Andrew I'm second guessing the purpose of the function....

    is it just getting the # rows for a given table? is it being called 1000 times, one for each table?

    if 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 12, 2010 at 11:15 am

    #1118172

  • RE: error with sp_trace_create

    nevermind.

    my error was this:

    set @options = 0

    the allowed values for @options is 2 in my case.

    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 12, 2010 at 8:56 am

    #1118082

  • RE: Get SQL Server Version Using sp_oa procedures

    my pleasure and thank you very much for the complement!

    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 11, 2010 at 2:05 pm

    #1117769

  • RE: Get week plus year usind date column in another tabel

    your question was missing a lot of things that we'd need to join your two tables together, ket alone insert into one of them.

    give us some more details: the CREATE...

    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 11, 2010 at 9:57 am

    #1117644

  • RE: Get SQL Server Version Using sp_oa procedures

    MJ I'm not sure on the whole sp_oa option, but if you create linked servers to each of your networked SQL servers, you can query them with an OPENQUERY 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 11, 2010 at 8:36 am

    #1117602

  • RE: Date constraints

    well, you've got a logical error first:

    dates should not be varchars...use datetime datatypes.

    CREATE TABLE Table1

    (ID int,

    Enter datetime)

    second, if you want a specific format, validating it to be 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 11, 2010 at 7:50 am

    #1117572

  • RE: Data disappearing from tables mysteriously

    are there any triggers on the tables? it could be that you enter data into an application like your new customer account, and when it updates, the trigger fails 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 10, 2010 at 7:35 pm

    #1117312

  • RE: How to Reverse Engineer the Current Settings for sp_trace_create

    OK here's my prototype for scripting out the traces;

    I created a procedure where you have to pass the trace id, and it seems to script everything out .

    note this assumes...

    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 10, 2010 at 10:58 am

    #1117021

  • RE: How to Reverse Engineer the Current Settings for sp_trace_create

    Craig thank you! that was the piece could not find;

    i was locked into looking for a sys view that had the joining information...with what you posted I could get 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 10, 2010 at 8:12 am

    #1116853

  • RE: How to Reverse Engineer the Current Settings for sp_trace_create

    for me, reverse engineering is to be able to script out any and all traces that exist on the server;

    the whole script like this:

    --create the trace

    exec sp_trace_create...

    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 10, 2010 at 7:00 am

    #1116780

  • RE: Needed: An ADD CODE Button and Form

    CirquedeSQLeil (2/8/2010)

    There will still be some who do not do it (Urgent...), but overall I think more people would use it.

    those "Urgent" posts are like a train wreck or nasty...

    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, 2010 at 10:22 am

    #1115644

  • RE: DBCC Timewarp

    you guys have show some great examples of using a future backup to fix todays data, but I've got a question along a similar vein:

    somehow I've forgotten to create 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 8, 2010 at 10:15 am

    #1115637

  • RE: Replace Function in SQL 2005 and 2008

    isn't the REPLACE function overloaded, so there are actually multiple "replace" functions that are used based on the parameters passed?

    I'm sure the same thing was discussed on the COALESCE...

    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, 2010 at 10:10 am

    #1115633

  • RE: WILD REPLACE ?

    you replied while i was editing my original post;

    here's one way; i'm testing a Tally solution now:

    here's a simple way using a WHILE Loop:

    --===== Replace all [' and ']' pairs...

    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, 2010 at 8:29 am

    #1115538

  • RE: WILD REPLACE ?

    Can you explain a little more?

    if i had THIS as a comment:

    declare @text varchar(4000)

    SET @text = Without a doubt SQLCentral is home to finest SQL folk[comment:#grovel].

    Sometimes things may get heated[comment:#super...

    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, 2010 at 8:23 am

    #1115534

Viewing 15 posts - 9,976 through 9,990 (of 13,460 total)