Viewing 15 posts - 8,926 through 8,940 (of 13,876 total)
How are you trying to execute the package?
November 19, 2014 at 8:26 am
monilps (11/18/2014)
Can anyone please help me how to write query with PRINT Statement for below query.
WITH CTE1 AS (SELECT * FROM table1),
CTE2...
November 18, 2014 at 12:02 pm
scuby.me (11/18/2014)
I have two tables in SQL server database. i want to compare both tables and differentiate like if the rows match then go to matched output otherwise to no...
November 18, 2014 at 9:34 am
kriskumark96 (11/17/2014)
The three queries is of the same tables with different where condition are used , so that we cannot have a join or cross join on it
Or
Is there any...
November 18, 2014 at 12:21 am
kriskumark96 (11/17/2014)
Thanks for the Reply, Union All Condition combines the Values , but i need a query
like
select col1,col5,col8 from queries 1 ,2 ,3.
i need to take each column...
November 17, 2014 at 7:30 am
Try configuring the SQL Agent job to run the package in 32-bit mode in the Configuration / Advanced section of the Job Step properties.
November 17, 2014 at 1:11 am
uravindarreddy (11/17/2014)
Does all this involve data migration too?Thats too complex.
Really looking forward for your methodology.
It does involve data migration and the databases power our websites, so we need to...
November 17, 2014 at 12:59 am
Jeff Moden (11/15/2014)
Phil Parkin (11/14/2014)
I've been working on a task to consolidate three databases down to two...
That sounds like a lot of work. My question would be WHY? ...
November 17, 2014 at 12:47 am
Can you provide a link or some background to your question please? I don't know what you are referring to.
November 13, 2014 at 5:28 am
karthik M (11/13/2014)
Does Triangular Join use O(N2/2) ?
Are you writing a thesis, or is there some practical reason for your questions?
November 13, 2014 at 4:32 am
Phil Parkin (11/13/2014)
karthik82.vk (11/13/2014)
Hi,The values comes from the database, so i will not be able to hardcore them.
Is there any way to get the desired output?
Of course. Just remove the...
November 13, 2014 at 2:15 am
karthik82.vk (11/13/2014)
Hi,The values comes from the database, so i will not be able to hardcore them.
Is there any way to get the desired output?
Of course. Just remove the CTE and...
November 13, 2014 at 2:13 am
Another slightly simpler version (thanks pietlinden for the data subquery):
with data
as (select 'P1' as Product_Name
...
November 13, 2014 at 12:30 am
Koen Verbeeck (11/12/2014)
arunnrj87 (11/12/2014)
Hi Phil ,Please reply
Please be aware that this is a forum of volunteers, where most of them have day time jobs as well.
Yep, this includes me. I...
November 12, 2014 at 6:34 am
OK, so is this solved now?
If not, please provide three or four sample file names, so that we can help with the Derived Column expression.
November 12, 2014 at 5:53 am
Viewing 15 posts - 8,926 through 8,940 (of 13,876 total)