Recent content by robert030975

Not pretty but does the trick ! SELECT CONVERT ( NVARCHAR (2) , GETDATE()-13 , 113) + '-' + UPPER (LEFT (DATENAME(MONTH,( DATEADD(Month, 0,GETDATE() ))) ,3))+ '-'+ DATENAME ( Year,GETDATE() )

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 ) + '-' +...

As a fix I Created a SQLAdmin account as admin and assigned the SQL service to it and hey presto it now works.

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...

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...

Thanks its a great help , still have to convert columns on the other side but great!

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...

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...

Hi by SequentialNumber ( I know its not great !)

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...

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

sure heres the script find /data/live /data/hist /data/informix /data/jvedi /data/live/compress -type f -print | tee $CPIOLOG | cpio -oc -C32768 -O $DEVICE

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...

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

My Bad I'm just being stupid ! Really appreciate the help though.