abelwingnut (3/10/2016)

---

Hi,

Thanks for the advice and the welcome.

I was confusing in my post. That DECLARE/INSERT statement I posted constitutes a portion of the whole query. Following that snippet of code...

Hello and welcome to the forum.

Presumably you are doing this all in a dataflow task?

I see no reason whatsoever for the table variable. I suggest that you change the data...

Hi Andy

Thanks for the article – I think I missed it the first time round.

I wonder whether you have any intention of talking about how to set up scripted deployments...

avadeshuwaran (3/9/2016)

---

Hello,

My name is Avadesh, and I'm new to this forum. Nice to be here!

I have this SQL agent job that runs on a daily basis that calls & execute...

scohn 53313 (3/10/2016)

---

Thanks, it worked.

I have a small confession, I’m not a programmer, I’m a DBA. I’ve lived happy 48 years without knowing about the existence of GAC and...

danghita74 (3/9/2016)

---

Hi guys

I'm using an ODBC driver to access a proprietary file type database (having multiple files). So I have multiple managed ODBC connections defined, each using a DSN to...

ravi@sql (3/10/2016)

---

HI Champs,

I have huge table of 70 million records and 300 columns, and it is partitioned based on Monthkey column.And it is having clustered index as well .

Am...

TheSQLGuru (3/9/2016)

---

I'm going to STRONGLY disagree with any notion anyone might have that putting this lookup stuff into a table (of any flavor) and joining to it in in a...

ganapathy.arvindan (3/9/2016)

---

Thanks !!! Same Case statement(same code) used in 4 select statements in single SP so i thought instead of writing 4 times,whether there is anyway i can write this...

Post the full error message, please.

vincenzo_capelli (3/8/2016)

---

Hi,

I have created into my SERVER1 a SSIS package (into a Integration Services Catalogs), this package is parametric so I have create many Environments each with specific parameters.

If I...

NP – this one catches everyone.

According to Brent Ozar, RC0 is out[/url].

dallas13 (3/8/2016)

---

Hi, I have sql 2005 SSIS package. Inside that I have OLE DB source Editor that connects to sql 2005 db and it has one SP that uses dynamic...

Notwithstanding the above request, it looks like the column you are trying to sort on is an INT and you want to sort it as if it were a VARCHAR()....