Dave Convery (10/13/2015)

---

Currently there are filters based on post numbers, with automatic approval for people over a certain number of posts. This is a bit more robust than just the...

What do you mean by this?

Is this a separate application that you are talking about?

John Mitchell-245523 (10/20/2015)

---

I'm wondering whether SSIS adds some stuff to the beginning of the batch - maybe SET statements or such like. MERGE requires the preceding statement to be...

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)...