Use this tag for questions specific to the 2008 R2 version (sql.100) of Microsoft's SQL Server.
0
votes
0answers
2 views
Install Sql Express 2008 R2 SP2 with NSIS
I am writing NSIS installer that needs to install Sql Express Server as part of install. I am using following script for install:
ExecShell '"SQLEXPRWT_x86_ENU.exe" /Q /ACTION=Install ...
0
votes
0answers
8 views
Select from alternative table if NULL query performance
I want to select data for a specific variable. There are three Databases (DR, DR1, DR2). The most recent data lies in DR but gets delete after 2 months. DR1 / DR2 contain archive values as 15 minute ...
0
votes
0answers
7 views
Inside a function i need to access a select query result
This is the code
Create Function dbo.HybFillRate(@percen Float=0.9, @strTable varchar(max), @strField Varchar(max), @strCriteria As Varchar(Max)=Null)
RETURNS Float
AS
BEGIN
--Drop table HyFilrate
...
0
votes
0answers
7 views
Fast native SQL, but slow LINQ-to-SQL
See the following simple queries:
var stringList = db.A.Where(a => IsTrue == true).Select(a => a.string);
foreach string in stringList:
var c1 = db.ExecuteQuery<int>("SELECT COUNT(*) ...
0
votes
1answer
16 views
Model for listing Items
I want to list names from database based on the alias ID
public class Name
{
int _nameID,_aliasID;
string _nameNA;
}
public List<Name> Names(int aliasID)
{
...
1
vote
1answer
16 views
conditionally merge and aggregate adjacent rows in T-SQL
I have a 100K-row table representing sales during a particular time period. Usually the periods are at least a few hours long, but occasionally we get a period that's only a few minutes long. These ...
1
vote
2answers
29 views
Breaking out yearly payments into monthly payments with month name in a 3 year period
I was wondering where to go from my initial idea. I used the query below to get the month beginning dates for each of the three years:
DECLARE @STARTDATE DATETIME,
@ENDDATE DATETIME;
SELECT ...
0
votes
0answers
19 views
MS SQL 2008 Job Fails
I created an SSIS package to export a flat file based on a query using the Import/Export wizard. I used Windows Authentication for everything and have the flat file saved to a different server on the ...
0
votes
0answers
5 views
SQL Server unattended install with dependencies
There is an installation system which install SQL Server 2008 R2 Express in unattended mode. All works fine, but on different machines required modules could be missing like Windows installer 4.5, MS ...
0
votes
0answers
3 views
Exception displaying charts in visual studio from SSAS cube
I am working on a BI project , I displayed charts from an SSAS project, then I modified the SSAS project and tried to display the charts but this exception appears
Could not load file or assembly ...
0
votes
2answers
25 views
Grouping values by month and by quarter
I have data like
MyTable
person datetimeField datavalue1
a 20110104 3
a2 20110105 2
b 20110302 5
c 20110403 6
d 20110605 ...
0
votes
1answer
28 views
SQL Server count entries in one table against another table
I have two temporary tables in SQL Server 2008
Table 1, results_types
------------
| Result_1 |
| Result_2 |
| Result_3 |
| Result_N |
------------
Table 2, all_results
--------------------
| ...
0
votes
0answers
9 views
SQL Server 2008 r2 Transactional Replication [migrated]
here is the deal. we are planning to create a Transactional replication on 2 nodes of SQL server 2008 r2, each node will be a publisher and a subscriber. my question is:
What is the best practice in ...
1
vote
0answers
14 views
Extracting content from OneNote to Sql Server
i need to know if there is any way possible for me to extract content in a OneNote notebook/section to a sql server database.
basically what i need to do is.. read the content from OneNote and insert ...
0
votes
0answers
12 views
Can i install two seperate applications on the same Sql Server 2008 port
I have installed SharePoint 2013 on port 1433 for my SQL Server2008 r2. and now I want to install another application on the same server. and for the second application I need to use MS SQL server . ...
