Viewing 15 posts - 16 through 30 (of 47 total)
Why Can't you just use:
update xxx set account_nbr = '00' + account_nbr
update xxx set au_entity = '00' + au_entity
June 2, 2010 at 10:15 am
How much memory do you have on the Server? E.g. If you have 4GB then it doesn't mean 4GB is available for BI!!..
June 2, 2010 at 10:09 am
Use Len(Ltrim(Rtrim(Column_Name))) in your Check Constraint
June 2, 2010 at 10:07 am
Thank you GSquared; That trick solved this issue right away. Thanks a lot!!! 🙂
November 11, 2009 at 9:25 am
Please give some more detail...
November 11, 2009 at 9:16 am
Thanks a lot bitbucket-25253; that worked like magic. I also tried using NTILE and it worked with that too.
Thanks again.
-RP
November 10, 2009 at 9:03 am
I wonder if that works even in 2005!!!!
You may want to try something similar to this: It gives you same output; If, I understood your request correctly!!!!
SELECT T1.Val1, T1.Val2, T2.Val1,...
October 16, 2009 at 1:46 pm
Thanks a lot... it solved my issue right away.
-RP
October 16, 2009 at 12:45 pm
Thanks John for that correction.,
I was checking randomly for trigger on my sample database and had that like operator and forgot to remove it prior to posting it here.
-RP
October 15, 2009 at 7:33 am
IF EXISTS (select * from sysobjects where name like '%reminder2%')
DROP TRIGGER reminder2
go
CREATE TRIGGER reminder2
ON Sales.Customer FOR INSERT AS
BEGIN
select 1
END
Try this...
October 14, 2009 at 2:51 pm
Thanks for the link emily-1119612, it points to a very helpful website.
October 2, 2009 at 2:17 pm
Hello GSquared,
Yes, we don't need it for XML, but i need to add line feed after every end tag. We are sending these xml files to third party for further...
August 25, 2009 at 2:23 pm
haha.. happens sometimes.. happened to me too...
Happy coding
-RP
June 10, 2009 at 2:23 pm
Nope, It will not help, not going to use any custom tool as long as possible. If I won't be able to generate using SSRS then, other developer is ready...
June 6, 2009 at 8:24 am
Viewing 15 posts - 16 through 30 (of 47 total)