Sean Lange (5/13/2013)

---

Lowell (5/13/2013)

---

Only because i have a macro that converts pasted text to a CTE; you built a complete sample DDL...

raghusg (5/13/2013)

---

Hi,

We have two different Windows 2008 R2 servers (Server1 and Server2) on the same domain. The questions I have are:

1) Can I have the same...

Only because i have a macro that converts pasted text to a CTE; you built a complete sample DDL for it.

it seems like a basic grouping can get you the data you want;

run this in SSMS, does this give you teh data youa re looking for?

with mySampleData ([Sales Order #],[InvoiceID],[InvoiceDate],...

you need the version with SQL 2012 with Advanced Services or SQL 2012 Express with Tools:

Advanced Services includes the SSMS Express version.

http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

since you already installed the Express engine, you could...

Both Have SQL = "Structured Query Language" in their names;

As Far as I know, T-SQL (Transact SQL) is the nickname for Microsoft's version of SQL, as opposed to PL SQL(Oracle's...

That's part of SSIS, so you'd need either SQL Developer, or SQL Standard/Enterprise/Data Center editions. it is not included in the Express editions.

Tim in this case, i'm not sure;

I created a Simple Class library, and this is teh entire code, which compiles correctly in the full version of Visual Studio 2010;

My project...

SpiderDK (5/13/2013)

---

Yes, but this only allows me to group on class / type of statement.

I would like to group simular statements

select * from table1 where id = 1 order by...

also, to create a view on Server 2, FROMserver 1, you need to do one of two things:

either the SQLcmd needs to actually connect to server 2, and not...

can't help that much yet;

you didn't mention any specific error you get back, and it might be nice to see the actual command you are using in sqlcmd to...

martin.kerr 34088 (5/13/2013)

---

Hi All,

I have managed to set up a linked server to a MySQL database and i want to update the MySQL database using a table within SQL Server....

http://www.ssmstoolspack.com/Download

if your SQL2008 is 64 bit, you must install the 64 bit ACE drivers; the JET driver is only valid for 32 bit, and it won't work on .xlsx files(or...

i think it's the usual; there's no easy way, but you can use the metadata to build your commands to add everyone to a deny everything group

something like this is...