hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don’t have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the [...]
Answer Question | January 14, 2009 2:29 PM
iSeries SQL, SQL, SQL Copy Record, SQL Record
I have 1 main report that contains lists. In each list are many subreports. The subreports are called multiple times based on the grouping in the list Problem: There is one particular subreports that shows the zero amount after deployment. However, the results are accurate when viewed in Visual Studio. This subreport is called many [...]
Answer Question | January 13, 2009 8:56 AM
Reporting Services 2000, SQL Server Reporting Services, Visual Studio, Visual Studio ReportViewer
sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?
Answer Question | January 13, 2009 3:28 AM
Carriage Return Line Feed, Concatenate, CRLF, CRLF SQL2005, SQL, SQL Server 2005
Hi, I have a cube which on a daily basis partitions will be created Partition names: shipment2008_12_31 shipment2009_01_01 shipment2009_01_02 shipment2009_01_03 shipment2009_01_04 …. . . . . I have to process the partition based on the day. If the day is 03 jan 09 the package has to process shipment2009_01_03 (Full partion processing) If the current [...]
Answer Question | January 12, 2009 6:08 PM
Partion processing, SSAS 2008, SSIS, SSIS Package 2008
We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?
Answer Question | January 14, 2009 4:32 PM
Access Database, Microsoft Access, Password management, SQL Server 2005, SQL Server databases
How much does it cost to buy SQL Server 2005 Standard or Enterprise Edition, and how do they differ from SQL Server Express Edition?
Answer Question | January 13, 2009 4:28 PM
SQL Server 2005, SQL Server Express Edition
How we can create a username and password on my SQL Server database?
Answer Question | January 12, 2009 4:26 PM
Password management, SQL Server databases, SQL Server security
what is the difference between the way of using storedprocedure component in delphi5 and delphi7?
Answer Question | January 12, 2009 1:36 PM
Delphi, Delphi 5.0, Delphi 7.0, Stored Procedures
i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?
Answer Question | January 9, 2009 5:37 PM
Server mirroring, SQL Server 2005, SQL Server backup and restore, SQL Server Mirroring
I am failing to understand why the following won’t work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don’t understand why I get higher values on SUM(d2.amt) than [...]
Answer Question | January 9, 2009 4:46 PM
DB2, DB2 SQL, SQL
I am trying to migrate some Employee absence data, from one table to another. The data currently looks like: Employee, Date, Reason ———————— dave,01/01/08,sick1 dave,02/01/08,sick1 dave,03/01/08,sick2 dave,04/01/08,sick1 dave,05/01/08,sick1 bob,01/01/08,sick1 bob,02/01/08,sick1 bob,03/01/08,sick3 bob,04/01/08,sick3 bob,05/01/08,sick3 The data needs to group by Employee, Consecutive dates, and reason. Output would look like: Employee,From,To,Reason ———————— dave 01/01/08 02/01/08 sick1 dave [...]
Answer Question | January 9, 2009 1:53 PM
SQL, SQL Database, SQL Database Grouping
- using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.
Answer Question | January 12, 2009 9:30 AM
SQL queries, SQL Server 2000, SQL Server 2000 queries
Hi. This may seem really stupid, and well it is. I have a customer who is running ISA 2000 primarily as a web cache. It is not used for security in any way, in fact, users can just turn off their proxy settings and access the internet, so security is not really an issue here. [...]
Answer Question | December 14, 2011 12:10 AM
Firewalls, ICMP, Internet Control Message Protocol, ISA Server, ISA Server 2000, Ping, Web security, Windows Server 2003
Hi, I was wondering if there is a way to find the next autonumber in a SQL table before inserting the record? I tried just looking at the previous number and adding one but if I delete the last record then this wouldn’t work or if I delete all the records then the number won’t [...]
Answer Question | January 11, 2009 6:14 PM
SQL, SQL AutoNumber, SQL tables
SQL 2000 (sp4) instance with databases at compatibility level of 65 and 80. Is changing the compatibility level from 65 to 80 actually upgrading the database to 80? What should be done before and after changing the Compatibility level?
Answer Question | January 11, 2009 6:06 PM
SQL Server 2000, SQL Server 2000 SP4, SQL Server Compatibility Level, SQL Server database
I have a question regarding SQL Server upgrades. We have two active/passive clusters on which SQL Server 2000 resides. I want to install SQL Server 2005. How would I go about doing this?
Answer Question | January 11, 2009 3:31 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want [...]
Answer Question | January 15, 2009 3:29 PM
SQL Server, SQL Server Scripts, SQL Server stored procedures, SQL Server tables
How do I know what the public key is for a given private key in an asymmetric encryption on a SQL Server?
Answer Question | January 8, 2009 3:28 PM
Public Key Encryption, SQL Server
Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible… What is our best option?
Answer Question | January 9, 2009 10:40 AM
SQL Server 2005, SQL Server 2005 backup, Veritas Backup Exec 9.1
I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = ‘<tablename>’ and column_name = ‘<columnname>’ Along these lines, is there a way to retrieve datatypes from SQL Server stored procedures?
Answer Question | January 7, 2009 4:41 PM
SQL Server 2000, SQL Server stored procedures, SQL Server tables