Forum Replies Created

Viewing 15 posts - 31 through 45 (of 629 total)

  • RE: The Certification Debate

    I think the problem is that the cert tests are often behind the development of the test. I have not even attempted a cert since Windows NT and one...

  • RE: Calculating the % diffreance of monthly average temperature

    Can you explain what is not sorting in the right order?

  • RE: Rolling Three-Month Average

    Given that you said you were new take the following example

    create table #Example_data (Tran_dt datetime,Sales_amount decimal(6,2))

    insert into #Example_data

    select '03/20/12',100.00

    union

    select '03/21/12',200.00

    union

    select '03/22/12',200.00

    union

    select '04/11/12',300.00

    union

    select '04/2/12',250.00

    union

    select '04/3/12',100.00

    union

    select '04/20/12',400.00

    union

    select '05/12/12',200.00

    union

    select '05/13/12',600.00

    union

    select '05/15/12',100.00

    union

    select '05/16/12',150.00

    union

    select '06/1/12',200.00

    union

    select...

  • RE: Rolling Three-Month Average

    While the where clause can easily be adapted to include three months the real question is in the group by statement. Also do you want an average over through...

  • RE: SSIS Package with SCD

    I would suggest you looking into replication services and log shipping and examine those to options. With replication services you could infact be realtime.

  • RE: Commas between numbers in Visual Studio

    If you right click on a test box in a report design you can choose TextBox Properties and then you should be able to define the format.

  • RE: SSIS Package with SCD

    There are many solutions and also several questions. when you say you are doing a datawharehouse are you just moving the data from tableA in the source to TableA...

  • RE: sql full text catalog stops updating

    Does anyone have any oppinoin on this?

  • RE: Like vs Contains

    Yeah automatic updates are on that was one of the first things I checked. I was a little surprised when I got the different results which was why I...

  • RE: Like vs Contains

    I have actually read all those already. What I did not see and have not found an answer for was why was a reboot of SQL server needed before...

  • RE: Like vs Contains

    So I have a bit more information. It seems if I have peaced the information together correctly that and index rebuild during reqular maintenace can cause the text catalog...

  • RE: T-SQL Question

    write the records as a string and add them to a variable as I did in my example this will cause the ouput of the variable to output one long...

  • RE: T-SQL Question

    Hopefully this will give you some ideas.

    declare @Tmp table

    (test1 varchar(5))

    insert into @Tmp

    select '1234'

    union

    select '4321'

    union

    select 'abcd'

    union

    select 'dcba'

    Declare @teststrng varchar(100)

    set @teststrng=''

    select @teststrng=@teststrng + test1 +...

  • RE: BOF to be added above columns in Pipe Line text file

    I would probably simply create a default template file with BOF already in it then simply open that to dump my ouput in. you can add in a renaming...

  • RE: Outsourced = Laid Off?

    Nevyn (8/3/2011)


    Dan.Humphries (8/3/2011)


    Nevyn (8/3/2011)


    cengland0 (8/3/2011)


    GSquared (8/3/2011)


    Government's role in human civilization is application of force. So, the moment it moves outside of defense against force, it turns into a problem,...

Viewing 15 posts - 31 through 45 (of 629 total)