|
You are trying to get value with subquery which return more then one row and that is why you get error,but to solve this try to use TOP 1 or post your query to see where is problem.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Unfortunately I was not able to post my query without failing to submit a new thread/post, not sure why. That's why I've post my query in another forum and I've put a link in the first post. Could you please help me out? Thanks!!
|
|
|
|
|
Can anyone please help me? I still can't figure out how to write this....
|
|
|
|
|
Hi
I have problem re-installing SQL 2008 Express. The problem I am getting is even though I can double click on the icon, but when I check the install, I see that there is an error message on the register keys. The error message says that a "prior installations register keys cannot be modified, please check installation to fix error". Unfortunately, I cannot find on MSDN's website on where to find the appropriate fix. Yes, I did have a prior installation, but I removed it Add and Remove Programs, thinking this would give me a clean removal in order to fix another problem.
Can anyone, please advise me on this problem in order that I may install SQL 2008 Express?
Thanks
|
|
|
|
|
I ran into the problem trying to install it the first time; apparently it didn't like having a preious version on the machine (2005). I tried several times a week for a few months to solve it, but never found a solution. After removing the 2005 version, it started whining about corrupted performance counters. And though there is a link to a manual (and extremely tedious) method of cleaning this up for the 2005 version, no such article existed at the time that had a procedure that works for the 2008 version. Hopefully that has been corrected by now, but I doubt it.
I eventually gave up trying, installed it on my server instead, and with help from several kind CPians managed to make the server installation visible to the client.
Another problem that doesn't sound like it applies to this situation exactly, but may bite you later, is that a number of users have found it impossible to install SS 2008 after installing Visual Studio. The reported fix for that was to install the SQL Server first, then install Visual Studio.
If you do find a solution, please write up a procedure and publish it as an article. I'm sure a lot of CP members will find it useful!
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Hi
I have a solution - if you download Windows Installer Clean Up Utility run it this will remove all of the rubbish that SQL puts in.
I did this and ran SQL Express Installer for 2008 and it works.
The solution I found on MSDN forum for 2005 and found it works for 2008.
|
|
|
|
|
Thanks! I found it using Google and grabbed a copy. 
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Hi.
I have been working on GIS projects from early 90's.
I have a very big archive of GIS data like photos,ESRI shape files etc.In this moments all this data is organized in folders that keep the name of the project.Our company needs an archive to keep all this data organized in some way they can be searched or used easily.From your experience which is the best way to manage this large amount of information?I repeat that this data are of different formats.
Best regards
|
|
|
|
|
When you talk about searching do you mean to search into the files (such as searching keywords in some of the files)? If so, you need to first create a keyword file for each GIS project. Then use Windows Desktop Search or Google Desktop to index the files. The GIS projects will still be stored in their original folder structures so they can be used easily.
You can also create your own database tables and save the keywords and projects' locations into the database. You may need to develop a certain interface to query the database and launch GIS projects from it.
|
|
|
|
|
I mean not to search by projects but developing a regular archive where u can search the same as you do when u enter at Google maps or maybe by some other criteria I don't know.
I know that my question is some-kind very general but I need some opinions.
Best regards
|
|
|
|
|
I use ArcInfo at work, and I know the nightmare you're talking about. We intially paid a consulting company to map our electrical utility system and provide us with a geodatabase and supporting shapefiles. Since then the tribe has created a GIS office to provide mapping services, and they've been very helpful by providing files to add to our system. But finding those files and organizing them in some logical fashion that makes it easy to locate specific feature sets is a hellish task.
Re-organizing them is out of the question; if I move a file it will break every map ever created that depends on it. There is no tool I know of that will automatically revise .mxd files with new locations for the files that move. The file names that the GIS group uses don't in any way indicate what the files may contain, so a simple search isn't very helpful.
I like the idea of creating an index that can be searched; the keys have to be meaningful, though, and should be accompanied by a detailed description. The keys should not be arranged by project. They have to include keywords that a user would select to describe a particular feature set - "power poles in Section 10" for instance.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Dear all,
I have issue when i creat folder/condition with other foldername with space.
In code bellow is i create foldername that with space
Declare @ComMkDir varchar(100) (eg. C:\ComName\Test Folder
Set @ComMkDir = 'mkDir ' + @ComComp
EXEC master.dbo.xp_cmdshell @ComMkDir
After create is just create "Test" folder.
Thanks for your help...
VB.Net
|
|
|
|
|
This gets the result you want, change to suit:
DECLARE @ComMkDir varchar(100)
DECLARE @mkDir varchar(50) = 'C:\ComName\Test'
DECLARE @ComComp varchar(50) = 'Folder'
SET @ComMkDir = @mkDir + ' ' + @ComComp
Print @ComMkDir
RESULT:
---------------------
C:\ComName\Test Folder
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
modified on Friday, December 25, 2009 9:46 PM
|
|
|
|
|
ohh maybe you don't undestand what i posted.
I want to create folder not just print.
you can test it. It is not acept with space.
VB.Net
|
|
|
|
|
Put double quotes around the directory and file name.
Eg: "c:\Temp Folder\Temporary File.txt"
Tim
|
|
|
|
|
Thanks you so much it work well...
VB.Net
|
|
|
|
|
I'm facing the following error:
Output SqlScript: EXEC master.dbo.xp_cmdshell 'mkDir "C:\ComName\Test\Test Folder 1"' -- It works fine
But when I try like EXEC @SqlScript ,it raise the following error.
Msg 203, Level 16, State 2, Procedure spCreateF0lder, Line 19
The name 'EXEC master.dbo.xp_cmdshell 'mkDir "C:\ComName\Test\Test Folder 1"'' is not a valid identifier.
Thanks
Md. Marufuzzaman
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
Try the following hope that may helped you...
--EXEC spCreateF0lder 'C:\ComName\Test\' ,'Test Folder 1'
CREATE PROCEDURE spCreateF0lder
@DefaultPath varchar(MAX)
,@FolderName VARCHAR(100)
AS
BEGIN
DECLARE @SqlScript VARCHAR (MAX)
SET @SqlScript = 'EXEC master.dbo.xp_cmdshell ''' + ' mkDir ' + @DefaultPath + @FolderName + ''''
EXEC @SqlScript
Print @SqlScript
END
GO
Thanks
Md. Marufuzzaman
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
modified on Saturday, December 26, 2009 8:35 AM
|
|
|
|
|
Hi:
How can I restore data from the transaction log file in SQL Server 2005?
Please help..
|
|
|
|
|
Asuuming your backup is something like this, and you have the Database Recovery Method set to FULL::
BACKUP DATABASE TestDB
TO DISK = 'e:\backups\TestDB.bak',
WITH
FORMAT,
MEDIANAME = 'TestDB_MediaSet1'
BACKUP LOG TestDB
TO DISK = 'e:\backups\TestDB_log.bak'
WITH
FORMAT,
MEDIANAME = 'TestDB_MediaSet1'
You can restore with something like:
USE master
GO
RESTORE DATABASE TestDB
FROM DISK = 'e:\backups\TestDB.bak'
WITH REPLACE
Check these links:
Backups[^]
Transaction Log Backups[^]
Full Database Restore[^]
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Hai All,
I am doing following search in SQL Server2005,
select * from table_1 where contains (text1,'"roll-over"')
Results:
1 roll
2 notify us theday you roll check .
3 notify us the day you check roll-over.
4 notify us the day you check roll over.
Could Some one tell me , is this results are right for this search?, i feel its wrong it should only return the line which is having roll-over ( 3 notify us the day you check roll-over.)
how can i use this query or modified this querey to get proper results?
thanks
Mahe
|
|
|
|
|
You can try this search:
select * from table_1 where columnname like '%roll-over%'
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
hvgyufg28fh38tyr78hf wrote: Could Some one tell me , is this results are right for this search?
I'm not sure, but the documentation says that punctuation is ignored;
Punctuation is ignored. I guess that you're searching for two separate terms in your query. Look through your resultset; there's 4 results that got either term.
The source for this answer is here[^], under the heading "simple_term".
Merry Christmas 
|
|
|
|
|
First off, I inherited this database and its database structure, Second I am mainly a C# programmer and my database query skills are lacking and could use improvement I know that. I have avoided this bugger for a too long so now I ask the community for help.
I'll break this down to 3 parts, 1: What my DB looks like (the important stuff), 2. What I want to accomplish, 3: Where I am at.
1: Tables & relations (I can supply you with a create script and sample data, only needed fields are seen)
TABLE:CustomerAccountPayment
ID, PK, int
CusotmerID, FK, int
EntryDate, DateTimeAmount, numeric(18,2)
Void, bit
FloatingAmount, numeric(18,2) (Positive Only, means they overpaid for some reason)
Amount = sum(CustomerAcountPaymentDetail.Amount)
Total = Amount + FloatingAmount
TABLE:CustomerAccountPaymentDetail
ID, PK, int
CustomerAccountPaymentID, FK, int (CusotmerAccountPayment.ID)
InvoicePaymentID, FK, int (InvoicePayment.ID)
Amount, numeric(18,2)
IsFloat, bit (Is true when the paymentdetail is covered under the customeraccountpayment.FloatingAmount)
TABLE:InvoicePayment
ID, PK, int
InvoiceID, FK, int
PaymentMethodID, FK, int (PaymentMethod.ID)
Amount, numeric(18,2)
DateCreated, datetime
TABLE: PaymentMethod
ID, PK, int
Name, nvarchar(50)
IsCredit, bit (Identifies it is a credit charge type to account when set to 'true')
2: What i need
I have been developing a report that is a Customer account balance sheet, it shows thier current customer account balance (sum(InvoicePayment.Amount) - sum(CustomerAcocuntPayment.Total) - and what they have paid (CustomerAccountPayment) for a date range, and the age of outstanding the charges (InvoicePayments).
I need to retreive thier balance before the StartDate.
I need to retreive What they have charged and paid between the start and enddate.
I need to retreive the remainder, after EndDate.
This is all for a particular customer and the PaymentMethod.IsCredit = true. That being true means it was charged to their "Account".
3:What i got.
To determine thier current balance i do these 2 queries.
TotalCharged - TotalPaid.
TotalCharged
SELECT SUM(InvoicePayment.Amount) AS TotalCharged
FROM InvoicePayment INNER JOIN
PaymentMethod ON InvoicePayment.PaymentMethodID = PaymentMethod.ID INNER JOIN
Invoice ON InvoicePayment.InvoiceID = Invoice.ID
WHERE (PaymentMethod.IsCredit = 1)
AND (Invoice.Void = 0)
AND (Invoice.CustomerID = @CustomerID)
TotalPaid
SELECT (sum(CustomerAccountPayment.Amount) + Sum(FloatingAmount)) as TotalPaid
FROM CustomerAccountPayment
WHERE CustomerID = @CustomerID
AND Void = 0
Now the problem is that I need to make a customer sheet for October 2009. StartDate = 20091001, EndDate = 20091031.
How do I exclude InvoicePayments (these are really charges on invocies..bad name) that are covered under a customer payment made after October 2009 but include the invoice charges for october only? Meaning there is a relation between a invoicepayment and a customerpayment made in november (there could even be a voided one CustomerAccountPayment.Void = 'True')
How do I get the balance previous to October 2009?
I just can't seem to get the proper results with all my test queries (Which are numerous..) I am hoping to get a new start point for these queries from the community... I think i am missing a technique i am jsut not aware of.
Thanks,
Jordon.
|
|
|
|
|
here if you need the data between start date and end date then just pass the 2 dates (start and end).
for example in your case 20091001 to 20091031.
if you wish the data for current month
then using getdate() fucntion get the current month and date and treat as startdate and end enddate.
for example SELECT DATEPART(d,getdate())
SELECT DATEPART(m,getdate())
you will get the current month and date.
treat as your start date and end date.
in your query then
put the logic just like
SELECT SUM(InvoicePayment.Amount) AS TotalCharged
FROM InvoicePayment INNER JOIN
PaymentMethod ON InvoicePayment.PaymentMethodID = PaymentMethod.ID INNER JOIN
Invoice ON InvoicePayment.InvoiceID = Invoice.ID
WHERE (PaymentMethod.IsCredit = 1)
AND (Invoice.Void = 0)
AND (Invoice.CustomerID = @CustomerID) and DateCreated beetween @Startdate and @Enddate
hope this is fine for you.
Regards
Keyur Satyadev
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
