Viewing 15 posts - 571 through 585 (of 2,452 total)
Newbi (6/30/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 7:00 am
Newbi (6/30/2016)
I don't know how to display well enough here according to the guidelines of the forum. :crying:
try this article for future reference:
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
however in this case it may not be...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 6:51 am
twin.devil (6/30/2016)
Newbi (6/30/2016)
Because SSRS designing alone cannot fulfill my requirements.Shed some light on it.
and please post some sample data so that we can all work on the same data set...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 6:21 am
JoNTSQLSrv (6/30/2016)
J Livingston SQL (6/29/2016)
For knowledge shake, is it possible to implement the same result in while loop ?why?
what benefits do you perceive you will gain by using a while...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 2:12 am
chased for Service Improvements
chased by whom?
what are they asking for?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 29, 2016 at 7:56 am
For knowledge shake, is it possible to implement the same result in while loop ?
why?
what benefits do you perceive you will gain by using a while loop......?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 29, 2016 at 2:20 am
maybe.....??
USE [tempdb]
GO
CREATE TABLE [dbo].[Data_Details](
[ICode] [int] NULL,
[Quantity] [int] NULL
)
GO
INSERT [dbo].[Data_Details] ([ICode], [Quantity]) VALUES (1, 23)
INSERT [dbo].[Data_Details] ([ICode], [Quantity]) VALUES (1, -15)
INSERT [dbo].[Data_Details] ([ICode], [Quantity]) VALUES (1, 17)
INSERT [dbo].[Data_Details] ([ICode], [Quantity])...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 28, 2016 at 4:42 am
Please help me improving my sql thinking according to any bsiness requirement .. help me and suggest some books or sites .. thanks in advance
suggest you stick around this site....read...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 28, 2016 at 3:41 am
you can try this......in all honesty I would be looking to review your tables and make recommendations so that the initial cte below is not required.
that said....
WITH TT as (
SELECT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 27, 2016 at 11:01 am
JoNTSQLSrv (6/27/2016)
J Livingston SQL (6/27/2016)
Actually.... is this...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 27, 2016 at 10:16 am
I see in Credit_Mater table you have now added a second set of data for "Party" = 2......what is the significance of this please?
Actually.... is this a real world table...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 27, 2016 at 8:49 am
Jeff Moden (6/27/2016)
Nomvula (6/27/2016)
thank you so much J Livingston SQL,it worked perfectly!!!
Since you're the one that needs to support it, the question now is... can you? Do you actually...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 27, 2016 at 8:36 am
JoNTSQLSrv (6/26/2016)
J Livingston SQL (6/26/2016)
JoNTSQLSrv (6/26/2016)
GilaMonster (6/26/2016)
JoNTSQLSrv (6/26/2016)
it does nt work 🙁
Be specific. What exactly is wrong? Wrong results? If so, where and what should the results be?...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 27, 2016 at 3:38 am
JoNTSQLSrv (6/26/2016)
GilaMonster (6/26/2016)
JoNTSQLSrv (6/26/2016)
it does nt work 🙁
Be specific. What exactly is wrong? Wrong results? If so, where and what should the results be? Throws an error? If...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 26, 2016 at 12:30 pm
JoNTSQLSrv (6/26/2016)
previously i put wrong data in urgent, please check now in the main post .. it is perfect data .....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 26, 2016 at 11:35 am
Viewing 15 posts - 571 through 585 (of 2,452 total)