Forum Replies Created

Viewing 15 posts - 11,236 through 11,250 (of 13,460 total)

  • RE: Select and comparison across columns

    sounds like nested case statements might be what you need, but it's help enourmously if we had some sample data and expected results;

    are you trying to identify where there are...

    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!

    April 13, 2009 at 7:47 pm

    #976999

  • RE: problems with a query

    the trick here is to join a table against a copy of itself...to do that, you need to alias one or both tables;

    something like this is pretty close, 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!

    April 13, 2009 at 7:28 pm

    #976996

  • RE: merge four tables with common ID/one result into one table with five columns?

    I'm making some minor assumptions, and changed your query accordingly;

    if there is an employee id in SGA_Labor, we KNOW he has a name, right? so we can assume that 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!

    April 13, 2009 at 6:29 pm

    #976988

  • RE: can any one help me out??

    if you were to post CREATE TABLE... information, as well as the INSERT INTO...scripts, we could help you much better; even with your followup answer, it is still not clear...

    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!

    April 13, 2009 at 2:57 pm

    #976886

  • RE: can any one help me out??

    I'm not sure oif the requirement.

    Do you want to be able to see all the statuses in Database7, if one gets added in Database5 for example, or do you want...

    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!

    April 13, 2009 at 11:57 am

    #976779

  • RE: Move table between filegroup : NO Primary keys

    can't you just do the following:

    build a new table on your secondary file group with the same structure,

    insert into it,

    rename the old

    rename the new?

    isn't that effectively what...

    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!

    April 13, 2009 at 6:39 am

    #976513

  • RE: Performance issue with tally solution

    All I did was confirm your code is essentially the same on my SQL2005/1Gig ram 2.8 machine.

    My first guess was because you were using a @table variable for your Tally...

    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!

    April 12, 2009 at 5:40 pm

    #976353

  • RE: What is real time ETL

    Extract, transform, load - Wikipedia, the free encyclopedia

    basically getting data from one source and bringing it into anohter , realtime would be as it happens or changes.

    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!

    April 10, 2009 at 10:57 am

    #975903

  • RE: RS in the object explorer

    i think you are after this command, which allows you to see structure of tables(but not hte data), as well as the text of procs and views, right?

    GRANT VIEW DEFINITION...

    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!

    April 10, 2009 at 10:42 am

    #975893

  • RE: Which is more efficient or does it matter?

    you'll want to simply Add these commands to the top:

    SET STATISTICS IO ON

    SET STATISTICS TIME ON

    --SET SHOWPLAN_TEXT ON

    then run your two queries together....actually run them a couple of times...

    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!

    April 10, 2009 at 10:37 am

    #975889

  • RE: Select all tables from all databases using T-SQL

    Kailash Mishra (4/10/2009)

    Hi,

    It's good query, but it not works in SQL 2000

    Is there any query, which will give the same outpur and can use in SQL 2000

    the query i posted...

    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!

    April 10, 2009 at 7:49 am

    #975753

  • RE: Query performance problem after sql 2005 migration

    ok i'm guessing your query got changed to make it less complex for the web...

    but there seems to be a some steps tha seem weird to me.

    if you yank 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!

    April 10, 2009 at 4:21 am

    #975642

  • RE: Query performance problem after sql 2005 migration

    there was a similar thread on the issue, and even though the person had updated usage, updated statistics, the issue did not clear until they DROPPED their current statistics, then...

    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!

    April 9, 2009 at 7:17 pm

    #975533

  • RE: Configure SMTP Server of your favorite web email.

    there was just someone else a day or two ago that got gmail to work; it trick was a weird port for secure connection,

    here's the link:

    http://www.sqlservercentral.com/Forums/Topic545821-146-1.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!

    April 9, 2009 at 7:14 pm

    #975530

  • RE: DML stats for Tables

    nothing exists automatically for this; you'll have to start a serverside trace, let it run for a while, and use the trace results to do your statistics;

    you can get 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!

    April 9, 2009 at 4:34 pm

    #975493

Viewing 15 posts - 11,236 through 11,250 (of 13,460 total)