pete.olding (10/22/2015)

---

We've had the SQL server 2005 installed for a while. The only reason we are moving the DTS packages across is because we are decommissing the old SQL server....

It's right there in my first post on this thread.

pete.olding (10/22/2015)

---

Hi all,

Trying to set up new SSIS packages on a SQL 2005 machine to replace all my DTS packages on a previous SQL box. The packages are mostly transferring...

And why are you converting the dates to VARCHARs?

Looks to me like this would be simpler, faster and easier to maintain as one query, rather than a bunch of UNIONs. Are you open to a rewrite?

+ISNULL(x.code,'')+' '

Where x is the alias of the joined table.

I'm 99%...

Minnu (10/21/2015)

---

Table : Unify

id desc code

1 HSBOM 002

table 'JKS'

code | Desc

-------------

001 | LCC

002 |...

Minnu (10/21/2015)

---

I have a select query on table unify, here i want to display the "Desc" value from JKS table instead of "u.code" field

SELECT

u.id,

(...

reddychaitanyakrishna (10/21/2015)

---

Hi Guys,

Getting an error while connecting to SQL Server Management Studio (SSMS) i.e connecting via Database Engine.

Please check the first Screenshot for error. (1)

I tried to start SQL Server...

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