Viewing 15 posts - 1,516 through 1,530 (of 2,452 total)
Miller (4/14/2014)
How about this? I'd be curious to see results of performance testing with this.
Hi....seems interesting...but really haven't the time right now to test it for you....any reason why you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2014 at 12:25 pm
Japster (4/2/2014)
What I want is
SerialBox SerialNo1 SerialNo2 SerialNo3 SerialNo4 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2014 at 11:36 am
article posted today
http://www.sqlservercentral.com/articles/T-SQL/107611/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2014 at 11:33 am
this will work for your sample data.....but maybe there are other issues as well?
SELECT SVP,
SUM(Wk1) AS wk1,
SUM(Wk2) AS wk2,
SUM(Wk3) AS wk3,
SUM(Wk4) AS wk4,
SUM(Wk5) AS wk5,
Y,
Q
FROM KPI
GROUP BY SVP,Y,Q
ORDER BY SVP,Y,Q
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2014 at 11:15 am
this may help you on your way
http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 7, 2014 at 12:31 pm
this may help you
http://www.connectsql.com/2010/11/sql-server-management-studio-generate.html
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 6, 2014 at 1:51 pm
/*possible proof of concept when applied to wide tables*/
/*response to Jeff's comments
"Also, because you have to make a copy of both the INSERTED and DELETED logical trigger tables,
this could...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 6, 2014 at 12:41 pm
Hi Jeff.....really appreciate your comments.
my thoughts and response to your post below:
Just a couple of recommendations on this type of generic "field-level" trigger.
First, the PK, OldValue, and NewValue columns should...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 6, 2014 at 10:56 am
the following may help you on your way
/*This provides code to create a trigger on any table to record changes in the data
the changes made are recorded in a single...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 6, 2014 at 7:17 am
Eirikur Eiriksson (4/5/2014)
J Livingston SQL (4/5/2014)
some significant changes between these two editions.....which one is in use now?
Lets do both with the same solution
😎
/* SAMPLE DATA */
SELECT
X.NUM
INTO...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 5, 2014 at 12:24 pm
rui_leote (4/5/2014)
Humm, wrong. Shame on me. It is SQL 2008 or 2012Sorry about this.
some significant changes between these two editions.....which one is in use now?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 5, 2014 at 11:35 am
maybe more helpful to all of us (including your goodself) , if you provide some set up scripts for tables and sample data and expected results......that way we can address...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 5, 2014 at 10:26 am
this may get you started
IF NOT EXISTS (
SELECT *
FROM sys.objects
WHERE object_id = OBJECT_ID(N'[YOURTABLE]') AND type IN (N'U')
)
BEGIN
CREATE TABLE [YOURTABLE] ([num] [int] NOT NULL) ON [PRIMARY]
END
GO
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 5, 2014 at 10:22 am
just to be absolutely sure....you are running SQL 7 or SQL 2000....not a later version?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 5, 2014 at 9:36 am
this may help you on your way....
USE [tempdb]
GO
-- reconfigured your original query...and removed the subeselects and aliases
-- hopefully you can follow structure
SELECT s_element.sendeplatz,
jingle.sztitle,
arolle.szname AS ptype,
aperson.szname AS pname,
publisher.szname AS pub,
jingle.lid AS...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 5, 2014 at 6:18 am
Viewing 15 posts - 1,516 through 1,530 (of 2,452 total)