Viewing 15 posts - 46 through 60 (of 97 total)
Hi
i modified the query as you said
still data inconsistent. i think problem is, it has to chk for the deptname with that emp and joineddate between values.here deptname is...
November 4, 2009 at 6:39 am
hi Lewis Dowson
thank you very much.
this works fine. but i am getting inconsistent data like
execute test '5689','06/01/2008','10/10/2008'
but i am getting values from year 2004 to 2009. it is not...
November 4, 2009 at 4:31 am
i have modified the proc as per Lewis Dowson
create proc test
(@empid varchar(30)
,@fromdate date
,@todate date
)
as
begin
declare @dept varchar(50),@sql nvarchar(max)
select @dept=deptname from emp_dept where empid= @empid;
set@sql=@sql+' select firstname,lastname,sal'+char(30)
+'from emp'+char(10)
+' where dept in...
November 3, 2009 at 12:47 pm
i got it.
Thank you very much Lowell
November 1, 2009 at 10:15 am
hi
adding the quotation also, i can not able to retrieve values
ex1:
declare @var varchar(100)
set @var=''
select @var='''' + REPLACE(name,',',''',''') + ''''
from test
print @var
select name from test1 where name in...
October 31, 2009 at 11:34 pm
some of the developers working in .net application and specified the min and max connections limit. the problem is they didn't close the connections properly. when the connections reached to...
October 16, 2009 at 2:09 am
Actually, i want to close the connections who are connected for long hours and their status is sleeping. because of too many connections in the server.
can you guide me
Thanks...
October 16, 2009 at 1:32 am
I Got it
Thanks alot
Regards
Rock..
October 13, 2009 at 1:44 am
yup, i got it
Thank you very much Guys for your valuable support
Regards
Rock..
October 12, 2009 at 1:40 pm
actually i have comma seperated values in a single record. one record constains many comma seperated values. i need to seperate each value, by using comma i need to get...
October 12, 2009 at 12:10 pm
here reportingperiod is a datatime datatype
i am getting month no from it. i executed the function.
CREATE FUNCTION iter$simple_intlist_to_tbl (@list nvarchar(MAX))
RETURNS @tbl TABLE (number int NOT NULL) AS
BEGIN
...
October 12, 2009 at 7:34 am
levelid and levelname are not globally unique. because Custid will have levelid as 1 and levelname as newyork. and every customer will starts his levelid from 1 only (in...
October 7, 2009 at 11:06 pm
i apologize, please go through the below sample data for the tables.
table1:
Custid levelid levelname fromlength tolength
ABC 1...
October 7, 2009 at 10:04 am
I agree with your valuable comments for Query 1.
I have a scenario like
table 1: custid
levelid
levelname
fromlength
tolength
.
In table 1, i have to define the length for the levels to that customer.so...
October 7, 2009 at 8:59 am
Viewing 15 posts - 46 through 60 (of 97 total)