SQL Server 2008 (codename Katmai) was released on August 6, 2008 and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes support for structured and ...
0
votes
0answers
6 views
sql parent child tree with sort order
Assuming this table
ParentId ChildId SortOrder
---------------------------------
0 1 0
1 2 1
2 3 1
2 4 2
2 ...
0
votes
0answers
15 views
SQL Query/Stored Procedure. Most Efficient Solution [closed]
I'm curious as to the most efficient way to handle this situation. I've always done this a certain way but I'm not going to divulge how until I hear other people's approach. Maybe your solution will ...
0
votes
3answers
22 views
SQL Server 2008 inner join with commas
i am trying to figure out how to inner join a table that has ID's to my table that have all the ids in one row seperated by commas.
The table with the commas is called (PA):
usersIDs
...
0
votes
2answers
8 views
SQL 2008 - insert into table with select script and a hardcoded value
I want to insert into a table the following information:
Week NoTrans Spend
02.01.12-08.01.12 11 520
The script I have is:
DECLARE @Week ...
0
votes
0answers
3 views
SQL Server 2008 Security, does db_datareader implicitly have VIEW DEF rights, etc
If a user belongs to the db-datareader database role, does he automatically have implied VIEW DEFINITION rights?
If the following is executed
GRANT EXECUTE TO [Domain\Account]
GO
..Does this ...
1
vote
0answers
12 views
ASP.MVC website production server configuration best practice [migrated]
When creating a new website on a production windows 2008 r2 server which requires connection to SQL Express should I create a custom identity for the application to run under or leave it as ...
0
votes
0answers
10 views
SharePoint database connection locks?
I have an issue with SharePoint content database. Daily starts 3 PM emails were sent to at least 100K users. This period content database completely Locking out and No request is accepting from Web ...
1
vote
2answers
30 views
How to read data from an XML variable?
I've an xml variable with the below given format, and I do need to dinamically read and load into some T-SQL structure the element names and its respective fields values:
declare @InputXml xml
Set ...
0
votes
0answers
44 views
SQL Server - is this good example for paging [closed]
Possible Duplicate:
What is the best way to paginate results in MS SQLServer
I am building stored procedure that should return to me first 15 rows when from database table when it is ...
2
votes
2answers
16 views
Referencing a #temp table from an external process
Using SQL Server 2008, I have two stored procedures -
create procedure [dbo].[SH_Export_data] (@unit varchar(5)) as
declare @sqlquery varchar(max) = 'select check_dt from chk_data where unit = '
...
0
votes
3answers
27 views
Varchar invalid for Sum operator
I have a table called Cos and the datatype of Amt is Float and sample data looks like:
Acct Period F_year Amt
Detf 1 2011 Null
Detf 2 2011 Null
Detf 3 2011 ...
1
vote
0answers
11 views
SSIS can't use variables (Flat File > OLE DB Command), Must declare the scalar variable “@”
Apologies, I'm an SSIS noob and I'm struggling with trying to import a flat file and do an OLE DB command WHILE including a variable in the SqlCommand.
You can see my query and the attempt to ...
1
vote
1answer
21 views
Applying grouped ranking using ROW_NUMBER
I m Looking for ways to assign the row numbers as below for the table
Roll No Name Score
1 ABC 10
1 ABC 10
1 DEF 8
2 ASC 9
2 ...
1
vote
1answer
16 views
Recreating SSRS Data Source in TSQL for testing
I have an SSRS data source that I would like to test out in SQL Server so that I can see the exact result set. The report that I'm using makes use of a multivalued parameter in the report which is ...
0
votes
3answers
46 views
SQL Server auto increment on composite key
I have a table with a composite key in SQL Server 2008 (this was done for various reasons/DB design, but a main one is b/c we are moving to a new schema and need to preserve data).
So I've created ...