|
sallam 2 all this is a search query bt i got an exception at column S_No
i.e
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No', Provider_Cpt_Plan_Detail_Id, Provider_Cpt_Plan_Id, pcpd.Cpt_Code, isnull(pc.Proc_Description,'') as cpt_description, pcpd.Cpt_Modifier, Non_Facility_Participating_Fee, Non_Facility_Non_Participating_Fee, Facility_Participating_Fee, Facility_Non_Participating_Fee, pcpd.Deleted, pcpd.Created_By, pcpd.Created_Date, pcpd.Modified_By, pcpd.Modified_Date From Provider_Cpt_Plan_Details pcpd left outer join procedures pc on pcpd.Cpt_Code=pc.proc_code Where ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%' And pcpd.Cpt_Code LIKE '00%' And pcpd.Provider_Cpt_Plan_Id ='100ALLALLALLALLALL' And pcpd.Deleted ='0'
the prob is that i use
Select ROW_NUMBER() OVER(ORDER BY pcpd.Cpt_Code, pcpd.Cpt_Description ASC) AS 'S_No' in select statement im confused what i give in search where clause if i give S_No it gives me error if i give the whole ROW_NUMBER...etc etc it says it is used only in select statement
now it gives me exception Incorrect syntax near the keyword 'ORDER'.
when i used ORDER BY( pcpd.Cpt_Code, pcpd.Cpt_Description ASC) LIKE '4%'
any suggestions what i should do?
|
|
|
|
|
hi
i get the following error when try to install an instance of the SQL Server 2008 failover cluster:
Rule "Cluster shared disk available check" failed.
The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available.
the machine in which it's installed is a VM provided by ESXi.
what's the problem and what can i do?
thx
|
|
|
|
|
For a cluster, you'll need at least 2 VM's. (preferably on two different boxes, putting them both on one box is nice for playing around, but it brings you nothing than more points of failure in a production environment).
Next you will need to configure a shared disk, accessible by both machines. This is usually based on some hardware contraption, such as a NAS, or a firewire setup. You may also be able to SIMULATE this in VMWare ESXi, consult the product's documentation.
|
|
|
|
|
I have select query like this :
SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] , AdCampaign.Status FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)
I need like the previous query for update.
How I can do it with Join.
|
|
|
|
|
hi..
How I can Pass session parameters to sqlDataSource. I do like this but it is not work:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>"
SelectCommand="SELECT CampaignName, AdType AS [Campaign Type], Status, Date AS [Start Date], Clicks, Impr, DailyBudget AS [Daily budget] FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE Account.EmailAddress = @EmailAddress ">
<SelectParameters>
<asp:SessionParameter Name="EmailAddress" Type="String" SessionField="EmailAddress" />
</SelectParameters>
</asp:SqlDataSource>
The session name is :session["EmailAddress"]
Please guide me.
|
|
|
|
|
Add the risk of sounding repetitious and single-minded: And what is the error message? There are no psychics here.
|
|
|
|
|
I have this query. but it is not work with the session
Please help me.
SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Status, AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = 'Session["Email_Address"]') AND (Account.Pass = 'Session["Password"]')
|
|
|
|
|
And what is the error message?
|
|
|
|
|
We have a group of users who can access various locations within the datacenter.
For the largest group of users, if they can access one location they can access all of the locations.
For a very small population, the user can only access the office and not the data center locations. These users are causing me a problem.
The query is aimed at basically giving me the count of active locations. But in the mixed case I get BOTH a record with a null count AND a record with access count. In otherwords: Amy can access only the office and cannot access dc1 or dc2. The query returns Amy's record as Amy, null and Amy, 1. I want it to return ONLY Amy, 1.
Any suggestions on the changes I need to accomplish that?
Here is the current query:
SELECT dbo.ContactMaster.BmcCustKey,
(SELECT COUNT(dbo.LocationAccessGrant.CanAccessLocation)
WHERE (dbo.LocationAccessGrant.CanAccessLocation = 1)) AS AccessCount
FROM dbo.ContactMaster LEFT OUTER JOIN
dbo.LocationAccessGrant ON dbo.ContactMaster.CompanyID = dbo.LocationAccessGrant.CompanyID AND
dbo.ContactMaster.ContactIdentity = dbo.LocationAccessGrant.ContactIdentity
GROUP BY dbo.ContactMaster.BmcCustKey, dbo.LocationAccessGrant.CanAccessLocation
ORDER BY dbo.ContactMaster.BmcCustKey
|
|
|
|
|
Not sure I've understood you properly, but your subquery doesn't look correct.
So try something like this:
SELECT dbo.ContactMaster.BmcCustKey
,Sum(CASE WHEN dbo.LocationAccessGrant.CanAccessLocation = 1
THEN 1
ELSE 0
END) accesscount
FROM dbo.ContactMaster
LEFT OUTER JOIN dbo.LocationAccessGrant
ON dbo.ContactMaster.CompanyID = dbo.LocationAccessGrant.CompanyID
AND dbo.ContactMaster.ContactIdentity = dbo.LocationAccessGrant.ContactIdentity
GROUP BY dbo.ContactMaster.BmcCustKey
,dbo.LocationAccessGrant.CanAccessLocation
ORDER BY dbo.ContactMaster.BmcCustKeyIt should take care of your null values
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Hi,
How many concurrent we can have in SQL Server 2005 Express?
Does it make difference with the operating system like windows server 2003/2008 or winxp pro?
And I am getting error while connecting to the sql server 2005 express that the remote server has refused the remote connection (Error no. 26) though it was working fine before couple of days (I have enabled the remote connection via/pipeline/tcpip and also added in firewall exception port 1433. It was working fine before).
After that I have just restarted my server and its works fine! What can be wrong in this? May be the number of concurrent connection has reached!
Thanks,
Divyesh
|
|
|
|
|
I don't see a connection limitation in SQL server express, but there are indeed tcp connection limitations in windows XP. (Microsoft wants you to buy the server if you're doing server work).
|
|
|
|
|
This[^] fixes that little problem.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
No, not really. This was introduced to limit the number of half-open connections (typically session in the SYN_WAIT state). A number of worms were rampant at that time, and they opened oodles of connections to systems simultaneously. P2P systems typically do likewise, so this patch was developed to allow P2P to run. I doubt that this is the OP's problem.
I was thinking more in the line of this[^], but MS seems to imply that they don't enforce the inbound connection limit, except for SMB operations. So if the SQL server is connecting though named pipes, yes it would be a problem, but normal TCP connections should be okay.
|
|
|
|
|
hi,
I was trying to update the Cyrillic characters · Serbian characters in sql server database, but everytime i shows ??? after updation
Please suggest something.
Thanks
|
|
|
|
|
Do you use VARCHAR or NVARCHAR? Only NVARCHAR will do!
|
|
|
|
|
Thanks for replying...
If I have to search for keyword abcurlф in the table
what should be the query in this case?
Presently it is not displaying any result if i search even only with ф
and displays those records which have ? character
|
|
|
|
|
In the Employees table of Northwind database, I changed the FirstName of an entry to "abcurlф". Now I do in SQL Enterprise Manager:
SELECT *
FROM Employees
WHERE (FirstName LIKE N'%ф%')
and that returns exactly the row where I made that change.
Note that an "N" is required before the search term - LIKE '%ф%' does not work.
|
|
|
|
|
I have a database with a master - detail relationshio between two tables. The database is basically a snapshot in time for each office. so imagine that my master table is:
id (auto increment), date, office_id
1 , 2010-4-1, 100
2 , 2010-4-2, 100
3 , 2010-4-3, 100
4 , 2010-4-4, 100
5 , 2010-4-1, 101
6 , 2010-4-2, 101
7 , 2010-4-3, 101
8 , 2010-4-4, 101
I want to get the id number for the last update date from the master table so I did the following:
SELECT id, max(upload_date) as upload_date, office_id from master group by office_id
What I want is the id number associated with the latest date, so I WANT
id, date, office
4, 2010-4-4,100
8, 2010-4-4,101
What I get is:
1, 2010-4-4,100
5, 2010-4-4,101
I get the max date, but the first id number. Normally I'd do a cursor in a procecure to get it, but the ISP has to grant the pivs each time the sp is modified so I am trying to do this in a simple query since it is called from php.
As a work around, I am doing a max(id) as well since I figured that the highest id would always be associated with the latest date, but I don't want to make that assumption.
Does anyone know how to build the query correctly to get the id associated with the latest date?
|
|
|
|
|
I'm not sure, I think you need to add some sorting, try "ORDER BY date DESC" on top of your grouping.
|
|
|
|
|
I'm little bit confused; are we trying to get the current inserted / updated data using the dateTime criteria? 
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
No, I was suggesting to get things sorted within each group, but MySQL isn't accepting a "ORDER BY ... GROUP BY ..." qualification.
|
|
|
|
|
Yep, I got your point.
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
You can try SQL SCOPE_IDENTITY function to get the last identity value inserted into an identity column in the same scope. Or you can also try in a trigger which something like:
DECLARE @id int = 0
SET @id = (SELECT id FROM INSERTED )
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
I wasn't sure what MySQL supports so I kept out of it!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
