Viewing 15 posts - 76 through 90 (of 167 total)
January 30, 2017 at 3:41 pm
Also, blabla...
January 30, 2017 at 3:10 pm
Here is my function we are already inserting into temp table inside the function.. this is taking some time to retrieve the results.. to see the actual timings I kept...
January 28, 2017 at 5:57 pm
I am not selecting all columns from emp table
this is a function i am calling here to check the performance to see how it works for 10000 iterations.
select col1,col2,col3 from...
January 28, 2017 at 2:38 pm
SELECT @ret = CASE WHEN MAX(Date) IS NULL January 23, 2017 at 8:23 am
we have a job(ssis package) where it load data from different source and destination is temp table. from temp table I have to move to main table.
selecting rec from temp...
January 4, 2017 at 4:43 pm
Then how I have to create error in the function?
how this function will fail? I am trying to create this eror condition inside the function.And this func is calling from...
January 4, 2017 at 8:10 am
Here we are returning 4 columns as I mentioned only one @NUM.
There is another reason to use table valued function.
Can you please modify the above one where to use THrow?
January 3, 2017 at 2:33 pm
This didn't worked for me - Select * From table where SubString(ID,1,3) <> 'ING"
It still showing all the records that starting with ING
December 27, 2016 at 2:41 pm
What do you mean by agreed?
I cannot keep these substring and stuff in where clause.
I am trying to get all the data from table where ID does not start with...
December 27, 2016 at 2:29 pm
There is no simple statement other than substring?
like select data form table where ID not....?
December 27, 2016 at 2:20 pm
The ID field data will show -
ING20162044285910
ING20162044285976
ING20162044285979
ING20162044285979
ING20162044285973
Now I need data -
20162044285910
20162044285976
20162044285979
20162044285979
20162044285973
How to remove the first 3 characters ING form this field?
select all the records where ID does not...
December 27, 2016 at 2:09 pm
Set based approach? How to do this?
How to parse(split) this 9000430944:7|Information
-> 9000430944 - emp number
-- 7 - stud number
--Information - Description
How to split on pipe? and How to split...
December 27, 2016 at 1:18 pm
In the stored procedure - I need to implement a loop based logic after update statement ..
Now I have to add a logic in this stored procedure
after update statement...
December 27, 2016 at 12:51 pm
I want to exclude one column from select list how to do this?
Column is empname(need to exclude from selct *)
December 16, 2016 at 12:23 pm
Viewing 15 posts - 76 through 90 (of 167 total)