Viewing 15 posts - 91 through 105 (of 172 total)
I love reverse engineering databases! Its like a big puzzle
It's perverse but I'm so with you on this. I think it appeals to my need for bringing order out...
February 14, 2012 at 6:08 pm
There are a number of articles and threads on this subject. Enter CTE in the search box up thar on the right and you'll see what I mean. ...
February 14, 2012 at 5:11 pm
--first create some tables
create table #SHP_MANIFEST (
Row_key int null,
SHIP_DATE_DWKEY int null,
PRIMARY_DC_ID int null
)
create table #SUBORDERS (
ROW_KEY int null,
PRIMARY_DC_ID int null,
DC_ID int null
)
--then add your test data
insert into...
February 13, 2012 at 2:15 pm
What exactly do you mean by none method?
Probably just a contraction of Number One ! 😛
February 13, 2012 at 1:50 pm
The bank I'm at keeps things locked down pretty tight electronically. There are no external drives on my desktop machine, and I can't open any web email programs on...
February 10, 2012 at 4:26 pm
Sounds like you have a page break somewhere
February 2, 2012 at 5:58 pm
You tried the sort in the group properties?
February 1, 2012 at 6:42 pm
You can add a group header. Right click on the group and add total row, insert above for header. It's a little misleading. Add your company name...
February 1, 2012 at 6:35 pm
#1 of course, and the TranType should probably be a foreign key from another table where you describe tran types, rather than a varchar field in your transaction table.
February 1, 2012 at 6:26 pm
Have you considered using SSRS instead? You can control the pagination, tabs and tab labels quite handily, and schedule the delivery to your users.
February 1, 2012 at 12:38 pm
PAUL WHITE ROCKS!!!!
seeeeeeeriously
February 1, 2012 at 12:31 pm
wouldn't a simple group by accomplish the goal?
SELECT
SBBACLOAN
,[SBNAME1]
,[SBBRSSN]
,[SBNAME2]
,[SBCOBRSSN]
,APPRVLDTE=max(APPRVLDTE)
FROM [WarehouseStaging].[dbo].[AS400_ALSSLBACOUTP0]
WHERE APPRVLDTE is not null and APPRVLDTE <> '0001-01-01'
group by
SBBACLOAN
,[SBNAME1]
,[SBBRSSN]
,[SBNAME2]
,[SBCOBRSSN]
Maybe I misread. Please correct me. 😀
January 26, 2012 at 5:06 pm
I think what you want to do is add a single Tablix control. Add a row group for whichever field makes LOGS unique, make sure to include a group...
January 25, 2012 at 4:52 pm
Viewing 15 posts - 91 through 105 (of 172 total)