Tagged Questions
-4
votes
0answers
31 views
Is there any reporting software integrated with SQL Server? [closed]
I have database and I want to analyse it and make statistics depending on charts, so,
Is there any software integrated with SQL Server to generate reports and charts?
Any Open source tool, any paid ...
0
votes
1answer
19 views
Datetime colum to float type conversion is getting issue in sql server
I'd like alter a column type from Datetime to float. Hence, I executed the below query but it was getting a issue
alter table dbo.purchasedate
alter column supp_dt float null
Error :: Implicit ...
0
votes
1answer
31 views
Creating Autoincrement on AlphaNumeric in Stored Procedure
My Table:
CREATE TABLE USER_DATA
([ID] NVARCHAR(10),[NAME] NVARCHAR(50))
My Stored Procedure:
CREATE PROC SP_INSERT_USER
@NAME VARCHAR(50)
AS
BEGIN
DECLARE @ID NVARCHAR(50)
DECLARE @IDTEMP INT
...
-3
votes
1answer
34 views
What is the main difference between incremental and transaction log backup in SQL Server? [closed]
Can any one tell me the main difference between incremental and
transaction log backup in SQL Server 2008?
-1
votes
3answers
48 views
How to resolve CASE statement error?
I have a fieldname called runTotal which is an integer.
I am trying a CASE statement that assigns values to the highest total:
select (case when isnull(t.runtotal,90) = 0 then 'You have reached max ...
0
votes
1answer
53 views
is it possible to find out how much of the db data is older than some N years in SQL Server?
I have two database in SQL Server. I wanted to find out the data older than (let say 3) years.
I know the database creation date, currently I have around 550 GB (both the database) of data spanned ...
0
votes
1answer
61 views
Inner join of multiple dynamic select statements
Hello i need to extract common data by applying inner join which is obtained on each loop in @sql variable.I want to apply inner join on result obtained by first loop on @sql to second and so on.For ...
1
vote
3answers
61 views
Sum when field does not exist
I have the following table:
create table #tbl
(
[type] varchar(20),
[qty] int
)
insert into #tbl values ('Type A', 10)
insert into #tbl values ('Type A', 15)
insert into #tbl values ('Type B', ...
0
votes
0answers
16 views
Find reached the starting point of the search message missing in SSMS
There is a problem concerning restoring settings in SSMS. When using the find functionality to find some text in a document in SSMS (both 2005 and 2008), when the last occurrence of the text is found ...
1
vote
2answers
70 views
Changed database from MSSQL 2005 to MSSQL 2008 [closed]
I changed my database from MSSQL 2005 to MSSQL 2008 and now I'm having this error message. The site was working perfectly before changing the database
Server Error in '/' Application.
Compilation ...
0
votes
1answer
29 views
Best practise custom paging SQL server 2005
I'm got trouble with paging on SQL server 2005 which run query 2 times (get data and total rows). My demo proc below which base on Northwind database. Please help me to how to get total rows without ...
0
votes
0answers
21 views
how to my sql server 2005 db to sql server 2008 while its working
we want to merge 2 dbs; one on sql 2005 and another on sql 2008. destination db is sql 2008 one. both these dbs are in use currently. I'm searching for the best way to do this
transmission by least ...
-1
votes
2answers
63 views
How to hide Passwords in Sql Server Table from others [closed]
I have a column that holds a password..i want to do is simply mask the password with the standard password character (*) or Simply hide...
Thanks in advance....
1
vote
1answer
70 views
Dynamic query construccion looping conditions from a XML?
I need to construct a part of the conditions of my sql query from a xml.
I have a XML like:
<ROOT>
<PARAMETROS>
<USU_LOGIN>yleon</USU_LOGIN>
...
1
vote
4answers
42 views
Why is IN operator showing wrong results?
I have this table BarCode, when I do a in query like this
SELECT Barcode
FROM BarcodeTable
WHERE BarCode IN
(
'53-3-1',
'51-1-1',
...
