Home > MS SQL Development
MS SQL Development
MS SQL Development forum discussing administration, MS SQL queries, and other MS SQL-related topics. SQL Server is Microsoft's enterprise database engine.
When is it valid to use an alias in SQL? HAVING and ORDER BY give errors.
I get a "parameter value(s) required" error when I use an alias (defined in a SELECT clause) in a HAVING or ORDER BY clause. But SQL syntax seems to say that the use of an alias in these situations is OK. Can you explain. Thank you v...
I get a "parameter value(s) required" error when I use an alias (defined in a SELECT clause) in a HAVING or ORDER BY clause. But SQL syntax seems to say that the use of an alias in these situations is OK. Can you explain. Thank you v...
answer(0) view(20) status(
)
)
DTS package fails: [DBNETLIB].....
SQL Server is running on my PC. The server name is 'ASPEN'. When I create a DTS package to export a local database to our live site, I must use 'LOCAL' for the server name, not 'ASPEN'. Everything runs fine the first time, but later, whe...
SQL Server is running on my PC. The server name is 'ASPEN'. When I create a DTS package to export a local database to our live site, I must use 'LOCAL' for the server name, not 'ASPEN'. Everything runs fine the first time, but later, whe...
answer(4) view(935) status()
)
"Running Balance" query
Hi, I'm still in the data modelling stage, and have read over some general ledger database design principles, but wondering if someone can help with a query I'm looking to generate. Currently, all transactions would be placed in the T...
Hi, I'm still in the data modelling stage, and have read over some general ledger database design principles, but wondering if someone can help with a query I'm looking to generate. Currently, all transactions would be placed in the T...
answer(3) view(327) status()
)
Please help with the SQL COUNT statement!
I'm trying to run this SQL statement in my ASP code, sql="SELECT COUNT(*) FROM order_list WHERE ref_index='"&ref_index&"'" The problem is, should i create a variable to store the returned integer? I tried rs_...
I'm trying to run this SQL statement in my ASP code, sql="SELECT COUNT(*) FROM order_list WHERE ref_index='"&ref_index&"'" The problem is, should i create a variable to store the returned integer? I tried rs_...
answer(4) view(79) status()
)
where to create a new DB with scripts
Hellow, I'm new in MS SQL. in Oracle we can use sqlplus to run a script created elsewhere. Where and how can I run a sql script to create my database? Is there any ghrapfical tools to manage tables and to create triggers or indexes? ...
Hellow, I'm new in MS SQL. in Oracle we can use sqlplus to run a script created elsewhere. Where and how can I run a sql script to create my database? Is there any ghrapfical tools to manage tables and to create triggers or indexes? ...
answer(4) view(885) status()
)
new forum
about time is all i have to say.
about time is all i have to say.
answer(2) view(412) status()
)
HELP joining two tables
Hello, I am creating a view that displays service codes and descriptions. I have two tables. Table 1 has service codes and table 2 has service code and description. all of the fields in table 1 are dependant on table 2. For exampl...
Hello, I am creating a view that displays service codes and descriptions. I have two tables. Table 1 has service codes and table 2 has service code and description. all of the fields in table 1 are dependant on table 2. For exampl...
answer(4) view(1,032) status()
)
Wierd problem reading database using java
Hi, I'm having trouble producing a web page in JSP that access an MS SQL Server 8.0 database. I execute the query sql = "SELECT jobid, name, sum(hours) as hours, firstname, lastname"; sql = sql + " FROM machinehours&quo...
Hi, I'm having trouble producing a web page in JSP that access an MS SQL Server 8.0 database. I execute the query sql = "SELECT jobid, name, sum(hours) as hours, firstname, lastname"; sql = sql + " FROM machinehours&quo...
answer(1) view(979) status()
)
Win2k3 and DTS Folder access
When running a scheduled job from sql srv 2000 on win2k3, I get a "path not found" error msg in my Activex script task (I'm using Scripting.FileSystemObject). Its a UNC path name and everyone has folder access and folder exists...
When running a scheduled job from sql srv 2000 on win2k3, I get a "path not found" error msg in my Activex script task (I'm using Scripting.FileSystemObject). Its a UNC path name and everyone has folder access and folder exists...
answer(3) view(347) status()
)
Renaming Database
I got an MSSQL database which I'm trying to export to MySQL using DTS, the name of the database is MyDatabase.com and when I try to export the tables I get the following error: Code: Error Source: Microsoft OLE DB Provid...
I got an MSSQL database which I'm trying to export to MySQL using DTS, the name of the database is MyDatabase.com and when I try to export the tables I get the following error: Code: Error Source: Microsoft OLE DB Provid...
answer(1) view(957) status()
)
sysperfinfo Table
I'm wanted to use sysperfinfo table for DB performance monitoring but all the value remain always at 0. Do I need to start a specific process or module? Run an specific command? Environement is MS SQL server 2000 on Windows 2000 advanced ...
I'm wanted to use sysperfinfo table for DB performance monitoring but all the value remain always at 0. Do I need to start a specific process or module? Run an specific command? Environement is MS SQL server 2000 on Windows 2000 advanced ...
answer(0) view(72) status()
)
SQL Debuggers
Do you any other sql debuggers besides the sql query analyzer?
Do you any other sql debuggers besides the sql query analyzer?
answer(2) view(971) status()
)
Replication Issues
Hi All, I have made Merge Replication using SQL Server 2000.Windows 2000 Server as Publisher and Windows 2000 Professional as Subscriber. I am using Pull Subscription for that. MSmerge_contents table is created on both publisher an...
Hi All, I have made Merge Replication using SQL Server 2000.Windows 2000 Server as Publisher and Windows 2000 Professional as Subscriber. I am using Pull Subscription for that. MSmerge_contents table is created on both publisher an...
answer(0) view(384) status()
)
sql riddle
I have 2 tables the first table custAddress contains the fields recordNum, first name, last name, address, city, state, zip, phone the second table called corrected_info and contains recordNum, first name, last name, address, city, state...
I have 2 tables the first table custAddress contains the fields recordNum, first name, last name, address, city, state, zip, phone the second table called corrected_info and contains recordNum, first name, last name, address, city, state...
answer(1) view(515) status()
)
SQL Comparing dates prob in ASP
Hello! can anyone please help or had similar problems? I have an Access database with a field named 'bid_close_date' (data type = 'Date/Time' - General Date: DD/MM/YYYY HH:MM:SS) in a table named tblplayers. I am running the foll...
Hello! can anyone please help or had similar problems? I have an Access database with a field named 'bid_close_date' (data type = 'Date/Time' - General Date: DD/MM/YYYY HH:MM:SS) in a table named tblplayers. I am running the foll...
answer(1) view(962) status()
)
MySQL could not be started
I installed Red hat linux 9 and then i installed mysql. When i tried to to start mysql using safe_mysqld & the daemon got started and then ended in a sudden. Got a message "030828 mysql ended ". What may be the problem. Pl...
I installed Red hat linux 9 and then i installed mysql. When i tried to to start mysql using safe_mysqld & the daemon got started and then ended in a sudden. Got a message "030828 mysql ended ". What may be the problem. Pl...
answer(1) view(1,010) status()
)
Apologies for the question!
Hi - I'm not a developer by any means so apologies if this is a stupid question. I have MSSQL hosting, which is fine as I have had an web application developed which uses an SQL database and everything is currently working OK. Now, I'm ...
Hi - I'm not a developer by any means so apologies if this is a stupid question. I have MSSQL hosting, which is fine as I have had an web application developed which uses an SQL database and everything is currently working OK. Now, I'm ...
answer(3) view(937) status()
)
Query Help
Hello ppl, Let me get straight to the point. I have three tables: - 1.)Movies-contains fields Movie_Id(PK) and Movie_Title 2.)Actors-contains fields Actor_Id(PK) and Actor_Name 3.)MoviesActors-contains fields Movie_Id(FK) and Actor_Id(F...
Hello ppl, Let me get straight to the point. I have three tables: - 1.)Movies-contains fields Movie_Id(PK) and Movie_Title 2.)Actors-contains fields Actor_Id(PK) and Actor_Name 3.)MoviesActors-contains fields Movie_Id(FK) and Actor_Id(F...
answer(4) view(925) status()
)
need to restore database, need consultant
We are in need of immediate help restoring information to an exisiting database. We have downloaded the "dump.txt" file but the restoring process is not working. Please call 1-800-965-3976 if you can help right now. Thank yo...
We are in need of immediate help restoring information to an exisiting database. We have downloaded the "dump.txt" file but the restoring process is not working. Please call 1-800-965-3976 if you can help right now. Thank yo...
answer(0) view(745) status()
)
Importing a database
Hi, I have SQL Server 2000 running on an NT server. I have set up another server also running SQL Server 2000 under Windows 2000. I want to use the 2000 server for test purposes. I have a backup of the existing database on the NT...
Hi, I have SQL Server 2000 running on an NT server. I have set up another server also running SQL Server 2000 under Windows 2000. I want to use the 2000 server for test purposes. I have a backup of the existing database on the NT...
answer(10) view(924) status(
)
)
Dts
Hi, Is it essential that no one is using the database when using the Data Transformation Services ? I was wondering if I could run it during the day when users were accessing it. If I could run it during the day would the performance hi...
Hi, Is it essential that no one is using the database when using the Data Transformation Services ? I was wondering if I could run it during the day when users were accessing it. If I could run it during the day would the performance hi...
answer(3) view(513) status()
)
Problem with Analysis Services
Hi all, Wasn't sure where to post this since it encompasses more than just SQL Server. Anyway, I'm trying to set the SliceValue for the time dimension of a partition. The problem I have is that a Carriage Return is being added to each...
Hi all, Wasn't sure where to post this since it encompasses more than just SQL Server. Anyway, I'm trying to set the SliceValue for the time dimension of a partition. The problem I have is that a Carriage Return is being added to each...
answer(0) view(617) status()
)
User defined functions for proper case
I am trying to write a function that takes as its input, a proper name and returns the name in proper case. For example, I type in JON DOE and it returns Jon Doe, or jon doe and returns Jon Doe. Any help would be greatly appreciated.
I am trying to write a function that takes as its input, a proper name and returns the name in proper case. For example, I type in JON DOE and it returns Jon Doe, or jon doe and returns Jon Doe. Any help would be greatly appreciated.
answer(4) view(526) status()
)
Ms Access-Display unique records
I have joined 3 Tables Manually. I have written the following Query in SQL View to count all the unique CustomerID records in Table1. SELECT COUNT(CustomerID) FROM Table1 GROUP BY CUSTOMERID The result counts the unique records in ...
I have joined 3 Tables Manually. I have written the following Query in SQL View to count all the unique CustomerID records in Table1. SELECT COUNT(CustomerID) FROM Table1 GROUP BY CUSTOMERID The result counts the unique records in ...
answer(14) view(539) status()
)
automatic backing up mssql
How to backup of all databases in mssql ? I want to put them on a folder . Any ideea or script ?
How to backup of all databases in mssql ? I want to put them on a folder . Any ideea or script ?
answer(1) view(58) status()
)
problem with covert function!
Hello all: we want to insert date into table testDate in Datetime or another dataType in field testDate and extract it in hijry Date format And compare it with two Date. acording to the articles we insert it in to the table in nchar dat...
Hello all: we want to insert date into table testDate in Datetime or another dataType in field testDate and extract it in hijry Date format And compare it with two Date. acording to the articles we insert it in to the table in nchar dat...
answer(2) view(766) status()
)
Tring to find the Median
Hi, I have written some code to find the Average score, only to find that I need to be looking for the Median score. I am not sure how I would go about getting the median instead of the average. This is what I wrote. Does anyone have a...
Hi, I have written some code to find the Average score, only to find that I need to be looking for the Median score. I am not sure how I would go about getting the median instead of the average. This is what I wrote. Does anyone have a...
answer(0) view(149) status()
)
Ordering Problem
Hi, I'm having a problem with a SQL statement in a stored procedure, I am building the statement in the procedure because I want to vary the 'order by' clause. In effect I want the top ranking 5 employees to stay the same regardless of t...
Hi, I'm having a problem with a SQL statement in a stored procedure, I am building the statement in the procedure because I want to vary the 'order by' clause. In effect I want the top ranking 5 employees to stay the same regardless of t...
answer(1) view(600) status()
)
text field truncated
I'm making a query. But a text field is truncated, just the half is showed, Someone know how to fix this? Regards.
I'm making a query. But a text field is truncated, just the half is showed, Someone know how to fix this? Regards.
answer(2) view(584) status()
)
sql query question...
Here is a snippet of my query..... select top 500 MAX (distinct userip), count(*) as hits, username, sum( convert( bigint, bytecount))/1024 as bytecount_MB, 0 as blocks from webproxy.dbo.transactionsunday group by userip, username ...
Here is a snippet of my query..... select top 500 MAX (distinct userip), count(*) as hits, username, sum( convert( bigint, bytecount))/1024 as bytecount_MB, 0 as blocks from webproxy.dbo.transactionsunday group by userip, username ...
answer(0) view(1,028) status()
)
Programming
- PHP Development
- Perl Programming
- C Programming
- Java Help
- Python Programming
- ASP Programming
- .Net Development
- Visual Basic Programming
- XML Programming
- WAP Programming
- HTML Programming
- JavaScript Development
- CSS Help
- Flash Help
- Photoshop Help
- Web Design Help
- Database Management
- MySQL Help
- MS SQL Development
- Oracle Development
- Mail Server Help
- Apache Development
- DNS
- IIS
- Networking Help
- FTP Help
Related Pages
- From where can i learn basic ms sql?
- Tranform columns to rows with multiple values
- Can it be done? Backup remote db to local db
- SQL service help
- Problems with a SELECT SUM() AS statement
- Recordset types
- Stumped - LEFT JOIN
- can't connect from web application
- Multiple Left Joins (2 Left Joins 1 big headache)
- Function not returning all the data, just some
- Using PM of two tables as a PM of third table
- Security in developing?
- SQL License
- Help with Query
- Connection through Dreamweaver issue
- How to save xml document in database
- recordset error while filling the listbox
- Unique Field
- organising and schedualing a file
- SQL Server Permissions
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2010 by Infoqu. All rights reserved
Copyright 2007-2010 by Infoqu. All rights reserved