Viewing 12 posts - 496 through 507 (of 507 total)
I actually had to solve this kind of problem a couple of weeks ago. I was modifying some package type software that always sends string type 'WHERE' clauses to...
January 16, 2008 at 11:37 am
Rather than using the LEN function to determine the number of times
to replicate your leading zeros, it might be simpler and easier to read
like this:
SELECT RIGHT('000000000' + CONVERT(VARCHAR, ),...
January 14, 2008 at 11:38 am
Thanks. This one is very helpful. I hadn't thought about using OpenDataSource. It's not the post/article I was thinking about. The example was opening a text...
January 14, 2008 at 10:43 am
I normally use a set based solution with 2 passes for an UPSERT.
Something like:
UPDATE Tbl1
SET Tbl1.SomeData = Tbl2.SomeData
FROM Tbl1
INNER JOIN Tbl2 ON
Tbl1.PK = Tbl2.PK
INSERT INTO Tbl1
(PK, SomeData)
SELECT Tbl2.PK,...
January 10, 2008 at 11:09 am
If your data is always numeric and always only has 1 decimal it may be simpler to convert the data to numeric data types and then compare.
Something like:
SELECT ColumnName
FROM Table
WHERE...
January 8, 2008 at 11:37 am
Thanks. I tried it before and didn't notice an option for 1 file per object. Maybe I just missed it. I'll try it again.
Todd
January 4, 2008 at 11:58 am
Thanks guys. This helps some. Is there any way to have each object script in a separate file?
Todd Fifield
January 4, 2008 at 10:55 am
Wow! I never thought my first post on this forum would evoke so many passionate responses.
I still think that my points on the type and number of applications accessing...
November 28, 2007 at 9:55 am
Here's a simple little function that will strip off the leading numeric values and return an INT that you can sort by. If the numeric leading digits aren't all...
November 22, 2007 at 6:41 pm
Your problem may with the the data types. SQL Server is not very friendly with divides of INT / INT.
This will return 0
DECLARE
@Expense INT
, @Income ...
November 22, 2007 at 3:35 pm
The easiest way I've seen to handle this problem does not involve any sort of serialization. There should be a control table that contains the next number to use....
November 21, 2007 at 11:37 pm
This is really a matter of what the database was created for. If there is only 1 front end application doing all of the inserts and deletes, there is...
November 21, 2007 at 11:14 pm
Viewing 12 posts - 496 through 507 (of 507 total)