Hi Stewart

Peter Larsson recently posted an elegant solution to this problem, see

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=367397&p=4

Cheers

ChrisM

Hi EM

This wouldn't be a metal-plating company in Harlow, Essex by any chance? I had the exact same experience there about 7 years ago. It was infuriating! Management wouldn't listen...

Heh heh lovely job lads!

Hi Loner

You may be sliding down the slippery slope of Clinical Depression, a place where you really don't want to go. Make a few enquiries and find yourself a local...

And since there's only one SELECT from #temp...

select
        MetroCity as City,        
    ...

Hi Dark Angel

<< I have a stored procedure (SP1) that returns multiple data sets.

i.e., the last 3 lines read:

SELECT * FROM...

Hi Bobs

Creating a separate table for city and province/state is probably over-normalization - you will still need a pointer (fk) in your customer table (and of course the pk in...

Found this on our dev server:

-- Author:  Igor Nikiforov,  Montreal,  EMail: udfs@sympatico.ca   
 -- PADL(), PADR(), PADC() User-Defined Functions
 -- Returns a string from an expression, padded with...

Hi Mike

Yes, you can use CASE (simple or searched) in a WHERE.

What are you comparing to [('A','E','I','O','U') else ('B','C','D','F')]?

Cheers

ChrisM

<proprietary UPDATE clause of SQL Server... magic... and blows cursor speed away>

This solution is really cute, and timely too - there are several current threads looking to a sequential...

Lovely! Nice way to end a friday.

No problem Ganesh -

--===== Create a test table and populate it with test data
 CREATE TABLE #MyHead (userid INT, logintime DATETIME)
 INSERT INTO #MyHead (userid, logintime)

 SELECT 1234, '2007-05-10 17:18:00' UNION...

sql2day

Here's a stub query

SELECT * FROM TableName t
WHERE DATEPART (hh, t.DateTimeColumn) = '23'
 AND DATEPART (mm, t.DateTimeColumn) = '59'
 AND DATEPART (ss, t.DateTimeColumn) = '59'

but as Jeff pointed out, if you want...

<<There is no way for to split the string I received to do what you write.>>

There's always a way...

DECLARE @STR AS VARCHAR(8000), @substr VARCHAR(500), @Statement CHAR(6), @EndPos INT

SET @STR =...

Hi Jeff

We're on SQL2k here. Can't wait to play with CTE on the next contract though.

Regarding matching on dates - good point. If an identity column is available, the same...