I would go with a single table with 2 columns.. Column 1 being the variable name and column 2 being value column.. Then u could make use of some SET-based...

How about this?

DECLARE @StartDate DATETIME --= '2010-11-22'

DECLARE @EndDate DATETIME --= '2010-12-22'

SET @StartDate = '2010-11-22'

SET @EndDate = '2010-12-22'

; WITH Tens (N) AS

(

SELECT 1

UNION ALL SELECT 1

UNION ALL...

How about this?

SELECT Col1 + SPACE(32-LEN(Col1))

WayneS (11/3/2010)

---

I think Monsieur ColdCoffee's code can be simplified - I don't think that the first CTE is necessary if in the second one, we order by the Activity in...

WayneS (11/3/2010)

---

I think Monsieur ColdCoffee's code can be simplified - I don't think that the first CTE is necessary if in the second one, we order by the Activity in...

Richard Warr (11/3/2010)

---

It will be to do with data types. You need one of the operands to be non-integer to get this to work. Try this:

SELECT 665/12

SELECT CAST(665 AS MONEY)/12

..and...

2 main differences

1. Data-type precedence and conversion

2. COALESCE can accept any number of input column, the...

Try this:

DECLARE @PatientsInfo TABLE

(

PatientID VARCHAR(15),

PatientCode VARCHAR(5),

Activity DATETIME

)

INSERT INTO @PatientsInfo

...

I guess, some of your DBs are having spaces in their names...

Try changing part of your query to

SELECT @SQL = '['+@DBName+']' + '..sp_HelpFile'

Dint you try cast and convert functions?

select cast ( '6/9/2006' as datetime)

select convert( datetime,'6/9/2006' )

traughberk (10/27/2010)

---

Thanks Drew, but it appears that the link you gave just points right back to this thread. I searched SSC for "quirky update" but didn't find any articles...

Try these:

select CONVERT ( date , '12-14-2004 15:34:00')

select CONVERT ( time , '12-14-2004 15:34:00')

But, why would you want to do it ? Store dates fully!

Chris Morris-439714 (10/22/2010)

---

ColdCoffee (10/21/2010)

---

Chris Morris-439714 (10/21/2010)

---

There's a trick for that...put them in...

The issue is with your "insert" statement.. If you do not provide the INSERT statement with the column names, it will insert the values as how it is in the...

What about this?

select reverse(stuff( reverse(stuff(@string,1,1,'')) ,1,1,''))

Ugly, but still 😛