Here's one way:

select DateCols.*, theDatetime = cast(concat(cast(DateCols.theDate as char(10)), ' ', cast(DateCols.theTime as char(12))) as datetime)

from (select cast(cast(abs(checksum(newid())) % (780) + (33968) as datetime) as date)...

Is this a question or an...

abhilashdk2013 52858 (10/19/2015)

---

Hi,

Thank you for your reply. As I said I am still learning and there is no specific reason for this scenario. I did not know how to extract...

abhilashdk2013 52858 (10/19/2015)

---

Hi,

Thank you for the reply. I was just trying out as I am just learning. I will learn Script Task and try to get the file name from...

abhilashdk2013 52858 (10/19/2015)

---

Hi All,

I am new to SSIS. I created a simple package that extracts data from a table and copies that data to a text file. It works well.

Now...

6660999 (10/17/2015)

---

So I am very new to SSIS and I have a question regarding the WMI watcher.

I have several import processes running across around 20- 30 files. These are all...

Dropping your temp table is easier like this

if object_id('tempdb..#TempB', 'U') is not null

drop table #TempB

I can't remember whether GO is valid inside an ExecuteSQL task, as it's not a valid SQL statement.

_watching (10/15/2015)

---

Matt Miller (#4) (10/15/2015)

---

ChrisM@Work (10/15/2015)

---

_watching (10/14/2015)

---

If you're interested in updated speed comparisons on how fast each is (well, on SQL 2014 anyway), this ➡ LIKE vs SUBSTRING vs LEFT/RIGHT...

Wording looks pretty good to me:-)

Where is the OR to...

fernando.arias (10/15/2015)

---

Thanks.

To be sure, wouldn't this work as well? (PARTITION BY namn ORDER BY Säsong) since namn (the name) doesn't change, but tröjnummer (which is the number on their sweaters)...

Based on that screen shot, if you change your PARTITION BY to this, it should work

(PARTITION BY TROJNUMMER ORDER BY SASONG DESC)

(obviously, the various accented characters need to be substituted...

SELECT *

INTO Newtable

creates a permanent table called Newtable. So if you run it again when the table already exists, you get an error because the table cannot be created again.

If...

Kristen-173977 (10/15/2015)

---

fernando.arias (10/15/2015)

---

--- But it gave me this message:

Msg 336, Level 15, State 1, Line 5

Incorrect syntax near 'Fernhl'. If this is intended to be a common table expression, you...