To display it, you need to use CONVERT with format code 120.

You should, however, store datetime values as datetype types which have no format predefined.

Maybe this would give you a clue on how to do it while you're inserting your data into your table variable. Why are you inserting into the table variable? Are...

I can't reproduce your error. What are you using instead of '?'?

Can you post DDL of the table?

Here's what I used to test.

WITH SomeTable([year],[month],[day]) AS(

SELECT 2001,9,14 UNION ALL SELECT 2001,9,15)

SELECT...

The problem is that your JOINS are duplicating the rows because of the one-to-many relationship with tables C and D.

I'm leaving here 3 options that you might consider. On the...

You have a problem here. You need to do something but you don't have the permissions to do it.

I'd say that you need to talk to your manager, DBA or...

I'm glad that you got a solution. Be sure to understand it, that's why I inclued a link to an article that goes step by step on how the solution...

I had a similar option to Nevyn but using a subquery.

SELECT citation

FROM(

SELECT header,

CAST( header AS varchar(200)) AS citation,

1 AS roworder

FROM Table_1

GROUP BY header

UNION ALL

SELECT header,

citation,

2 AS...

Read what I posted 😛

You could easily use a cross tabs approach to this problem. You can read more about this method on the following article: http://www.sqlservercentral.com/articles/T-SQL/63681/

If you have any questions after reading the...

I would create a calendar table and include the expression in a column so you can use it in the queries.

And there's a recently published article by Jeff on BULK INSERT that will help you as an introduction to your process.

http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

chillw1nston (1/27/2014)

---

window function version

SELECT TOP 100 --*

--,

CASE WHEN ROW_NUMBER() OVER (ORDER by object_id) % 3 = 0 THEN 'FIZZ'

WHEN ROW_NUMBER() OVER (ORDER by object_id) % 5 = 0 THEN...

There are some points that confuse me.

You say you need the first 50 entries from your table. How do you define the first 50? What order do you have? Why...

Do you have a calendar table?

Hi Andrew,

Here are two options you might consider.

WITH SampleData AS(

SELECT '005863913 00002' String)

SELECT CAST( LEFT( String, CHARINDEX( ' ', String)) AS Int) AS AsInteger,

SUBSTRING( LEFT( String, CHARINDEX( ' ', String)),...