Help with Dynamic Report
Mon, 18 Aug 2008 11:52:05 -0700 (PDT)
I want to execute a report once a week so the day clause would be
"now" and previous 7 days.
I have the query critera working fine; I just can not figure out how
to grab the last 7 days within the query,
I had as a varible that users entered and that works.....I need to
remove that and make it 7 day totals. ...
|
SSIS Import question
Sun, 17 Aug 2008 19:22:45 -0400
Hi All,
Using ms sql 2005 64 bits and Windows Vista Ultimate.
Is that possible to include a form using SSIS. For instant I need to import
a Visual FoxPro table and I have a DOB field like 19800110
While I import I need to break it down to 3 fields as follows:
Year- 1980
Month - 01
Day - 10
and popul ...
|
CREATE TABLE fails ???
Sun, 17 Aug 2008 08:45:23 -0700 (PDT)
Hi,
I'm using SQl Server management studio 2005. i just created a DB
'Test' and want to execute a sql-script in which i create a table.
When I execute the script, SQl Server says command completed
succesfully.
but when refreshing in tables: nothing there
Actually the test-script I execute has been created ...
|
SQL Database on Local or Hosted Web server?
Fri, 15 Aug 2008 19:27:58 -0400
I want to create an application using sql server which would be mostly used
on a local server, however a part of the application requires inputs from
users through the web. I am wondering:
1. Should the database reside on the local or hosted web server? If on the
local server, would this be too slow for web ...
|
restore error re: disk space
Fri, 15 Aug 2008 12:11:50 -0700 (PDT)
Hi,
I'm trying to use last weekend's full backup .bak file from our
production server to restore/refresh the development environment on
another server. On both servers the data files are in:
F:\MSSQL.1\MSSQL\Data
When I try to run the restore I get the following error message:
============================ ...
|
test
Thu, 14 Aug 2008 21:25:13 -0400
...
|
Insertig unique records
Thu, 14 Aug 2008 05:36:03 -0700
Hello everyone
I am using SS2005. I am trying to create a query to insert unique records
from one table to another, but this uniqueness needs to be checked according
to my primary key field only & not by all the fields.
i am trying:
insert into OppTrack1 select distinct * from OppTrack2
but this checks f ...
|
|
|
"In Recovery" mode
Wed, 13 Aug 2008 05:43:11 -0700 (PDT)
We have a fairly large SQL database, about 136 GBs which has been
going "In Recovery" mode everytime the server is restarted or the SQL
Server is restarted. This have been occuring after a hung backup
job. It takes approximately an hour to come back online. My question
is, how can we prevent this? The databa ...
|
DB Design Advice
Tue, 12 Aug 2008 13:54:11 -0600
Greetings,
I'm wondering if anyone could provide some feedback on how best to design a
database I'm working on.
I have any number of Projects, which exist for a specific date range.
Each Project will have zero or more expected deliveries each week of the
project. So I need to track the expected deliveri ...
|
IT Job Guru
Tue, 12 Aug 2008 12:20:50 -0700 (PDT)
Are you looking for a Job in India??? You have experience in Java,
Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a
minute and log on to www.itjobguru.com/forum/index.php. It has all
the
latest Jobs and also the Questions that will be asked in Interviews.
Or are you planning to do a cert ...
|
