sql-server-2008 Questions
5
Solved
Let's say I have stored a bunch of holidays in my database.
What I need to do is find out which is next work day excluding Saturdays and the public holidays defined in the database.
eg.
Let's sa...
Stertorous asked 9/2, 2012 at 9:20
2
I have a requirement where I need to find out whether SQL is installed with default instance or named instance.
Can someone please help me here how to find it?
Thanks in advance,
Sasikumar.
Beatrizbeattie asked 23/1, 2015 at 14:28
3
Solved
We have a lot of DBUsers in our database. We have to clean up all those users from the database. When I tried to drop the user from the DB it failed due to the following error
Msg 15138, Level 1...
Hocker asked 7/2, 2011 at 12:31
5
Solved
I have SQL Server Reporting Services 2008 and when I open the following URL:
"http://localhost/Reports/Pages/Report.aspx?someReport"
I'm getting report screen in which I fill my parameters and...
Fears asked 7/8, 2012 at 12:30
8
Here I have a table with a time column (datatype is integer), now I need to convert the integer value to time format HH:MM:SS:00 in SQL Server 2008.
Also need clarification in the above time forma...
Seattle asked 24/9, 2012 at 15:43
10
I don't want to create a custom function for that if such function already exists in SQL Server.
Input string: This is my string to convert
Expected output: This Is My String To Convert
Hemimorphite asked 2/3, 2011 at 6:34
3
Solved
I am pretty confused with the plethora of OLEDB providers found in creating a connection to a database in SSIS 2008 R2.
I would much appreciate if you could tell me what the following providers st...
Huberman asked 18/10, 2011 at 6:20
7
Solved
Vista just finished one of its many updates. After restarting my computer I try connecting to SqlServer2008 instance with Sql Server Management Studio and I get this error:
Error connecting to '.....
Spoke asked 10/6, 2009 at 12:33
7
Solved
I have a text memo field in SQL table that I need to remove the last character in the field if it's a comma.
So, for example, if I have these rows, I need to remove the commas from rows 2 and 4.
...
Sutherland asked 15/7, 2015 at 2:40
10
Solved
SELECT col1,
col2,
col3,
EXEC GetAIntFromStoredProc(T.col1) AS col4
FROM Tbl AS T
WHERE (col2 = @parm)
How to write this SQL query in SQL Server 2008?
Pluralism asked 24/1, 2013 at 17:10
4
Solved
Consider a Sample Table with two Column RoleId and User Name
Role | Name
1 AB
3 A
1 ABC
2 D
2 B
3 Abb
1 E
4 TE
How can i use SQL queries to get following Output.
Role | Name
3 A
3 Abb...
Ph asked 5/1, 2016 at 15:15
19
Solved
Have just deployed my Project on to my reporting Server.
I have multiple datasets which are referencing views which exist on the db on that server.
When I try to go into any report part I am gettin...
Pina asked 1/6, 2012 at 8:41
6
I have a file of a .sql file that is about 22,000 lines long. It's generated by something else, but basically just contains one update statement per line.
I get this error when I run the file in ...
Dressler asked 20/4, 2012 at 20:20
3
Solved
I have a table with stats for universities that looks like this:
StatID | UniversityID | StatValue
1 | 1 | 100
2 | 1 | 90
3 | 1 | 80
1 | 2 | 50
2 | 2 | 55
I'd like a query to return something li...
Vice asked 18/2, 2012 at 3:59
5
Solved
I am having SQL server 2008 and i am having 10 different databases in it and now i want to search one stored procedure that in which database the stored procedure is present.
Mentioned as duplicat...
Furthermore asked 23/3, 2015 at 9:47
2
Primarily, I needed to retrieve a list of users who are members of a particular group, in SQL Server. I did managed to find something on the net, which is working perfectly. Solution is as shown:
...
Roos asked 17/1, 2017 at 12:30
6
Solved
I have a SELECT request with 'inner join' in the joined table is a column with bit type.
I want to select 1 if in the joined table is at most one value with 1. If it is not the case the value will...
Outface asked 29/5, 2012 at 17:34
5
Solved
I have a table called tblAccounts whose contents will come from an excel spreadsheet.
I am using MS SQL Server 2008 (x64) on a Windows 8.1 (x64)
I tried using the SQL Server Import/Export Wizard ...
Whimsicality asked 20/11, 2013 at 0:44
8
Solved
I am trying to retrieve around 200 billion rows from a remote SQL Server. To optimize this, I have limited my query to use only an indexed column as a filter and am selecting only a subset of colum...
Estray asked 28/7, 2011 at 21:55
12
I know a typical way is like this:
IQueryable query = from staff in dataContext.Staffs;
if(name1 != null)
{
query = from staff in query where (staff.name == name1);
}
However, from a program we...
Underage asked 26/4, 2011 at 8:30
12
Solved
I am getting the above error while creating a report in SSRS. I am trying to get 2 data sets from 2 databases, and I did so by creating a master report with data from Dataset1, and a subreport with...
Potency asked 8/7, 2013 at 19:40
5
Is there such a software out there? It doesn't matter if the data itself make sense. I am just worried about the fields to get populated. Basically, it will read the table definitions and generate ...
Pleurodynia asked 25/3, 2013 at 5:46
14
Solved
I have a select query that has DURATION column to calculate number of Minutes . I want to convert those minutes to hh:mm format.
Duration has values like 60, 120,150
For example:
60 becomes 01:0...
Citrin asked 18/7, 2013 at 20:49
11
I'd like to make an SQL query where the condition is that column1 contains three or more words. Is there something to do that?
Caffeine asked 7/1, 2015 at 19:43
9
Solved
I have the following table
Name | Subject | Marks
--------------------------
a M 20
b M 25
c M 30
d C 44
e C 45
f C 46
g H 20
Here I have a "Student" table I want to get the Name of ...
Perspicacity asked 5/8, 2013 at 12:28
1 Next >
© 2022 - 2024 — McMap. All rights reserved.