I have a right join query where i have a table where all employees attendance entry are registered and another table where pay master table where al employees details. I need a query where i get all employee names from Continue reading Join not getting desired result
I’m a database developer with a ton of Microsoft SQL experience, and a tiny bit of Oracle experience. I recently started a new job where I was told I might need to work on a little Sybase stuff, but it Continue reading Experienced with MS SQL, newbie to Sybase
I never design a data base before. Right now i have few Business Process document for an Event Management company. How can i start designing a data base/Data model from these Business Document for this Event Management company? Is there Continue reading New Database Design approach
Hi, I have DB2 database installed on Linux machine with Version 9.7.0 and product DB2 Enterprise Server Edition. I wrote a simple script to gather the tablespace stats. #!/bin/sh date $HOME/sqllib/bin/db2 connect to maxdb71 user XXXXXX using XXxXX>/scripts/db2tablespace.txt sleep 5 Continue reading Unable to connect to database via script using cron jobs
we have 4 normalized tables. user need to see the data hierarchically in a view. so iam considering to use Connect by prior function. any inputs please. Code: product ——– prd_id prod_name 10 Savings customer ———- prd_id cust_id Continue reading Connect by Prior hierarchical view?
My pgdata is on a secondary drive /Data that is failing. The drive been complaining about 1 currently unreadable pending sectors My Backups has been run using a script. I read the article from postgresql.org regarding continuous archiving PITR and Continue reading Help with possible restore postgres
Hello friends, does anyone of you know a possibility, to run a SQL query on a table that shows each attribute at the beginning of a new row? Attribute1#1 Attribute1#2 Attribute#3 Value1 Value2 Value3 Attribute#1 Value1 Attribute#2 Value2 Attribute#3 Value3 Continue reading Specific question about an SQL Statement showing attributes at the beginning @new row
My end game is to automate some of my monthly queries in a Job in SQL Server Agent. Right now I have two metric tables. One table is the name and comment with the PK. The secondary table is attributes/detail, Continue reading SQL Server Agent
hi all, i am new to oracle. By using shell script. i would need to copy one table data to the another table with the same data by overwritten. please let me know how to write by using sql queries.
Dear all, I lost my database on my pc as I format my hard drive. Now could anyone guide me how I can get a copy of my ms sql server database from my hosting to work with my local Continue reading How to restore my sql server database to my pc?