Use below query like in your code also can you please post the error code so that it can be easier to understand what is the cause of that error : Declare @DB...
4841
Noman Aftab
noman17pk
Oct 12, 2012 4:43 pm
Unless there is any column which is not defined, the query appears to be perfectly fine. Share the error details.  Best Wishes, Noman Aftab  ...
4842
Arnie Rowland
arnie1568
Oct 12, 2012 4:48 pm
" I think I am missing something and I am worried that it is not going to match the data properly." ALWAYS write your query as a SELECT first, verify that it...
4843
Rob Richardson
rdrichardson@...
Oct 13, 2012 11:03 pm
Unless the original poster is using PostgreSQL, the update query is not perfectly fine. According to the PostgreSQL documentation: "This command conforms to...
4844
Rob Richardson
rdrichardson@...
Oct 13, 2012 11:04 pm
The original poster's update query is not perfectly fine. There are database systems (PostgreSQL is one of them, and the system I am familiar with) that allow...
4845
T p
tomas_no2@...
Oct 14, 2012 6:46 pm
dont understandif u want to update A fieldUpdate BD SET BD.F1 = BD.F1 + OD.F1 why do you write + sign? is it a varchar/int or what - otherwise u might have to...
4846
Ronda K
rondakay
Oct 24, 2012 8:09 pm
Cross Posting Can someone help ... I have a product style table (the actual query joins to about 4 different tables but I am going to try to simplify it here: ...
4847
Farhan Ahmed
farhan_4_love_u
Oct 24, 2012 10:54 pm
In SQL Server there is keyword “except” which is similar to you defined in DB2. I have not used DB2 so that’s why I don’t know how Exclusion work and...
4848
Paul Livengood
p_livengood
Oct 25, 2012 12:55 am
Ronda; If I understand your requirements you want to list all items in Styles Table where ProductStyle Column is not in the SecondaryStyle Column of the...
4849
Ronda K
rondakay
Oct 25, 2012 3:31 am
Paul, Thanks for your response. I did end up using a where not in statement, was just curious if there was an SQL equivalent to the DB2 (as400) exception or ...
4850
Arnie Rowland
arnie1568
Oct 25, 2012 3:40 am
EXCEPT Regards, Arnie Rowland | Westwood Consulting, LLC | +1-503-246-6172 "You cannot do a kindness too soon because you never know how soon it will be too...
4851
J P
pulverizers73
Jan 6, 2013 8:07 pm
http://demo.abesayara.com/wp-content/plugins/zeixboofmuo/ndold.php?kvms=kvms [Non-text portions of this message have been removed]...
Hello, I am trying to get the same results in SQL server with a query as it works in access There are two tables: TITLES Fields in query: TITLES.TitleID,...
4854
MBDEV - DB
databaselists@...
Mar 13, 2013 6:15 am
It does use another query; I found it and listed it below. I am trying to figure out how to get the same results with one SQL query. I have never worked on a...
4855
John Warner
john@...
Mar 13, 2013 8:05 am
How many groups are you cross posting this to? Which group do you prefer we answer in? John Warner ... From: SQLQueriesNoCode@yahoogroups.com ...
4856
Charles Carroll
charlesmarkc...
Mar 13, 2013 10:07 am
Because the groups have different audiences ideally the solution will be posted to both by Mike once he gets an answer. This group is the best home for Query...
4857
MBDEV - DB
databaselists@...
Mar 13, 2013 10:59 am
Okay, Ended up with this to try to get rid of the error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common...
4858
MBDEV - DB
databaselists@...
Mar 13, 2013 4:19 pm
Hi, I have a stored procedure that updates tables in multiple databases. It used to run in minutes and now the client says it is taking 40 minutes to complete....
4859
T p
tomas_no2@...
Mar 13, 2013 4:46 pm
I would try to print getdate() on each of my "checkpoints" print getdate() update table x print getdate() if you cannot run the sp manually (to see the print)...
4860
Charles Carroll
charlesmarkc...
Mar 13, 2013 5:33 pm
Basically show us the SP. Inserts are slow depending on whether you are "over indexed" or have clustered indexes and on which field. I use a stored prodecure...
4861
MBDEV - DB
databaselists@...
Mar 22, 2013 12:13 am
I am not sure how to format the last part of this query which comes from Access.: SELECT Max(TITLOC.TitleLocID) AS MaxOfTitleLocID, TITLES.TitleID, ...
4862
Mark E
meckeard2000
Mar 22, 2013 12:47 am
Change date() to getdate() Also, look up the datediff function as that may be a better way to do it. Mark ________________________________ From: MBDEV - DB...
4863
MBDEV - DB
databaselists@...
Mar 22, 2013 8:06 pm
Hi Guys, If you look at the Having statement in the query below it has: HAVING (dbo.TITLES.Check1 = - 1) <- notice the space between - sign and 1. I have tried...
4864
MBDEV - DB
databaselists@...
Mar 22, 2013 8:08 pm
Hi, I ended up with this: SELECT MAX(dbo.TITLOC.TitleLocID) AS MaxOfTitleLocID, dbo.TITLES.TitleID, dbo.TITLES.CustLName, dbo.TITLES.CustFName,...
4865
Mark E
meckeard2000
Mar 22, 2013 9:41 pm
Boolean values in SQL server are 0 for false and 1 for true. You can convert your values to match and then convert the field to the data type of boolean. ...
4866
Surya A. Saputra
ym_saputra
Apr 17, 2013 1:51 pm
Dear all, Could anyone explain to me what is the different condition after join statement or after Where statement, sample : ParentID 1 2 3 4 ChildID -...
4867
zhangzsdreamy
yhdreamy
Apr 18, 2013 1:14 am
Hi allI am using tool SQLlocalDB.exe with SQL 2012 Server Express in Win7. I want to get the returned information after run "SQLlocalDB info 'mydbinstance'...
4868
Charles Carroll
charlesmarkc...
May 15, 2013 4:05 pm
http://technet.microsoft.com/en-us/library/bb677173.aspx We are about to use these on a project and I know sometimes MS releases a feature that sounds...
4869
Paul Livengood
p_livengood
May 15, 2013 11:38 pm
I have used this in 1 project I did. I didn't need to, but I wanted to see how it worked. I did not notice any major issues with it, but external...
