Viewing 15 posts - 1,441 through 1,455 (of 2,452 total)
my take on the QU process.....virtually same as Craig's but I think I have added in all the safety checks required ....
uses a million row test table.
all credit should...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 23, 2014 at 10:42 am
does this help.....??
http://www.sqlservercentral.com/Forums/FindPost1517185.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 22, 2014 at 9:47 am
what are you expecting to achieve by moving from SQLexpress?
obviously there will be costs for your company...but what benefits?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 19, 2014 at 10:48 am
jdasilva (5/13/2014)
I did comment it all out and try just the bare bones, and that worked.
I am not the best at the syntax for SQL, so...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2014 at 12:22 pm
assuming you already have
dbo_StaffListings and dbo_OfficeCodes table created and data populated in SQL server
then
start from scratch and rebuild in SQL...I don't think there is shorterm quick fix for all...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2014 at 11:32 am
deepujagan (5/13/2014)
yes..I need the largest value among the 3 values and display either a Credit or Debit (+/-).
can you please post back an insert data script with your expected...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2014 at 6:34 am
is this anywhere close.....
SELECT id , COMM1, COMM2, COMM3 , QTY,
( SELECT CAST( ISNULL(MAX ( V ) ,0) as numeric(6,2))
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2014 at 5:59 am
first off...the correct way of presenting data...based on your spreadsheet.
USE [tempdb]
CREATE TABLE [dbo].[yourtable](
[ID] [int] IDENTITY(1,1) NOT NULL,
[COMM1] [decimal](18, 2) NULL,
[COMM2] [decimal](18, 2) NULL,
[COMM3] [decimal](18, 2) NULL,
[QTY] [decimal](18, 2) NULL
) ON...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2014 at 5:31 am
deepujagan (5/13/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2014 at 4:43 am
haddoque2000 (5/13/2014)
CREATE TABLE [dbo].[FactFinance](
[FinanceKey] [int] IDENTITY(1,1) NOT NULL,
[DateKey] [int] NOT NULL,
[OrganizationKey] [int] NOT NULL,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2014 at 2:03 am
haddoque2000 (5/11/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 11, 2014 at 11:36 am
robin.pryor (5/9/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 9, 2014 at 1:39 pm
rf44 (5/9/2014)
Sean Lange (5/9/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 9, 2014 at 1:06 pm
this may or may not help you....years back, I used to do something similar to what you are experiencing and running for multiple sites across a slow WAN.
if I recall,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 9, 2014 at 10:25 am
is/can your form be based on a single table/sql query?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 9, 2014 at 8:12 am
Viewing 15 posts - 1,441 through 1,455 (of 2,452 total)