Forum Replies Created

Viewing 15 posts - 5,326 through 5,340 (of 13,460 total)

  • RE: Identify and compare text between characters

    this thread is a duplicate of your previous thread here:

    http://www.sqlservercentral.com/Forums/Topic1320423-392-1.aspx

    both dwain.c and Chris@home, both posters I respect enourmously, gave you a couple of solutions, but you reposted your same question...

    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!

    June 25, 2012 at 10:49 am

    #1505177

  • RE: The OVER SQL construct or statement is not supported.?

    GSquared (6/25/2012)

    The most likely problem is that the database is in Compatibility level 80 (or earlier). Check that.

    that's what i thought, but when i tested it via TSQL, it...

    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!

    June 25, 2012 at 8:11 am

    #1505071

  • RE: Call Store procedures under trigger with do error handling

    What have you tried so far? That reads like a paraphrased homework assignment , so id like to see what youve tried

    .

    do you have the ddl for the table in...

    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!

    June 23, 2012 at 3:22 pm

    #1504776

  • RE: Finding a future date in a calendar

    ok i'm not sure how your calendar table is constructed.

    my calendar table has a row for each date,a s well as a flag for IsWorkDay or not.

    with my version, 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!

    June 22, 2012 at 3:34 pm

    #1504693

  • RE: Past 3 month's average every month

    here's a WAG, but it only seems accurate for the the periods that have three months in them

    With MyCTE (Date,Employee,Units)

    AS

    (

    SELECT CONVERT(datetime,'2012-05-01'),'Creamcheese,Suzy',4348 UNION ALL

    SELECT '2012-04-01','Creamcheese,Suzy',3482 UNION ALL

    SELECT '2012-03-01','Creamcheese,Suzy',2743...

    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!

    June 22, 2012 at 12:32 pm

    #1504663

  • RE: delete query returns no echo and doesn't delete

    not sure how many posters here will be familiar enough to debug php and mysql functions;

    with luck there might be a few folks out of the huge group of volunteers,...

    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!

    June 22, 2012 at 12:14 pm

    #1504656

  • RE: Database Mail to Distribution List

    mvillegascuellar (6/22/2012)

    Hi thanks for the response,

    But the distribution listis created in the domain, so it is visible from every other computer. I tested it from other computers and works correctly.

    distribution...

    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!

    June 22, 2012 at 11:24 am

    #1504647

  • RE: Delete query with like option is not working

    look at the WHERe statement in your query:

    where Input_type like 'COLD%'

    and Input_type like 'ChartMover%'

    it is impossible a string could START with both 'COLD%

    and 'ChartMover% at the same time.

    it's one...

    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!

    June 22, 2012 at 10:00 am

    #1504606

  • RE: Store output in Tables of Store Procedure which gives OUTPUT in more than 1 DataSet (Table)

    As far as I know, TSQL cannot consume Multiple Active Result Sets ;

    I've seen multiple posts on the question, but never saw a solution so far.

    most posts suggest breaking out...

    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!

    June 22, 2012 at 8:41 am

    #1504524

  • RE: Design question with shared tables

    my first suggestion is to change the names of the primary keys in the core tables themselves: DoorID, FinishID, and LeafID for example, based on your image you posted.

    you (in...

    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!

    June 22, 2012 at 8:26 am

    #1504515

  • RE: SQL formatting tools

    this one is free, but I don't have any experience with it.:

    http://www.architectshack.com/PoorMansTSqlFormatter.ashx

    for one that's not too expensive: $50 dollars:, i purchased this one for myself, and i can say i...

    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!

    June 21, 2012 at 2:59 pm

    #1504249

  • RE: Issue - Dont see transaction log shipping option in enterprise edition

    is it possible that you are using the Express version of SSMS to connect to a full blown Enterprise Instance?

    if you do Help...About in SSMS, does yours look like this?

    Microsoft...

    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!

    June 21, 2012 at 2:42 pm

    #1504236

  • RE: Trying to Find the Right Font

    i use a font called "Anonymous", which is a fixed width, sans serif font that looks kind of like verdana, i guess;

    i make that my default in a lot...

    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!

    June 21, 2012 at 2:04 pm

    #1504218

  • RE: Forgot local server password

    if you can connect as an admin, just reset the password;

    otherwise, you have to restart the service in admin mode and follow the steps here:

    http://beyondrelational.com/blogs/chintak/archive/2010/07/20/sql-2008-r2-new-installation-and-login-password-unknown.aspx

    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!

    June 21, 2012 at 2:00 pm

    #1504215

  • RE: Add invoice in stored procedure

    remember, we are on the other side of the interwebz here, and not looking over your shoulder. you've been looking at the issue for hours, and we onyl see three...

    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!

    June 21, 2012 at 1:14 pm

    #1504183

Viewing 15 posts - 5,326 through 5,340 (of 13,460 total)