You cannot assign data to a variable and also return data using single select statement, If you are using @TestKey to retrieve value from another table then you can skip variable and use join to get data from another table, try this SELECT * FROM [Live].[Test] WHERE [_fk_RoadMapKey] = @_fk_RoadMapKey SELECT S.* FROM [Live].[SetofTestGrades] S … Read more
One way to do what you want is to modify @voucherNo to be an OUTPUT parameter, and add a new OUTPUT parameter to your query to return the value of SCOPE_IDENTITY(). @voucherNo varchar(max) @ScopeIdentity numeric(38,0) And modify that last SELECT statement to set the value of @ScopeIdentity parameter. SELECT @ScopeIdentity = SCOPE_IDENTITY() Then use SqlCommand.ExecuteNonQuery … Read more
. It’s working fine when I pass 10-15 input but taking more than 5 minutes for 30 input. I need to make it work for 100 inputs solved . It’s working fine when I pass 10-15 input but taking more than 5 minutes for 30 input. I need to make it work for 100 inputs
Something like this might work. I’m not sure on the efficiency yet – it may depend on the amount of hits that you’re looking for: create type HitBlocks as table ( HitIndex int not null ) go create procedure FindMaxCover @Hits HitBlocks readonly as ;With DecomposedBlocks as ( select (HitIndex/8)+1 as ByteIndex,POWER(2,(HitIndex%8)) as BitMask from … Read more
Yes it is largely possible (though there are some caveats and counter examples discussed in the answers here) SELECT * FROM Foo WHERE 1 = CASE WHEN Name IN ( ‘name1’, ‘name2’ ) THEN CASE WHEN Type = 1 THEN CASE WHEN ( Date < ‘2013-01-01’ AND Date > ‘2010-01-01’ ) THEN 1 END END … Read more
IN Sql server 2010,2012 use CONCAT(firstname , ‘ , ‘ , lastname ) 2008 and lower version just use as select firstname + ” + lastname as fullname from users. if you alias name then select fn+ ‘ ‘ + ln as fullname from ( select firstname as fn, lastname as ln, userid from users … Read more
as noted it is a bit vague, but you are also JOINING the tables upside down, as I cannot see the [race ID] being listed in the [runners] table, that would mean you have runners duplicated and the results would not correlate to the runners as there is no relation. I might also be way … Read more
I see from your post edit last time, value from field datetime like ’20/Mar/2013:03:17:44′. Format from value of datetime can’t convert by a simple way. Try this query: SELECT BASESCORE, [DATEDIFF]= Datediff(second, Min(CONVERT(DATETIME, LEFT(Rtrim(Ltrim(DATETIME)), 11) + ‘ ‘ + RIGHT(Rtrim(Ltrim(DATETIME) ), 8))), Max ( CONVERT(DATETIME, LEFT(Rtrim(Ltrim(DATETIME)), 11 ) + ‘ ‘ + RIGHT(Rtrim(Ltrim(DATETIME)), 8)))) FROM … Read more
First, you should know that you are doing a cartesian product of your tables. If you want to add an identity column when you are creating your table, then do the following: Select IDENTITY(INT,1,1) ID, Calls.*,Patient.* INTO Calls2 From Calls,Patient solved Identity Increment [closed]
add an order by clause –at the end of the query order by ChatDate, ChatTime 0 solved Sql Server sorting query result [closed]
How about: SELECT w.adharno, w.phone w_phone, descrip_w, amount_w, a.phone a_phone, decrip_a, amount_a FROM table_w w JOIN table_a a ON a.adharno = w.adharno AND w.descrip_w = a.decrip_a AND (w.phone <> a.phone OR w.amount_w <> a.amount_a) solved Tsql compare two field in the result set
I have a solution to your problem. If you are going to develop for a specific target environment, you have to have a measure of control over the environment, or have contacts with people in your organization who do. It’s that simple. YOU have to make this happen, one way or the other. You should … Read more
Create your table taro: SELECT * INTO taro FROM ( SELECT 1111 AS [C no.], ‘ken’ AS [Name], ‘shiro’ AS Item, ‘3/3/2000 12:22’ AS [Date], ‘$25’ AS Amount UNION ALL SELECT 1111 AS [C no.], ‘ken’ AS Name, ‘aeshte’ AS Item, ‘3/3/2000 12:22’ AS [Date], ‘$25’ AS Amount UNION ALL SELECT 1111 AS [C no.], … Read more
Try this, you are missing “+”s and “‘”s: DECLARE @SQL NVARCHAR(MAX) = N’ SELECT CASE WHEN ISNULL(10, ””) = ”” AND ISNULL(””, ””) = ”” THEN ”” ELSE CONVERT(NVARCHAR(5), 10) + ‘ + ”’ To ”’ + ‘ + CONVERT(NVARCHAR(5), 20) END;’; SELECT @SQL; EXEC(@SQL); 1 solved syntax error while executing sql [closed]
I would write the following case when (case when a.column = 1 then (b.column – c.column) else null end) is not null then 1 else null end as txn_rate_flag as case when a.column = 1 and (b.column – c.column) is not null then 1 else null as txn_rate_flag solved How to apply nested case when … Read more