Recent content by ciarra41

I have these dates fomatted like these mm/dd/yy to mm/dd/yyyy I tried to convert function but to luck 01/21/98 07/17/96 12/15/04 Need them to look like this" 01/21/1998 07/17/1996 12/15/2004 any help would do

here's the example; employeecode Monday Tuesday Wednesday Thursday Friday Saturday Sunday 502025 Rostered NULL NULL NULL NULL NULL NULL 502025 NULL Rostered NULL NULL NULL NULL NULL 502025 NULL NULL Rostered NULL NULL NULL NULL 502025 NULL NULL NULL Rostered NULL NULL NULL 502025 NULL NULL NULL...

I have multiple rows with duplicate orders numbers and separate order types where as some are null and some are not. How can I roll these up into one record by order number and where there’s null it will pick the corresponding value that is not null for the same order number? It can be two are...

Thanks to everyone, you guys are awesome. I added the replace string; bingo!

hmm, that did not work Here's how the field look: >59>rt>mb>50

Super but I need to add '>' as the separate where do I add that?

I'm trying to parse a field whereas at any second occurrance of a character value(') start from there and drop them into another field separately by ('). The below query works but keeps ASC the values exp. tr'1245'lt'ba'max'74 tr'1845'lkt'bf1a'7max'749 It needs to start at the second (') and...

Thanks guys!

I have a list of file names in a table; I'm only trying to query the report name starting at the last forward(\) slash. So anything starting at the last slash will be the report name. k:\documents\myfolder1\reports\analysis\march\04\ordersReports.xls It should look like this. Any example sql...

It combines all the numers in one unique jobnumber and separate columns per unique orderNM OLD jobNumbers orderNM 78506766 0850 0853 2542 9907 78506766 0850 0853 2592 78506766 0851 0853 2542 4801 9907 78506766 0851 0853 2542 9907 78506766 0851 0853 2592 End Result jobNumbers orderNm1...

I trying to join two tables with table a has a single value whereas the table b may have multiple values but still has the value in table a. Possible easy fix? select a.* FROM tableA as a inner join tableB as b on b.CODE = LIKE '%'[a.code]'%'

actually the second example worked. it was a date field that was causing the error. Oops!

Hi there; I'm trying to convert this 11:15:AM into a datetime format. The problem I see is the second (:) I've tried to remove it but still I'm getting an error. I've tried these: CONVERT(varchar(8),mytime,108) RTRIM(SUBSTRING(mytime,1,5)+' '+SUBSTRING(mytime,7,2)) any other suggestions.

old table: idnum values 5548 2s1dd 5548 35dd6 5548 4548p 5584 22de1 New table or sql: idnum value1 value2 value3 value4 5548 2s1dd 35dd6 4548p 22de1

Thank you this worked great.