Viewing 15 posts - 1,621 through 1,635 (of 2,171 total)
A query consisted of 200 rows? Wow...
Try to explain what the query do and your expected output from the query.
April 30, 2007 at 5:31 am
The syntax for creating the VIEWs does not look like SQL Server syntax.
Which DBMS are you using?
Oracle or DB2? VARCHAR2 is not available in SQL Server.
Maybe you should try...
April 30, 2007 at 5:28 am
Using the function fnParseList here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033
INSERT NewTable (CarKey, CarType, DefectKeys)
SELECT t.CarKey, t.CarType, LTRIM(RTRIM(x.Data))
FROM OldTable AS t
CROSS APPLY dbo.fn(',', t.DefectKeys) AS x
April 30, 2007 at 4:07 am
SELECT p1.BrandID,
p1.ProjectID
FROM Products AS p1
WHERE p1.ProjectID IN (SELECT TOP 10 p2.ProjectID FROM Products AS p2 WHERE p2.BrandID = p1.BrandID ORDER BY p2.ProjectID DESC)
April 29, 2007 at 12:26 pm
First (or top) 10 records according to what?
April 29, 2007 at 7:13 am
April 27, 2007 at 2:37 am
It doesn't matter.
When you want non-duplicated characters from a group, the while loop exits when there are no more characters to choose from.
Even if you set 50 non-duplicated characters, the...
April 26, 2007 at 11:48 pm
The problem is NOT with LOG function.
You are using INTEGER DIVISION!
@underlying and @strike are both integers.
select @d1 = (
April 26, 2007 at 2:23 pm
In SQL Server 2005, you have the OUTPUT statement.
In 2000, you will have to put them temporarily in a table, SELECT them and then JOIN them back to source table...
April 21, 2007 at 5:59 am
A simpler method!
DECLARE
@Sample TABLE (Name VARCHAR(10), SortOrder INT
April 20, 2007 at 12:12 am
You will get errors if you create 256 column of width 8000.
For the last 200 columns or so, don't use VARCHAR. Use INT since all values are integer anyway.
And the...
April 19, 2007 at 4:52 am
You are trying to import all those records into three columns?
April 19, 2007 at 4:35 am
No rows affected? Or you did get some rows affected?
Collation is setup during installation of SQL Server.
You can change collation of a single column too.
April 19, 2007 at 4:10 am
Please post some rows of source data, the CSV file.
Also provide DDL for target table.
April 19, 2007 at 4:09 am
You want to count ALL instances?
Views, dynamic SQL, stored procedures and so on?
April 19, 2007 at 4:06 am
Viewing 15 posts - 1,621 through 1,635 (of 2,171 total)