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 Chriss Miller 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. robert030975

    Date Function Help

    I want to create a simple function that will take the datetime and convert it to 14-AUG-2013. Now the current select works fine until we get to the start of the month and it shows 1-AUG-2013 but is there any way to make it show 01-AUG-2103 SELECT DATENAME ( DAY, GETDATE()-13 ) + '-' +...
  2. robert030975

    BCP [SQL Server Native Client 11.0]Unable to open BCP host data-file

    Hi trying to send a file to a folder and having a few issues ! SQL2012 Error = [Microsoft][SQL Server Native Client 11.0]Unable to open BCP host data-file Exec master..xp_cmdshell 'bcp "select name from sysobjects" queryout "\\SERVERNAME\FileDrop\out.txt" -c -T -S' I have also tried the...
  3. robert030975

    Help Using Merge

    Hi In need of help or a bit of advice in the way forward I have a 50 row table mill table with over 100 columns and want to do a merge now the first method is accpetable although a little cluncky , I als have concern over time . I then thought of using on the when matched trying checksum to...
  4. robert030975

    Export a file with headers Help

    Hi having a little bit of an issue and wondered if its possible to do soemthing better?? so create table new_tbl (id int, basket varchar(10), Calc numeric) insert into new_tbl values (1, 'Test', 123.12) , (2, 'Test', 456.78) , (3, 'Test', 901.12) My question is the only way...
  5. robert030975

    Default Constraint

    HI Was looking at creating a table where to use the default constraint. CREATE TABLE Customer ( CustomerID INT CONSTRAINT pk_customer_cid PRIMARY KEY, CustomerName VARCHAR(30), CustomerAddress VARCHAR(50) CONSTRAINT df_customer_Add DEFAULT 'UNKNOWN' ) If I insert Insert into...
  6. robert030975

    ROW NUMBER Partition by

    HI I'm in need of some help grouping some data partNo Qualification SequentialNumber SortOrder Sets 877 Vehicle Equipment 10801 00003 1 877 To construction year 10801 00004 1 877 Block Separation 10801 00005 1 877 To construction year 10801 00006 2 877...
  7. robert030975

    SQL Agent Job Start and Finish Time

    Is there an easy way to list what the SQL Agent job start time and finish time was ? Many Thanks
  8. robert030975

    Finding Information on a tape

    HI All I was wondering if the following syntax cpio -ivt -C32768 < /dev/st0 /data/jvedi/jv-ediinp is the best way to find this file ( jv-ediimp) on my tape as its taking ages!! I also get the message cpio: warning: skipped 9373909 bytes of junk cpio: warning: skipped 594005 bytes of junk...
  9. robert030975

    SQL Agent Job

    Hi Is there away of telling is a SQL user ran a SQL agent job manually if so where Thanks
  10. robert030975

    SQL Query Help

    I am sure this is easy but I'm really unsure in how to approach this Col a Col B Col c 2011-07-03 00:00:00 B Y 2011-07-04 00:00:00 S Y 2011-07-05 00:00:00 DO N 2011-07-06 00:00:00 S Y 2011-07-07 00:00:00 DO N 2011-07-08 00:00:00 S Y 2011-07-09 00:00:00 B Y What I need is...
  11. robert030975

    Split Text into char and int

    HI Guys I'm struggling at the monment separting txt WITH t(hours) AS ( Select '3WH' UNION ALL Select '3WH ' UNION ALL Select '4WH' UNION ALL Select '3 WH' UNION ALL Select '3 ' UNION ALL Select '4' UNION ALL Select '3 W' UNION ALL Select 'WH3 ' UNION ALL Select 'W 3' ) SELECT...
  12. robert030975

    Coverting to hours

    HI Ive been trying to convert values to hours and minutes and failing badly! 4.25 would be 4.15 4.5 would be 4:30 4.75 would be 4:45 Help Please!
  13. robert030975

    Row Count Reset?

    HI I have built table to which I have created an inital composite key a,b ab a,b ab b,c bc b,c bc now I was wondering how you would do a count that I can reset on compkey if I do SELECT row_number() over (order by COMKEY), COMKEY from table I have ab 1, ab 2, bc 3, bc 4 but really...
  14. robert030975

    identity seed

    When creating and identity seed can you start it of from a set number eg instead of 1, value, value 200, value , value
  15. robert030975

    Mother of all substrings?

    HI I have a number of products which have a composition against each however .... Product Comp 12345 63% POLYESTER 32% VISCOSE 5% ELASTANE 12346 100% VISCOSE Is there any way to break this down to sepreate Col1 Col2 63% Polyester 100% VISCOSE etc thanks
  16. robert030975

    Filtering Rogue Chars

    HI I was wondering if there is any way of filtering out rogue chars the only thing is that has to be considered is a double barrelled name Peter-Paul Thomas. FirstName Surname Peter Èajèyc Thomas Many Thanks Robert
  17. robert030975

    SSIS Package configuration

    HI I need to transfer information for one server to another and although it works in BIDs when I run SSIS package via the agent I get rights reserved. Started: 10:58:45 AM Error: 2010-07-07 10:58:45.20 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML...
  18. robert030975

    Union Combine

    HI I have a problem that I can't seem to do in one select. fullcode gbbin qbbin pqty gbqty N3A2020/N050/L 0 270A1 0 11 N3A2020/N050/L 253A1 0 22 0 Now the productcode and bins are varchar but what I want to see without have to create two tables and join is have the select into...
  19. robert030975

    Date Convert Help

    I'm stuggling a bit to convert this into a date time and was wondering if someone could help 'May 17 2010 5:45AM' Thanks Robert
  20. robert030975

    Different Char behaviour on Case statement

    HI All Have an issue which has taken me a while to figure out where its going wrong however I'm interested to know why. As my black arts ERP team claim to know nothing I pretty sure there has to be a behavioural change or something! My table is i_st_stock which is an import from the EPR...

Part and Inventory Search

Back
Top