Viewing 15 posts - 661 through 675 (of 2,268 total)
you can add a sort transformation and check the box to remove duplicates based upon the sort key,
or you could put the data as is in a staging table and...
January 13, 2011 at 8:54 am
for an app to recognise failover you will need to put this in the connection string (Failover partner= ) for .NET not sure about syntax for other systems.
The situation you...
January 13, 2011 at 8:47 am
craigbroadman (1/13/2011)
If not, does anyone have any thoughts on if this is actually needed in a system using SQL Server?
I would say no, you are trying to mimick...
January 13, 2011 at 8:35 am
it depends on what caused the failover, if its something db specific then the other non - mirrored db should be fine.
If it is server specific then you...
January 13, 2011 at 8:29 am
no, its a breach of the terms of taking the cert to use or pass-on brain dumps
January 10, 2011 at 7:14 am
are there any parameters being used?
Also need more detail..
January 7, 2011 at 9:51 am
what is the purpose of this line in the code
SET @Item = (SELECT item from ItemMaster)
what would you expect @item to be populated with if there are 38,000 rows in...
January 7, 2011 at 9:50 am
Agree with the comments about lazy developers, just a word of warning, i was faced with the exact same situaiton last year where the devs thought it was easier...
January 7, 2011 at 9:44 am
the error you are getting is relating to the set statement, there must be more than one row in the ItemMaster table, and you are trying to...
January 7, 2011 at 9:29 am
if you want to return all the data then why do you need to use a variable and where clause?
try
SELECT i.item,
i.description,
i.u_m,
i.product_code,
i.unit_cost,
w.whse,
w.qty_on_hand
FROM ItemMaster i
INNER JOIN itemwhse w ON i.item = w.item
WHERE...
January 7, 2011 at 9:16 am
AVB (1/7/2011)
steveb,Thanks for the reply. Well that explains it. My BOL doesn't say anything about that in the Replace String Function command explanation. Go figure.
no worries, its in the 2008r2...
January 7, 2011 at 7:20 am
from books on line
string_pattern
Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string ('').
January 7, 2011 at 7:06 am
in an overview, you could either have one source sql statement for your data flow and then in the data flow split the data out based on the...
January 6, 2011 at 6:56 am
you could do this using a conditional split, or even by using multiple SQL source statements doing the join.
January 6, 2011 at 5:35 am
Viewing 15 posts - 661 through 675 (of 2,268 total)