Comments by prakash.chakrala

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

Hiafter 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

Comments by prakash.chakrala (Top 41 by date)