Viewing 15 posts - 53,986 through 54,000 (of 59,068 total)
DATETIME is really a FLOAT in the background (although it is a "fixed point float", if you can imagine that). DATETIME uses the same BINARY math as FLOAT.
November 23, 2007 at 4:47 am
Sounds like some of the other "Senior Software Engineers" I've interviewed... and rejected :Whistling:
November 23, 2007 at 1:05 am
Haven't tried it in a view before... you must either create a Linked Server or use OPENROWSET or OPENDATASOURCE.
November 22, 2007 at 9:37 pm
sp_ExecuteSQL is not an "extended stored procedure" or it would begin with "xp_". Neither is any form of dynamic SQL. I'm afraid that you're out of luck.
In fact,...
November 22, 2007 at 9:33 pm
Sorry... missed the "MonetaryValue" column that you included in your code but not in your problem definition... this will do it...
SELECT s.RowID,
...
November 22, 2007 at 9:23 pm
Output should be:
'80 98439 9991 997 -50.000' should be Type = 80 Code = 98439
'0000058916 00000074000039708' should be Type = NULL Code = NULL
'0000058916 00000074000039708' should be Type...
November 22, 2007 at 9:15 pm
My bad... didn't read your post correctly... didn't realize the code that you posted was a snippet that would be used with the CTE.
November 22, 2007 at 8:29 pm
JOIN #source s1 ON s1.cuslink = s.cuslink AND s1.[sequence] <= s.[sequence]
That'll work just fine... provided that the CusLink groups don't get large... and they don't need to get real large...
November 22, 2007 at 8:18 pm
The vb program will split the strings and remove unnecessary values such as 0's, and converts strings to datetime.
Yep... you're right... database sure can't do any of that ;)...
November 22, 2007 at 8:05 pm
Test it I did...
Server: Msg 170, Level 15, State 1, Procedure fnNumAlphaFmt, Line 29
Line 29: Incorrect syntax near '9'.
If you believe that the numeric portion will never exceed that...
November 22, 2007 at 7:43 pm
My source is a flat file (csv) and I need to process records one by one. At now records are processed in groups of hundreds and my process can't work...
November 22, 2007 at 7:08 pm
Who said anything about a "manual process"? Schedule it! BCP, a proc that uses Bulk Insert, and DTS can all be scheduled.
Does your table have a valid, non-surrogate...
November 22, 2007 at 7:01 pm
I agree... length of documentation has nothing to do with good documentation. But saying something like "Me want buy thet contest" will make quite a different impression than "I...
November 22, 2007 at 6:56 pm
Heh... forgot to mention that great programmers also know when and how to buck the system. Otherwise, the become unemployed programmers. 😉
November 22, 2007 at 6:48 pm
Viewing 15 posts - 53,986 through 54,000 (of 59,068 total)