valhala

supercalifornication?

ahh. i need to get my...

SQL Kiwi (9/14/2012)

---

capnhector (9/14/2012)

---

i could see this going away in the next version of Sql Server (version after 2012). Reason being *= and =* no longer work as of...

SQL Kiwi (9/14/2012)

---

GSquared (9/14/2012)

---

Or "by design because they hoped it would never come up and couldn't figure out a good solution for it". I've seen that one before too....

super freak

Another gnu program to look at is cURL. It is a little more complex than wget but can download every protocol under the sun

nope. with...

SQLRNNR (9/13/2012)

---

stanlyn (9/13/2012)

---

Gail,

From that article, did you read the very last part as show here:

It is quite simple to fix this error, but you will need to delete all the...

polkadot (9/13/2012)

---

I've installed SQL Server 2012 (Enterprise trial) onto my laptop running Windows 7 Home Premium.

I've downloaded the AdventureWork2012 database to my C:\Downloads folder.

When I run this statement...

RBarryYoung (9/11/2012)

---

GSquared (9/11/2012)

---

SSIS has an FTP object that can be used to automatically download the files. Won't work if it's FTPS, but will for FTP. Will that work...

bell ringer

could also use something like:

insert into table1 (Values)

SELECT values

FROM table2

LEFT JOIN table1

ON table2.somecolumn = table1.somecolumn

WHERE table1.somecolumn IS NULL

at lease i think since...

it works over your small data set. not sure if you can get rid of the distinct with so many columns you are grouping by.

here is the solution:

WITH RN...

quick question to the threadzians, is any one else going to be at #sqlsat154 in St Louis? wondering if its going to be a lonely first professional event for...