CREATE TABLE #showme

(

 sku INT

 , item VARCHAR(8000)

)

INSERT INTO #showme

SELECT 123, '10001,10002,10003,10004,10005,10006,10007'

UNION ALL

SELECT 124, '20001,20002'

SELECT

 sku, CAST(RIGHT(LEFT(item,Number-1)

 , CHARINDEX(',',REVERSE(LEFT(','+item,Number-1)))) AS CHAR(30))

FROM

 master..spt_values, #showme

WHERE

 Type = 'P' AND Number BETWEEN 1 AND LEN(item)+1

 AND

 (SUBSTRING(item,Number,1) = ','...

That's what I meant. I would like to see some code and am interested what the standard methodology of CASE is.

Have you read this: http://www.sqlservercentral.com/articles/articlelink.asp?articleid=1885 Gert makes several interesting remarks on the system tables in the next version.

I'm not sure if I understand you, but your append query translated to  a stored procedure might look something like this:

CREATE PROCEDURE dbo.InsertSomething @startdate DATETIME, @enddate DATETIME, @hours FLOAT

AS

 INSERT INTO...

CHARINDEX and SUBSTRING

I've learned to read between the lines over the years

Then you should learn to read closer. No offense intended.

Did I say so?

I have no problem with that, the more people get active here, the better for all. Just keep in mind quantity != quality.

and as we know sql server does not support the stantdard methodology of CASE

Do we? AFAIK, CASE is pretty much ANSI SQL Standard.

Can you be more specific in your requirement?

See if this helps: http://www.sql-server-performance.com/fk_datetime.asp

Have a look at OBJECTPROPERTY. There are two that might be interesting for you :

• CnstIsDeleteCascade
• CnstIsUpdateCascade

You first need to move tables and indexes from the *.ndf files back to the *.mdf file. For tables this is fairly straightforward, just (re)create the clustered index WITH DROP...

Another approach might be:

SELECT

  CAST(

   CAST(

    (@year * 10000 +

    @month * 100 +

    @day)

   AS CHAR(8))+' '+ @time

  AS DATETIME)

Note, that this doesn't check for a valid date before...

If you don't care about the time portion, you can also do:

SELECT

 DATEADD(d, 1-DAY(GETDATE()), GETDATE())

You can't do that, AFAIK.