SwePeso

Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 2,171 total)

RE: Sum or aggregate operation......

How are you importing the CSV file?
Almost always let SQL Server to decide how to convert data. You don't have to do it in most cases...

April 19, 2007 at 3:52 am

#701361
RE: Expert Must see this Update Statment

Are you using a CASE sensitive collation?
update title
set year = 1999 , month = 11
where ucase(category) = ucase('ENG') and number between 1550 and 1560

April 19, 2007 at 3:51 am

#701360
RE: Spreading Cost over Time period

Since we do not know the source DDL, we'll have to guess.
Something similar to
SELECT Col1,
SUM (CASE WHEN DATENAME(month, Col2) = 'january' then Col3 else 0 END) AS [January],
SUM (CASE...

April 19, 2007 at 3:49 am

#701359
RE: Date/Time 00:00

A datetime is really a 4 byte datatype. Don't rely on formatting.
If you are worried add a single ":00" for seconds trailing the column.

April 19, 2007 at 3:46 am

#701358
RE: Sequential Ordering of a Column

DECLARE
@Sample TABLE (Name VARCHAR(10), SortOrder INT)

April 18, 2007 at 11:03 pm

#701325
RE: Incorrect syntax near '''','''' in sql string

I count the lines
1
2
3
4 Found it!

@xadProgramID, --<---- This line needs a data type.

April 18, 2007 at 11:47 am

#701197
RE: Date problems

SELECT
CONVERT(VARCHAR, CURRENT_TIMESTAMP, 112),

April 18, 2007 at 5:30 am

#701086

RE: Return next available product value

DECLARE

@Sample TABLE (data VARCHAR(20))

INSERT

@Sample

SELECT

April 18, 2007 at 4:58 am

#701084

RE: Sequential Ordering of a Column

Make use of the new ROW_NUMBER() function available in SQL Server 2005.

And depending on your business rules, RANK() or DENSE_RANK() would be helpful too.

April 17, 2007 at 10:50 pm

#701065

RE: DELETE all records except most recent

A lot in impressive information! Well done.

What does it say?

April 17, 2007 at 9:00 am

#700939

RE: DELETE all records except most recent

This is the execution plan with your method

|--Hash Match(Inner Join, HASH[t2].[SomeID])=([t1].[SomeID]), RESIDUAL[tempdb].[dbo].[#BigTest].[SomeID] as [t1].[SomeID]=[tempdb].[dbo].[#BigTest].[SomeID] as [t2].[SomeID]...