Yeah i agree,but the reason is its our maintainence and enhancement project and database size is 18 gb. Once again thanks. Regards Parveen.
Hi, I think that can be done with this ,what say ? ;WITH cte AS(SELECT ROW_NUMBER() OVER (ORDER BY SUM(paidAmount) DESC) AS rn, MAX(S.Customer)...
Yes Frank Thanks a lot, That works fine but just need to add that substring part.cause there is inconsistency in data,so i need to add up all that...
Hi Frank thanks for your reply, I shall be more clear with data and requirement. sample data as follows - ( I have added few rows to previous data...
Hi friends, My sample data is as follows DECLARE @Sample TABLE ( fbNumINT, Customervarchar(50), paidAmountFLOAT, WeightINT ) INSERT INTO...
Hi friends, Can we use this to display dependent tables,which are used in dynamic queries inside stored procedures ? Thanks & regards Parveen
Hi Friends, Have a best of 2009 and fabulous year ahead.Hope you all get the better and better opportunities in 2009. Warm regards,...
Hi, Thanks a lot friends. Thanks & Regards Parveen.
Hi friends, Thanks a much for your replies.So I can takeit as better to have separate procedures.The intention behind thequestion was just to...
Hi Friends, A Fairly simple question.As i am into more of development part of database,What is standard way of writing Stored procedures,say...
Hi, Do you mean something like this ? SELECT * FROM TABLE WHERE Column_ID NOT IN (SELECT TOP 5 Column_ID FROM TABLE) Regards parveen.
Hi, Try this out. declare @date1 datetime declare @date2 datetime declare @day varchar(50) DECLARE @CountSunDay INT ,@CountMonDay INT ,@CountTueDay...
Hi, Yeah,actually this was regarding if any one has done such analysis,such as a real time example to get Maximum units to get produced to meet the...
Hello friends, We have to do the input output analysis (Leontief 's models) on captured data about report flows in an organization. We have to solve...
Hi friends, I wanted some information about latest certifications,to which i can go for ? I wanted to go for database development side.As...
Yes Madhivanan,that was good link, Thanx for this information. Parveen. Don't take life so seriously, you will never get out of it alive.
Thanks a lot friends.. for your reply. Don't take life so seriously, you will never get out of it alive.
Hello friends, When we write joins for tables in stored procedure,Does the join eliminates rows before Where condition. Suppose a query like...
Hi Yes Ranjit, As if now we are also doing the same thing,reading the file till Go n executing.But there may be any option for that ? I would...
Hi, Friends, Is there any option other than GO command, for Create Procedures (functions,views etc)Script ( i.e Multiple create procedure...
Separate names with a comma.
