Viewing 15 posts - 76 through 90 (of 5,502 total)
What do you mean by Even a simple delete from tablex where id ... will not execute.?
Is there any error message?
August 23, 2014 at 3:15 pm
You need to apply the cast to varchar inside the dynamic SQL. Otherwise you're only converting the dynaic statement, not the result.
declare @result varchar(max)
set @result = ('select cast((select * from...
August 23, 2014 at 2:13 pm
What do you mean by "It is not casting to varchar"?
Do you get any error message?
Can you provide a test scenario so we can reproduce the result you're getting?
August 23, 2014 at 1:54 pm
Are you looking for something along those lines?
WITH cte as
(
SELECT DISTINCT cvid FROM [x_ApplyJob] a
WHERE EXISTS (SELECT 1 FROM [z_JobChecking] c WHERE c.JobCheckingID = a.JobNoticeID)
)
UPDATE cv
SET score...
August 23, 2014 at 1:16 pm
What about the table you mention in your first post? I thought that was the table being updated?
Looks to me like you are changing your requirements and I still don't...
August 23, 2014 at 12:56 pm
Unfortunately, you didn't answer my question:
Why would idx=34 get a score of 10?
It would be a lot easier if the data where in normalized form instead of a separated list....
August 23, 2014 at 9:41 am
Please provide ready to use sample data including your expected result as described in the first link in my signature.
If possible, in your price table separate the number of days...
August 23, 2014 at 9:30 am
What are you trying to do?
Your description is rather vague...
For instance, what do you mean by
Where idx=34, Numeric in ApplyJob (3) EXIST in r_ApplyJob --> SET score=10
??
For that idx value...
August 23, 2014 at 9:22 am
Sean Lange (8/19/2014)
August 19, 2014 at 12:18 pm
Alvin Ramard (8/19/2014)
...Hang on here! You guys get more than pizza under the door twice a day?????? 😛
How do you recognize a "day"? You don't have any kind...
August 19, 2014 at 11:44 am
That doesn't sound like a normalized table structure...
An normalized table would look more like this:
CREATE TABLE meaningfulName
(RowId INT IDENTITY(1,1),
MyReader varchar(50),
MyReaderPos INT ,
CONSTRAINT CX_meaningfulName PRIMARY KEY...
August 16, 2014 at 12:36 pm
You could create a stored procedure with EXECUTE AS using a user having the same login as it is assigned to the proxy being allowed to run the SQL agent...
August 16, 2014 at 2:54 am
I don't understand the need for the double loop. It should be enough to either provide the table description (including columns) or the CREATE TABLE statement (including permissions and growth...
August 14, 2014 at 3:28 pm
IF EXISTS (SELECT 1 FROM legalcontracts WHERE con_ContractNumber= @con_ContractNumber)
PRINT '1'; --If there is a record match in the Database - Not Available
ELSE
PRINT '0'; --No Record Found - con_ContractNumber is...
August 14, 2014 at 1:34 pm
The "hint" might not have put you in the right direction.
So here's a straight advice: please read and follow the instructions provided in the first link in my signature.
Ready to...
August 14, 2014 at 12:10 pm
Viewing 15 posts - 76 through 90 (of 5,502 total)