Forum Replies Created

Viewing 15 posts - 11,191 through 11,205 (of 13,460 total)

  • RE: How to direct query analyzer result to a file using a command

    you cannot do that;

    While some programs, like SQLPlus for Oracle, interpret certain commands to change the connection or to direct the input to a file, SSMS and Query Analyzer only...

    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 22, 2009 at 6:15 am

    #982122

  • RE: How to Trace Executed Queries

    peace2007 here is what i use.

    it is a stored procedure i wrote, which creates a trace.

    It creates a trace and a view in the MASTER database; it includes 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 22, 2009 at 6:08 am

    #982115

  • RE: something starnge SQL ASP.NET Membership

    fairly straight forward. You need to take advantage of the OUTPUT command. this simple functionality kicks butt when playing with more than one row.

    build a temp table to catch 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 22, 2009 at 4:33 am

    #982052

  • RE: Stored Procedures

    since you are just setting the ReportId to a string plus the autoid, you could make the column a calculated field and be done with it:

    Alter Table TestingWork ADD NewReportId...

    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 21, 2009 at 10:26 pm

    #981939

  • RE: I need to merge 24 functions into 1

    kewl; once you post the actual functions, we'll be able to help; offhand, it looks like it could be replaced with a view that joins all your columns with joins...

    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 21, 2009 at 9:06 pm

    #981924

  • RE: I need to merge 24 functions into 1

    need more detail;

    is there 24 different formulas, one for each column in your customer table, or is it the same calculation, but placed in 24 functions? show us two of...

    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 21, 2009 at 6:50 pm

    #981892

  • RE: t-sql select help

    select the 2 rows having max date: TSQL pretty much writees the same way the question was outlined:

    if there are two records with the same max date:

    SELECT TOP 2 *...

    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 21, 2009 at 11:44 am

    #981665

  • RE: Newbie question for small query

    Your example below was what I expected;

    project is at the top of the data pyramid, but The grouping on the query looks ok to me;

    so....how is are the numbers...

    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 21, 2009 at 11:27 am

    #981655

  • RE: DTS- Incorrect syntax near Insert

    INSERT is a reserved word...I think you have a column named INSERT

    change the column name or wrap it in brackets or dbl quotes:

    [INSERT]

    or "INSERT"

    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 21, 2009 at 10:59 am

    #981635

  • RE: Newbie question for small query

    can you tell us why the numbers are "wrong"? grouping to get totals is pretty straight forward;

    i don't think it makes a difference, but your first table is THardware, is...

    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 21, 2009 at 10:53 am

    #981630

  • RE: Newbie question for small query

    i suspect the issue is you used all INNER Joins...that means ther MUST be data in all 5 tables for every project....intuitively, for example, i doubt every project has travel...

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

    #981562

  • RE: Splitting varchar fields into separate nonclustered index fields

    if it helps, this article, because it has screenshots, let me set up a full text on one of my tables in about a minute:

    http://www.userscape.com/helpdesk/index.php?pg=kb.page&id=142

    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 21, 2009 at 5:11 am

    #981315

  • RE: Splitting varchar fields into separate nonclustered index fields

    yeah i think this is a situation where you just have to jump right in with full text indexing. what you need is exactly what it was designed for, 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!

    April 21, 2009 at 5:00 am

    #981311

  • RE: Splitting varchar fields into separate nonclustered index fields

    for others reading brd's issue, we kind of kicked around searching via CHARINDEX on the same issue here:

    needing to develop a sql search for all words,...

    obviously, that would cost 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 20, 2009 at 9:09 pm

    #981167

  • RE: Constraint Execution Order

    they don't really get executed first or second.... it's more like ALL constraints, including whether a column is nullable or not, all get evaluated prior to the the insert 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!

    April 20, 2009 at 8:56 pm

    #981165

Viewing 15 posts - 11,191 through 11,205 (of 13,460 total)