Moving average in TSQL

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93911

Random Order...

INSERT TOP (2) INTO Table2 (ColumnB)

SELECT ColumnA FROM Table1

ORDER BY ColumnA;

The ORDER BY clause in the previous query...

alban_ml (11/16/2011)

---

<connectionStrings>

<add name="Business.Properties.Settings.SchooldbConnectionString"

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Schooldb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

...

How will you validate they are last 5? (if there is no ORDER BY clause)

Yes. SQL Server support side-by-side installations of different versions / editions.

Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008

http://msdn.microsoft.com/en-us/library/ee210714.aspx

okbangas (11/16/2011)

---

tt-615680 (11/16/2011)

---

Here is my scenario:

We have an application which we use C#, but the way the Architecture for creating the Application is that only Views can be used...

tt-615680 (11/16/2011)

---

Here is my scenario:

We have an application which we use C#, but the way the Architecture for creating the Application is that only Views can be used to...

I didn't try it myself....

sys.databases (Transact-SQL)

Contains one row per database in the instance of Microsoft SQL Server.

log_shipping_primary_databases (Transact-SQL)

Stores one record for the primary database in a log shipping configuration. This table is stored in...

I understand, user would be able to...

hi!

i have create a vizual c# program linq to sql ..when i whont to open the databse from vizual i have this error ...

Cannot open database requested by the login....

Do it step by step...

First create a package with Export Import Wizard. It means, Open the wizard, Select source, destination etc. and save it as SSIS Package.

Once done, open this...

alban_ml (11/15/2011)

---

at first time i run the program as administrator and the test connection go OK

but when i do the test now i got a error

can i send you the...

CREATE PROCEDURE P1

AS

SELECT * FROM VW_V1; -- VIEW

If you are asking this, it’s possible.

If you know little bit of SSIS?

Yes:

1) Create one SSIS Package with Export Import Wizard.

2) Modify it to loop through 300+ files.

2) Execute Package & you are Done. 🙂

No:

Do the...