Use this tag for questions specific to the 2008 version of Microsoft's SQL Server.
0
votes
1answer
11 views
Transorming data taken from Access in SQL Server 2008 R2
I have an Access table which contains two columns. ID and Name. There are in over 3000 rows of data here. Currently I have copied and pasted the table into a .txt file which is where it needs to live.
...
0
votes
0answers
12 views
Unable to create Audit in SQL Server 2008
Whenever I try to create new Audit in SQL Sever I get the following error:
Unable to cast COM object of type 'System.__ComObject' to interface type ...
0
votes
0answers
9 views
Import and export wizard error in sql server 2008r2
I am getting this error when i am trying to import data from tally erp9.0 using import and export wizard in management studio 2008.
0
votes
2answers
18 views
SQL server: where clause for optional fields
Track Id is optional field in my application.
Case 1: If I pass valid track id, it should return the respective rows.
Case 2: If invalid track id is passed, no rows should be returned.
Case 3: If no ...
0
votes
4answers
27 views
SQL Orderby on a subquery
I need to apply ORDER BY on a subquery, like:
select id,
(select c.Name
from User c
where c.Id = [Events].UserId) as "UserName"
from Events
ORDER BY UserName
I am getting the error:
...
1
vote
2answers
28 views
How to merge two rows into one for checking the status
I have a table that has logtime for the User with status as 1 & 2.
If the status is 1 then it in logIn Time and if the status is 2 then it is logOut Time.
So I want to display the log In & ...
0
votes
0answers
29 views
System function Definition
In SQL Server(SQL 2008), Is it possible to see the definition(Not the Name listing) of system functions like Aggregate functions(AVG,count..),Mathematical etc.
0
votes
1answer
29 views
Not getting null values when no data available
In my stored procedure, I declared @account_id, which sets as per the serial number.
if there are no matching records for the SERIAL_NUMBER, @account_id is not getting NULL value. WHERE condition is ...
4
votes
3answers
49 views
Retrieve Rows as columns in sqlserver 2008
i have a Table DistanceTable
It has Columns like
Slno From To Dist
-----------------------------
1 Vskp Hyd 100
2 Hyd Chennai 200
3 Chennai Vskp 458
Now i ...
0
votes
0answers
23 views
Getting Script Error while new pop-up window is open
i am currently working on an web site application in which while opening a new pop up window i am getting scripting error. So can u please help me to solve it out??!
It says me that error is occuring ...
0
votes
2answers
54 views
Need Sql query output like this format
I have one time sheet table when i fetch the records it will display like this for one week.
This record is from one week from June 10 to June 16
EmpId Monday Tuesday Wednesday Thursday Friday ...
0
votes
1answer
16 views
Filtering XML query by attribute value
I am trying to extract parameters from an xml field but can't seem to figure out how to filter my parameters by the parameter's name attribute.
XML
<parameters>
<parameter ...
0
votes
2answers
31 views
Is there any alternative to Cross Join in TSQL
I have two tables Table1 and Table2 where i need to find all the rows which satisfies the condition Fuzzy_Qgram(Approximate matching optimization) between Table1.LastName and Table2.LastName
Here is ...
0
votes
3answers
43 views
Remove multiple periods from a name in sql
I have a table(Person) which have a column uploads contain uploaded document, that have the extensions like .docx,.doc etc. But some of the users enter documents like ...
0
votes
1answer
8 views
Join parameter labels then separate by commas, join not working as expected
Current Code
="Project Groups: " + replace(join(Parameters!projGroup.Label )," ",", ")
Problem
Works fine if projGroup are one word. Ex: Group1, Group2, Group3.
My client has a change in ...
