Viewing 15 posts - 1,816 through 1,830 (of 2,452 total)
ashwinrao.k23 (8/10/2012)
thanks for the Reply!If i use Aggregate functions then its eating some of my data fileds. For MAX its giving only maximim valuse of available filds..
hmm...just a thought, but...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2012 at 12:31 pm
ashwinrao.k23 (8/10/2012)
thanks for the Reply!If i use Aggregate functions then its eating some of my data fileds. For MAX its giving only maximim valuse of available filds..
not quite sure what...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2012 at 12:07 pm
ashwinrao.k23 (8/10/2012)
Yes, I have only two group of values "A" and "B" need to be pivoted
ok...in which case the solution from rVadim will work for you.
for more info, suggest you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2012 at 11:44 am
Hi
will you only "ever" have columns A and B to pivot on?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2012 at 11:27 am
whats supposed to happen if you have these records?
INSERT INTO #Site (site_id, location_id, [description])
VALUES ('06', '18a4', '18a4'),
('06', '18a5', '18a5'),
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2012 at 10:34 am
priest Ivan Delic (8/10/2012)
Thanks for the quick answer.I simply want to copy my data from table2, table3 to table1.
I have about 25,000 records.
Fr. Ivan Delic
what are tables 1,2,3?
what are the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2012 at 8:22 am
SELECT(2 + 3) * 4;
SELECT 2 + (3 * 4);
SELECT 2 + 3 * 4;
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2012 at 1:42 am
at this juncture, it may be prudent to provide some further sample detail to fully describe the
possible permutations of the millions of records you have.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 8, 2012 at 2:01 pm
GSquared (8/8/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 8, 2012 at 12:25 pm
Luis Cazares (8/8/2012)
It's easy to learn and has a simple GUI.
Scripting is very similar to T-SQL and can be protected to prevent...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 8, 2012 at 12:12 pm
Luis Cazares (8/7/2012)
If you're looking for a nice tool that can be easy for the execs to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 8, 2012 at 11:59 am
USE [tempdb]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[testmonths]') AND type in (N'U'))
DROP TABLE [dbo].[testmonths]
GO
CREATE TABLE [dbo].[testmonths](
[testMonth] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[testmonths]([testMonth])
SELECT N'May-11' UNION ALL
SELECT N'May-12'...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 7, 2012 at 8:27 am
what are the are datatypes of dbo.BVActions.orderedTime and dbo.BVActions.ScheduledTime
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 7, 2012 at 7:58 am
as an idea....is this anywhere close to what you are looking for?
SELECT MERCHANDISING_WEEK_START_DATE ,
DATEPART( WEEK , MERCHANDISING_WEEK_START_DATE ) - DATEPART( WEEK ,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 7, 2012 at 2:09 am
asm1212 (8/6/2012)
...Im selecting about 50+ more columns than what I specified and therefore you have to group by all 50+ columns...
no offence...but 50 levels of grouping seems a lot...are you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 3:44 pm
Viewing 15 posts - 1,816 through 1,830 (of 2,452 total)