GilaMonster (8/8/2011)

---

skcadavre (8/8/2011)

---

"Table variables are not the same as temporary tables. The biggest differences are that: -

•Temporary tables can be altered with DDL statements whereas table variables cannot.

Essentially, this...

pkasemsant (8/8/2011)

---

As developer and still got lots to learn in SQL Server administration, can anyone tell me, which is better using temp table(s) or creating table variable(s) within these conditions,

i....

It depends on what the activity is like.

Not sure what ".fff" is, but the "T" is ISO8601 -> code 126

SELECT CONVERT(VARCHAR(100),GETDATE(),126)

pwalter83 (8/3/2011)

---

No actually my English is not good neither are my SQL skills...I do know what a stored procedure is...

pwalter83 (8/3/2011)

---

John Mitchell-245523 (8/3/2011)

---

OK, I think we've come as far as we can without your providing any table DDL and sample data. Please post the former in terms of...

Without seeing the tables, data, or requirements this is difficult.

Try this: -

SELECT *

FROM (SELECT *

FROM news

...

Like this?

DECLARE @string AS VARCHAR(50)

SET @string = 'AAAA, pqrstuv, xxxx-lmn, ZZZsswD'

SELECT '''' + REPLACE(REPLACE(UPPER(@string),' ',''),',',''',''') + ''''

-Edit-

Bear in mind that this will not work if there are ever spaces in...

Difficult to answer your question with the data you've provided. See the below examples for how to work it out yourself.

DECLARE @TABLE AS TABLE(The_Group INT)

INSERT INTO @TABLE

SELECT 1

UNION ALL...

Eric M Russell (6/23/2011)

---

Perhaps a user entered some trash for the email address in the web form. When I exec the following, I see several character values that are invisible...

Something like this?

;WITH id_CTE AS (

SELECT name, status, fordate, a,

ROW_NUMBER() OVER (ORDER BY fordate ASC) AS id

FROM #data),

work_CTE AS (

SELECT name, status, fordate, a, id

FROM id_CTE

WHERE id = 1

UNION ALL

SELECT...

--Edit--

Misread post.

Very strange behaviour though.

--Edit 2--

If you change the AttribValues CTE to contain the clause, it works.

,AttribValues

AS

(

SELECT ItemNumber, Item

...

--EDIT--

Have now tested. I've written it to emulate your description rather than your code. If it should be the other way around, let me know. To find out...

Just to keep anyone that is interested informed, the final version : -

DECLARE @starttime DATETIME, @endtime DATETIME, @interval INT

SET @starttime = '2011-06-13 07:45:00'

SET @endtime = '2011-06-13 20:30:00'

--Minutes

SET @interval = 1

;WITH...

D'OH!

Was being stupid. The answer is this: -

SELECT DATEADD(MINUTE, DATEDIFF(MINUTE, 0, thedate)/15 * 15, 0)

FROM @TABLE