|
Thanks for your good idea!
regards,
George
|
|
|
|
|
|
Thanks Hamid,
Good stuff!
regards,
George
|
|
|
|
|
hi iam trying to use the SQL STATMENT LIMIT in Microsoft SQL
however it keeps saying error
is there another syntex that serve the same purpose?
and also is the LIMIT Syntex works only in mysql?
|
|
|
|
|
There is not LIMIT on MS_SQL
this is a MySql syntax code
and this means you can fetch rows between two range of results .
You can do this with TOP and ROW_NUMBER() keywords
for more information search for this keywords on MSDN
Human knowledge belongs to the world
|
|
|
|
|
hi iam trying to make a some wat special sql filter
my database is something like this
700
701
702
801
802
803
so i need to uniquely filter out the data by the First Character only
e.g
7
8
will be the end result
is there a way to do this via sql statement or shld i just select the whole thing and do it programmically
|
|
|
|
|
If the data is in numeric format, first convert it to string like:
CONVERT(varchar(50), YourColumn)
After that you can use SUBSTRING function along with DISTINCT on the string:
SELECT DISTINCT SUBSTRING( CONVERT(varchar(50), YourColumn), 1, 1)
FROM TableName
WHERE CONVERT(varchar(50), YourColumn) LIKE '[78]%'
Edited: Added the WHERE clause if needed. Also note that this could be more efficient with an inline view, depending on the table structures and indices.
modified on Sunday, January 11, 2009 5:29 AM
|
|
|
|
|
|
How can I use MSDataGrid in a WTL/ATL project
without using MFC ?
Is there an example in VC++6.0 ?
Thanks,
Manos.
|
|
|
|
|
Why did you decide to post this question on 5 articles and a forum named General Database?
Since your question is C++ related, I'd suggest you post the question only on C++ forum. I believe you would get much better answers from there. Posting the same question several times across the site is considered rude.
|
|
|
|
|
I know the following statement is incorrect. I had something going wrong in one set of insert statements and it was inserting the entry I wanted it to insert and then inserting a second entry for the next record that contained no data. Now I need to correct both tables, but the only way to know what to correct in the IncomingRecords table is from data in the Completed table. Any help would be greatly appreciated.
UPDATE IncomingRecords
SET Complete = NULL
WHERE (RecordID = (SELECT IncomingRecords.RecordID FROM Completed INNER JOIN
IncomingRecords ON CompletedCRD.RecordID = IncomingRecords.RecordID
WHERE (Completed.A_firm_name = N'') AND (Completed.A_broker_found = N'broker_fround') AND (IncomingRecords.Complete = N'Complete'))
|
|
|
|
|
With a quick look the only problem I see is that your select most likely returns several RecordID's so you mest use IN instead of equal. Like:
...
WHERE (RecordID <code>IN </code>(SELECT IncomingRecords.RecordID ...
Also you seem to miss one closing parenthesis in the end.
Was this the problem you were haviong?
|
|
|
|
|
Thanks fixed my problem and cleared the records from being completed.
|
|
|
|
|
You're welcome 
|
|
|
|
|
I am attempting to install "SQL Server 2008 Express with Advanced Services".
I downloaded this file "SQLEXPRADV_x86_ENU.exe" and consistently get an error in the "System Support Rules" window that indicates that the Windows PowerShell Failed.
It doesn't say how it failed or why it failed - it just failed.
How do I get past this problem?
Thank you
|
|
|
|
|
You must install PowerShell first. This is described in the download page:
InstructionsNote: You must have administrative rights on the computer to install SQL Server Express.
We recommended that you read the Release Notes and Readme before installing SQL Server Express with Advance Services.
Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
Step 2: Download and install Windows Installer 4.5.
Step 3: Download and install Windows PowerShell 1.0. ...
Refer to http://www.microsoft.com/downloads/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en[^]
|
|
|
|
|
Step 1 : I've done it.
Step 2 : I've done it.
Step 3 : I must do it 
|
|
|
|
|
It'll help
|
|
|
|
|
Oh no, Windows PowerShell 1.0 English-Language Installation Package for Windows XP (KB926139) needs Validation 
|
|
|
|
|
Did the Sql Server installation give you that error? Also did you go through all the links provided in download details page:
Note: For help on installing Windows Powershell 1.0 see the following KB articles:
926139: English PowerShell 1.0 for Windows
926140: Localized PowerShell 1.0 for Windows XP and Windows 2003
926141: Multilanguage User Interface for PowerShell 1.0 for Windows XP and Windows 2003
928439: PowerShell 1.0 for Vista (includes all languages)
|
|
|
|
|
hey can somebody suggest me any good sites with databases tutorials. i don't know anything about them. I don't know how they work, and what are tables, primary keys, tuples etc.
so i want to know about how databases work before getting into any sort of ms sql, mysql, oracle etc...
if you can recommend any book i'll appreciate it. by the way i'll be using ms sql server 2005 express edition, if that helps suggesting
ty
|
|
|
|
|
|
SQL Course Here[^]
And Here[^]
And, just for your info, some free cheat sheets Here[^].
modified 1-Aug-19 21:02pm.
|
|
|
|
|
didn't you read my post? i asked of databases tutorials not sql, although it doesn't matters if they are also teaching what are databases besides sql
|
|
|
|
|
Instead of complaining about the sources I gave, why on earth didn't you just do a google search. It really isn't that hard unless nobody has taken the trouble to teach you how to "Google" 
To save you the trouble of finding somebody to teach you how to Google, just click this link and Google will return a list of web sites for you to investigate. "Database Tutorials"[^]
Relational Database Theory was listed on the second reference I gave. Perhaps it is you who should learn to read
modified 1-Aug-19 21:02pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
