Assuming john is required, the following 9 results were found.
day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18 After: ID Name DateOfBirth --------- ------------...
data that we send to suppliers for support or analysis. With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not...
Pollock Jacob Lawrence Jacques-Louis David Jan van Huysum James Turrell Jean-Michel Basquiat Joan Miró Johannes Vermeer John Carpenter John Romita Jr Jules Verne Kara Walker Kate Greenaway Kurt Schwitters Lee Ufan Liu Xiaodong M.C. Escher Marc Chagall...
a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first thing I did was to create the logic: //...
The greatest invention in IThttps://joellipman.com/hardware/the-greatest-invention-in-it.html
of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command...
data very difficult to work with: Before: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 John Smith 1990-03-21 2 Fred Bloggs 1988-11-02 3 Another User 1985-07-11 4 Yet Another User 1977-06-25 After: StudentID...
Table: DMExtractEmployeeTable ------------------------------------------- ID Name EmpType CodeType 1 Joe Manager 0011 2 John Tape-Monkey 8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey 8475 6 Joe Tape-Monkey 8475 Table:...
Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this. Original Proper-Cased JOHN SMITH-JONES John Smith-Jones HEAD OF IT SERVICES Head of IT Services FLAT 123A Flat 123A MRS. O'CONNOR-MCDONALD Mrs....
receives the best martini of his life. "What's your IQ?" "100." The robot proceeds to chat about NASCAR, Budweiser, and John Deere tractors. The guy comes back a third night and this time when asked says, "About 50." The robot leans in real close and...