Tagged Questions

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 ...

learn more… | top users | synonyms (5)

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 ...

1 2 3 4 5 942
15 30 50 per page