Click here to Skip to main content
14,543,933 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralHoliday Company Goes Bust Pin
Dalek Dave18-Aug-10 1:35
professionalDalek Dave18-Aug-10 1:35 
GeneralRe: Holiday Company Goes Bust Pin
Baconbutty18-Aug-10 1:42
MemberBaconbutty18-Aug-10 1:42 
GeneralRe: Holiday Company Goes Bust Pin
OriginalGriff18-Aug-10 1:46
mveOriginalGriff18-Aug-10 1:46 
GeneralRe: Holiday Company Goes Bust Pin
Henry Minute18-Aug-10 2:10
MemberHenry Minute18-Aug-10 2:10 
GeneralRe: Holiday Company Goes Bust Pin
R. Giskard Reventlov18-Aug-10 1:42
MemberR. Giskard Reventlov18-Aug-10 1:42 
GeneralRe: Holiday Company Goes Bust Pin
Trollslayer18-Aug-10 2:35
mentorTrollslayer18-Aug-10 2:35 
GeneralRe: Holiday Company Goes Bust Pin
Dan Neely18-Aug-10 4:51
MemberDan Neely18-Aug-10 4:51 
RantWhy I hate Microsoft today. Pin
Corporal Agarn18-Aug-10 1:12
professionalCorporal Agarn18-Aug-10 1:12 
Someone must have told Microsoft not to play with itself as trying to import an Excel file into SQL 2008 does not work. With Microsoft knowing that the SSN field MUST be a number so lets remove the leading zeros, the stupid user calling it a TEXT field in Excel. Or if I try to make it a VARCHAR on the SQL side I get an error saying it cannot convert a number (yes the TEXT field) to a character! Dead | X|

This worked most of the time in SQL 2000 but the improved 2008 does not. I hate putting a single quote (or other character) on every field I want Microsoft to see as a character field. Even the old trick of adding aaaaaaaa as the first row value for all fields does not seem to work any more.Mad | :mad:

I have tried making a CSV file to import, I have tried various things none worked. Finally had one of the .NET programmers write a program to import the stuff.


By the way for those who might not know a SSN is a number in the format 999-99-9999 but is saved without the dashes.
GeneralRe: Why I hate Microsoft today. Pin
leppie18-Aug-10 1:17
Memberleppie18-Aug-10 1:17 
GeneralRe: Why I hate Microsoft today. Pin
Corporal Agarn18-Aug-10 1:20
professionalCorporal Agarn18-Aug-10 1:20 
GeneralRe: Why I hate Microsoft today. Pin
Baconbutty18-Aug-10 1:39
MemberBaconbutty18-Aug-10 1:39 
GeneralRe: Why I hate Microsoft today. Pin
OriginalGriff18-Aug-10 1:45
mveOriginalGriff18-Aug-10 1:45 
GeneralRe: Why I hate Microsoft today. Pin
Mycroft Holmes18-Aug-10 2:34
professionalMycroft Holmes18-Aug-10 2:34 
GeneralRe: Why I hate Microsoft today. Pin
Chris C-B18-Aug-10 2:44
MemberChris C-B18-Aug-10 2:44 
GeneralDaleks! Pin
Dalek Dave18-Aug-10 1:03
professionalDalek Dave18-Aug-10 1:03 
GeneralRe: Daleks! Pin
Electron Shepherd18-Aug-10 1:07
MemberElectron Shepherd18-Aug-10 1:07 
GeneralRe: Daleks! Pin
R. Giskard Reventlov18-Aug-10 1:08
MemberR. Giskard Reventlov18-Aug-10 1:08 
GeneralRe: Daleks! Pin
Dalek Dave18-Aug-10 1:16
professionalDalek Dave18-Aug-10 1:16 
GeneralRe: Daleks! Pin
R. Giskard Reventlov18-Aug-10 1:39
MemberR. Giskard Reventlov18-Aug-10 1:39 
GeneralRe: Daleks! Pin
Dalek Dave18-Aug-10 1:42
professionalDalek Dave18-Aug-10 1:42 
GeneralRe: Daleks! Pin
R. Giskard Reventlov18-Aug-10 1:45
MemberR. Giskard Reventlov18-Aug-10 1:45 
JokeRe: Daleks! Pin
Yusuf18-Aug-10 1:12
MemberYusuf18-Aug-10 1:12 
GeneralRe: Daleks! [modified] Pin
soap brain18-Aug-10 1:13
Membersoap brain18-Aug-10 1:13 
GeneralRe: Daleks! Pin
Mark_Wallace18-Aug-10 3:55
MemberMark_Wallace18-Aug-10 3:55 
GeneralRe: Daleks! Pin
soap brain18-Aug-10 3:59
Membersoap brain18-Aug-10 3:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.