Viewing 15 posts - 301 through 315 (of 402 total)
No Probs 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 4:45 am
Its not pretty and there are better ways but without more information it is difficult to provide a solution.
CREATE TABLE #temp
(TextValue VARCHAR (5))
INSERT INTO #temp
SELECT 'efg' UNION ALL
SELECT 'abc' UNION...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 4:41 am
Hi
You'll need to nest another IIF, something like this:
=FormatDateTime(IIF(IsNothing(Fields!Planneddate.Value), IIF(IsNothing(Fields!appl_status_date.Value)," " , Fields!ActualDate.Value)))
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 3:07 am
Hi
Just a slight amendment to the query posted previously should do the trick for you
SELECT *
FROM #table1
WHERE
(ItemID LIKE 'LGE%' OR ItemID LIKE 'SAM%' OR ItemID LIKE 'HTC%')
OR...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 2:35 am
Your requirement is logically inconsistent.
Welcome to my world! I can't tell you how many times I've had to do some funky code to get around some requirements!!
To be honest I'm...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 3, 2012 at 8:47 am
I know whats coming next - why then the company A filter!!
I think I need to have a think how to explain this better!:crazy:
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 3, 2012 at 7:42 am
Cadavre (4/3/2012)
You said. . .
Andy Hyslop (4/3/2012)
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 3, 2012 at 7:35 am
There should really be nothing as "stage database". It should be stage tables
It depends I've seen warehouses where the staging tables are contained within the main DW and also (my...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 3, 2012 at 5:31 am
You can't alter a column and add IDENTITY, You have either create a new table or drop the column and re add with the IDENTITY property
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 3, 2012 at 4:08 am
Koen Verbeeck (4/3/2012)
They are technology independant, so it should be your first read if you really want to go...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 3, 2012 at 3:59 am
You may also find these useful:
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 3, 2012 at 2:52 am
No probs 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 30, 2012 at 8:50 am
I've never had to do this, however the link below may help you (it was interesting looking into it however thanks 🙂 )
http://blog.hoegaerden.be/2011/01/18/ssrs-hideshow-items-dependant-on-export-format/
Its not quite the same as what you...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 30, 2012 at 8:50 am
Welsh Corgi (3/30/2012)
Could someone please provide me with a script for a Database and Table to Store the Package Configurations?Thanks.
When you choose to use the SQL Server package configs SSIS...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 30, 2012 at 8:18 am
Hi Anthony
Just a thought as I have only worked with XML configuration files a couple of times but have you tried using the SQL config tables instead of XML...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 30, 2012 at 7:49 am
Viewing 15 posts - 301 through 315 (of 402 total)