Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RDCushing

    to replace and to create

    Well, I don't know about Oracle. However, in SQL Server, if a row has an IDENTITY column, you just omit that column from your INSERT statement and SQL auto-populates the column for you. Richard D. Cushing Sr. Consultant SYNERGISTIC SOFTWARE SOLUTION, LLC A Wholly-owned subsidiary of BDO...
  2. RDCushing

    Rolling Report for Last 13 months

    Try this: select case datepart(m,OpenDate) when 1 then 'Jan' when 2 then 'Feb' when 3 then 'Mar' when 4 then 'Apr' when 5 then 'May' when 6 then 'Jun' when 7 then 'Jul' when 8 then 'Aug' when 9 then 'Sep' when 10 then 'Oct' when 11 then 'Nov' when 12 then 'Dec' else '*** Error ***'...
  3. RDCushing

    to replace and to create

    You say that assessment.record_id is "auto generated", but if it is failing when trying to insert NULL, it clearly is not auto-generated by SQL (as an Identity column would be). How is [record_id] auto-generated? Richard D. Cushing Sr. Consultant SYNERGISTIC SOFTWARE SOLUTION, LLC A...
  4. RDCushing

    Data Loading issue

    The "Bind error" appears to be related to your attempting to bind a column from the data source that is longer than the destination column in SQL Server. You will likely need to truncate values in the column in the E-T-L process. Here's Microsoft's answer to your Error 1204: ACTION: Either...
  5. RDCushing

    Reporting Help

    Try this: select c.* , (select Phone from Telephones t where t.ClientID = c.ClientID and t.PhoneType = 'Work') as WorkPhone , (select Phone from Telephones t where t.ClientID = c.ClientID and t.PhoneType = 'Mobile') as MobilePhone , (select Phone from Telephones t...
  6. RDCushing

    Concatenate results into a string

    I agree with SQLSister: Try... select cast(Schedule.AAGRNUM as varchar(100)) + ' #' + cast(Schedule.Schedule_Number as varchar(100)) as Agreement_Number See what happens. Richard D. Cushing Sr. Consultant SYNERGISTIC SOFTWARE SOLUTION, LLC A Wholly-owned subsidiary of BDO Seidman, LLP
  7. RDCushing

    to replace and to create

    Would something like this work for you? select * into #temp from assessment update assessment set ABC = '11/30/2008' where ABC > '12/1/2008' insert into a ( XYZ , <OtherField> , <OtherField> ) select '12/1/2008' , <OtherData> , <OtherData> from #Temp t [inner/right outer] join assessment a on...

Part and Inventory Search

Back
Top