Click here to Skip to main content
15,118,323 members

Comments by prakash.chakrala (Top 41 by date)

prakash.chakrala 28-Jan-15 1:17am View
   
Deleted
SPId NName Oprt Nr Type Inner SPId
1 ab 10
1 ab * 0
1 ab + 10 DataElement
1 ab + 10 Mc
1 ab + 10 Metric
prakash.chakrala 18-Dec-13 3:58am View
   
create table #table1(id int,name varchar(20))
create table #table2(sno int,id int,name varchar(20))
create table #table3(number varchar(20),name varchar(20),sno int)


table1.id is related to table2.id
table2.sno is related to table3.sno
prakash.chakrala 12-Nov-13 8:24am View
   
bulk only
prakash.chakrala 12-Nov-13 6:01am View
   
iam getting following collation:SQL_Latin1_General_CP1_CI_AS
may i know which collation you are getting.
prakash.chakrala 12-Nov-13 5:50am View
   
am getting the output like
15 Global
3 Abraham Lincoln
2 Cornell
1 James Monroe
16 Liberty
6 George Washington
5 Roosevelt
4 James K. Polk
17 Noble
9 John Adams
8 Andrew Jackson
7 Woodrow Wilson
prakash.chakrala 12-Nov-13 5:40am View
   
not getting the output as expected
prakash.chakrala 12-Nov-13 5:25am View
   
i need to sort the data based on name
prakash.chakrala 26-Sep-13 5:41am View
   
where ever spaces between words in a string i have to replace with " "(double quote with space)
prakash.chakrala 16-Sep-13 10:28am View
   
In name column i have the data like south america(and mentioned above) so my requirement is to
get output as south(and mentioned above)
prakash.chakrala 17-Jul-13 2:36am View
   
hi thank you for your reply I want to use new iif function in sql server 2012 but not case statement.
Thank you
prakash.chakrala 10-Jul-13 2:25am View
   
Hi now am getting following error

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
prakash.chakrala 9-Jul-13 5:48am View
   
Hi after adding reference am getting another error saying that "OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode."
prakash.chakrala 27-Jun-13 3:01am View
   
Hi MaulikDusara
sorry to say your solution is not correct for my question
prakash.chakrala 27-Jun-13 2:59am View
   
Hi Maciej Los

Thank your for helping
prakash.chakrala 27-Jun-13 2:59am View
   
Hi Aarti Meswania
Thank you for helping
prakash.chakrala 26-Jun-13 12:40pm View
   
Hi Arun

for example mohammed.shareef for june 3rd I got 2 records, so if I get like that I have to take only one record and that record having with holidayname.



mohammed.shareef 6/3/2013
mohammed.shareef 6/3/2013 Holiday

from these records I have to get only
mohammed.shareef 6/3/2013 Holiday
this record

eg
prakash.chakrala 22-Jun-13 7:00am View
   
Hi Mike Meinz

Actually I have the data like this

EmpId projectid projectname DateValue EnterDate Noofworkinghours HolidayName
balakrishnan.naveen 67 Other 5/1/2013 5/1/2013 2
balakrishnan.naveen 74 Meeting 5/1/2013 5/1/2013 3.5
balakrishnan.naveen 41 bbb 5/1/2013 5/1/2013 1.5
balakrishnan.naveen 74 Meeting 5/2/2013 5/2/2013 2
balakrishnan.naveen 67 Other 5/2/2013 5/2/2013 2
balakrishnan.naveen NULL NULL 5/3/2013 NULL 0
balakrishnan.naveen NULL NULL 5/4/2013 NULL 0 Weekend
balakrishnan.naveen NULL NULL 5/5/2013 NULL 0 Weekend
balakrishnan.naveen 67 Other 5/6/2013 5/6/2013 2
balakrishnan.naveen 67 Other 5/7/2013 5/7/2013 1.5
balakrishnan.naveen 67 Other 5/8/2013 5/8/2013 2
balakrishnan.naveen 74 Meeting 5/8/2013 5/8/2013 3
balakrishnan.naveen 74 Meeting 5/9/2013 5/9/2013 1
balakrishnan.naveen 67 Other 5/9/2013 5/9/2013 6.5
balakrishnan.naveen 41 bbb 5/9/2013 5/9/2013 1
balakrishnan.naveen 67 Other 5/10/2013 5/10/2013 6
balakrishnan.naveen 74 Meeting 5/10/2013 5/10/2013 1
balakrishnan.naveen NULL NULL 5/11/2013 NULL 0 Weekend
balakrishnan.naveen NULL NULL 5/12/2013 NULL 0 Weekend
balakrishnan.naveen 74 Meeting 5/13/2013 5/13/2013 1
balakrishnan.naveen 67 Other 5/13/2013 5/13/2013 7
balakrishnan.naveen 67 Other 5/14/2013 5/14/2013 4
balakrishnan.naveen 74 Meeting 5/14/2013 5/14/2013 2
balakrishnan.naveen 74 Meeting 5/15/2013 5/15/2013 6
balakrishnan.naveen 67 Other 5/15/2013 5/15/2013 2
balakrishnan.naveen 67 Other 5/16/2013 5/16/2013 7
balakrishnan.naveen 74 Meeting 5/16/2013 5/16/2013 2
balakrishnan.naveen 67 Other 5/17/2013 5/17/2013 4
balakrishnan.naveen NULL NULL 5/18/2013 NULL 0 Weekend
balakrishnan.naveen NULL NULL 5/19/2013 NULL 0 Weekend
balakrishnan.naveen 67 Other 5/20/2013 5/20/2013 2
balakrishnan.naveen NULL NULL 5/21/2013 NULL 0
balakrishnan.naveen NULL NULL 5/22/2013 NULL 0
balakrishnan.naveen 67 Other 5/23/2013 5/23/2013 6
balakrishnan.naveen 74 Meeting 5/23/2013 5/23/2013 1
balakrishnan.naveen 74 Meeting 5/24/2013 5/24/2013 1
balakrishnan.naveen 67 Other 5/24/2013 5/24/2013 7
balakrishnan.naveen NULL NULL 5/25/2013 NULL 0 Weekend
balakrishnan.naveen NULL NULL 5/26/2013 NULL 0 Weekend
balakrishnan.naveen 67 Other 5/27/2013 5/27/2013 7
balakrishnan.naveen 74 Meeting 5/27/2013 5/27/2013 1
balakrishnan.naveen NULL NULL 5/28/2013 NULL 0
balakrishnan.naveen NULL NULL 5/29/2013 NULL 0
balakrishnan.naveen NULL NULL 5/30/2013 NULL 0
pavani.k 67 Other 5/1/2013 5/1/2013 1
pavani.k 35 aaa 5/1/2013 5/1/2013 7
pavani.k NULL NULL 5/5/2013 NULL 0 Weekend
pavani.k 67 Other 5/8/2013 5/8/2013 8
pavani.k 67 Other 5/9/2013 5/9/2013 8
pavani.k 67 Other 5/10/2013 5/10/2013 8
pavani.k NULL NULL 5/11/2013 NULL 0 Weekend
pavani.k NULL NULL 5/12/2013 NULL 0 Weekend
pavani.k 67 Other 5/13/2013 5/13/2013 8
pavani.k 67 Other 5/14/2013 5/14/2013 8
pavani.k 67 Other 5/15/2013 5/15/2013 8
pavani.k 67 Other 5/16/2013 5/16/2013 8
pavani.k 67 Other 5/17/2013 5/17/2013 8
pavani.k NULL NULL 5/18/2013 NULL 0 Weekend
pavani.k NULL NULL 5/19/2013 NULL 0 Weekend
pavani.k 67 Other 5/20/2013 5/20/2013 2
pavani.k 40 ccc 5/20/2013 5/20/2013 6
pavani.k 67 Other 5/21/2013 5/21/2013 8
pavani.k 67 Other 5/22/2013 5/22/2013 8
pavani.k NULL NULL 5/23/2013 NULL 0
pavani.k NULL NULL 5/24/2013 NULL 0
pavani.k NULL NULL 5/25/2013 NULL 0 Weekend
pavani.k NULL NULL 5/26/2013 NULL 0 Weekend
pavani.k NULL NULL 5/27/2013 NULL 0
pavani.k NULL NULL 5/28/2013 NULL 0
pavani.k NULL NULL 5/29/2013 NULL 0
pavani.k NULL NULL 5/30/2013 NULL 0


now I want to perform the above rule if any datevalue is missing I have to get that data
according name and I should get project id as null and project name is null and noofworkinghours null,holidayname as null

could u help me out
prakash.chakrala 6-Jun-13 8:13am View
   
could u give any hint
prakash.chakrala 6-Jun-13 8:05am View
   
tried but.......
prakash.chakrala 6-Jun-13 7:33am View
   
I need to replace if status=1 only
and 5 or 6 or 7 means not in one column
either 5 or 6 or 7
prakash.chakrala 6-Jun-13 3:54am View
   
In that solution wherever nulls are available its replacing
prakash.chakrala 6-Jun-13 3:50am View
   
I think this answer is not relavant
prakash.chakrala 31-May-13 4:32am View
   
and i need to get count also.
prakash.chakrala 16-May-13 9:04am View
   
Thank you for your reply
prakash.chakrala 16-May-13 8:25am View
   
Hi Vamshi
Iam getting error and what is tvFolders.ClientID
prakash.chakrala 15-May-13 8:32am View
   
k i agree with you
prakash.chakrala 15-May-13 8:26am View
   
Actually this is my requirement

SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + '-' + DATENAME(MM, GETDATE()) + '-' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [DD Month YYYY]
prakash.chakrala 15-May-13 5:15am View
   
hi its not meeting my requirement.
prakash.chakrala 14-May-13 10:49am View
   
hi
prakash.chakrala 14-May-13 10:45am View
   
I know the logic will be same it will not change.Few minutes back you told that same logic will be useful with adding the last condition how can we achieve the new requirement.Any way i got the solution.Thank you for being the part question.
prakash.chakrala 14-May-13 10:39am View
   
Thank you for your answer .

Actually iam adding month condition
in FROM FullData AS t1 LEFT JOIN @tdata AS t2 ON t1.grp = t2.grp
in this area. so i am not getting correct output so i have clarity in both requirements.

Once again Thank you.
prakash.chakrala 14-May-13 10:27am View
   
Already i have checked the solution but its not giving actual output.
prakash.chakrala 14-May-13 10:13am View
   
That solution will not give correct output.
prakash.chakrala 14-May-13 10:10am View
   
I asked with Month also. and could you read the question once again.
prakash.chakrala 14-May-13 9:57am View
   
i have another requirement that

301 1 june
301 2 june
301 5 june
301 7 june
301 10 june

301 2 july
301 3 july
301 5 july
301 8 july
301 9 july

303 5 june
303 6 june
303 8 june
303 9 june

303 2 july
303 4 july
303 8 july
303 10 july


In this data i want find out missing number in each group.

For example in 301 and june group the missing numbers are 3,4,6,8,9(Assume that the range is 1 to 10)

in 301 and july group the missing numbers are 1,4,6,7,10


like that in all groups
prakash.chakrala 14-May-13 8:12am View
   
k Thank you very much.
prakash.chakrala 14-May-13 8:03am View
   
could u full fill the answer

means where i need to check the answer
prakash.chakrala 14-May-13 7:48am View
   
In 302 group only one value is available i.e.,2
so in 302 the answer has to look like without 2 remaining all numbers from 1 to 10
prakash.chakrala 14-May-13 7:33am View
   
This will not helpful to me.
prakash.chakrala 19-Jan-13 5:06am View
   
problem is not solved
prakash.chakrala 19-Jan-13 2:09am View
   
Deleted
Ravi this code is not working