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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Steve95

  1. Steve95

    Increment

    Cheers for the above but the id column is not a ID column as one would expect. I have had a look at the numbers and they are not even incrementing at some stages, which I do not understand any ideas? What would best approach to change this column to a genuine id column?
  2. Steve95

    Increment

    Hi All I have created a sp in sql 2005 and from my table variable I am inserting into a live table and the last column in the live table is a colum labelled id data type: int. The values in this are incrementing by 1, I need to know what to put in my insert statement that will populate the live...
  3. Steve95

    Storage Size

    Hi All Iam new to sql and have been looking into data types. Please can someone tell me in plain english the pro's and cons of Storage size (bytes) or how they work related to data types. Many Thanks in advance
  4. Steve95

    Deleting Records

    Hi All thanks for the posts and yes it was a typo on my behalf, it suppose to be a comma. The thing that still bothers me is that, my field originalno is a varchar in an non sequential format, so I need to extract these records but like I said I dont want to be putting ',' comma for 2000...
  5. Steve95

    Deleting Records

    But I still need to put comers at the end of each originalno. and I have around 200 records hence the reason Iam looking for a more effective syntax or way.
  6. Steve95

    Deleting Records

    Hi All I have need to know of an effective way to delete 2000 records from a table holding 4000 records. Their is a unique key ie. originalno. which identifies each record and also I have the originalno. of all the records that need to be deleted. But what syntax do I use to make this quick...
  7. Steve95

    Insert with multiple Values

    This is my final select statement into my a db table insert into testtable select case when PurposeCode = 'current' then 'CODA' else 'FIRE' end, case when PurposeCode = 'current' then 'CODA' else 'FIRE' end, null, (select (processyear * 100) + processqtr from Report_Rates where (processyear...
  8. Steve95

    Insert with multiple Values

    Hi All I have complied a SP in sql 2005, iam using a table variable to manipulate the data, in my final insert which is directing the data to inserted into a db table, it is coming back with the following error msg :- Msg 512, Level 16, State 1, Line 51 Subquery returned more than 1 value...
  9. Steve95

    Simple SQL

    Hi All Iam new to SQL espcially sql 2005, I have a select statement where Iam selecting to fields from a table and then at the same same adding the 2 fields to and outputting as a new column denoted with a t. I want to refine the select by the new the results that have been generated ie...
  10. Steve95

    Copying Table and Data

    Hi All Iam working with sql 2005 and have a table sitting on a different server and db. I want to copy the table structure and data across to another server, how do I do this? Many Thanks
  11. Steve95

    Declaring in SP

    Thanks for that Dennis, my next problem is that my SP has information coming in from different tables which sit on different servers. How do I reference a server before a table.dbo.field and also does this mean I got to create a link server?
  12. Steve95

    Declaring in SP

    Hi All Iam new to SQL SPs and have created a SP which starts off with a declare statement referencing a table variable. In the SP their are are various select and insert statements which manipulates the data and finally the data is inserted in a table. However I want to test an section of the...
  13. Steve95

    Multiply

    Iam trying to select the process year, year and then 3 column as process * 4 Any ideas?
  14. Steve95

    Multiply

    Hi All I am trying to multiply the following select process_yr from tbl_report where (process_yr*4) and its not working....some can some one tell me what Iam doing wrong... Many Thanks
  15. Steve95

    er

    Hi All Iam new to sql and stored procedures..... In a sp iam looking at a select statement has 'er' in it, what does do and mean? eg. from fin_datawh.dbo.tbl_Report_Exc_Rate er where rate_type_code like 'syse%'
See more

Part and Inventory Search

Back
Top