Minnu (6/9/2015)

---

Hi Team,

Using below statement to export a table from sql server 2008 to EXCEL 2010

Insert into Openrowset

('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Export\XLS.xlsx;' ,

'SELECT * FROM [employees$]')

SELECT name,id,group,agency FROM dbo.employees

getting...

You may want to look at performance. With small amounts of data, the...

I don't know what language your data is in, but it's not English, and I can't read it. Please post some DDL that has CREATE statements for your...

A solution specific to your situation is impossible without more detailed information about ALL the tables, which may or may not be practical to provide. Additionally, it might...

madan.preeti2005 (6/5/2015)

---

I have one job which runs in sql server and fetches data from teradata. Currently it's dropping existing table and recreating with all amount of data in teradata and...

gacanepa (6/5/2015)

---

Thank you for taking the time to write! I believe your suggestion has definitely put me on the right track.

However, let me ask you a further question.

If I do...

Post your partition function.

GilaMonster (6/4/2015)

---

You're thinking about MSDE, the free version of SQL 2000....

It's not necessarily faster, and it's not likely any better, but here's how you might take the same scenario and use ROW_NUMBER():

DECLARE @Invoice TABLE

(

Invoice_Number int,

...

Please see the following on creating the partition function:

https://msdn.microsoft.com/en-us/library/ms187802.aspx

How about a computed (and persisted) column, set up to be YEAR(existingdatecolumn) ? That could be the basis of the partition function... Not sure that you...

Has anyone thought about the licensing ? I don't think SQL Express is by license, allowed to support multiple users, regardless of the MS Access intermediary... ...

Your configuration suggests a number of questions:

1.) Usage indicates about 58 GB out of 70 is "reserved", suggesting that with a server of this size, it might well be plausible...

Junglee_George (6/4/2015)

---

Thank you all for the replies.

Actually my need is to rearrange the JOINs and ON conditions in a meaningful readable way.

There are so many JOINs written in a very...

I'm going to go out on a limb on the basis of an early post by the original poster, and offer this:

DECLARE @trans AS TABLE (

TranID INT,

...