Viewing 15 posts - 1,546 through 1,560 (of 2,171 total)
You could try to create a staging area, and use TEXT as column data type. Then import to this table. Performance will decrease while importing.
It is then fairly easy to...
N 56°04'39.16"
E 12°55'05.25"
July 4, 2007 at 6:37 am
You mean like telling people to force their boss to solve their problems?
That must be a masterpiece of helpful information. Don't you agree?
It seems to me that you are not...
N 56°04'39.16"
E 12°55'05.25"
July 4, 2007 at 6:06 am
Unless it is a legacy system, and orignal poster wants to create reports in Reporting Services or other reporting applications.
The column is VARCHAR for us unknown reasons.
Sergiy, what about you actually...
N 56°04'39.16"
E 12°55'05.25"
July 4, 2007 at 3:59 am
It is called a derived table. The table aliased do all the work, the outer select only formats it.
N 56°04'39.16"
E 12°55'05.25"
July 4, 2007 at 1:47 am
SELECT Col1
FROM Table1
ORDER BY CAST(Col1 AS DATETIME) DESC
N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 4:31 pm
SELECT REPLACE(STR(25, 11, 0), ' ', '0')
N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 4:27 pm
Use the new SQL Server 2005 features!
SELECT
Privilege,
TargetID,
Permission,
Strength
FROM (
SELECT Privilege N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 4:25 pm
They are both right. It is just an opinion for a point of origin.
You can explain the world and universe having the Earth in centre. The formulas are hideous but it can be...
N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 2:44 pm
select
item.name,
vendor
.name,
sum(case when N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 12:39 pm
SELECT
SalesPersonID,
CASE
WHEN NumOrders > 100 THEN 'Bonus'
ELSE N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 9:52 am
-- prepare sample data
declare
@tableone table (id int, address varchar(40 N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 9:49 am
I am using set based logic.
Your original code took 56 seconds to complete for 1500 records. If you try my approach, how many seconds does that take?
N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 9:41 am
I know most intelligent people are better in more things than me. Always has been that way.
What I object to is your stupidity.
The BR algorithm is designed the way it...
N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 7:52 am
How can BR be wrong? It is just a business decision.
Just like a company decides to always round down to nearest dollar, or upward to nearest dollar. It is just...
N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 4:53 am
You could change the transaction level, do the update and then read the number of uncommited records and commit the transaction.
N 56°04'39.16"
E 12°55'05.25"
July 3, 2007 at 4:46 am
Viewing 15 posts - 1,546 through 1,560 (of 2,171 total)